M C Q s D r i v e

Computer Science Mcqs 1985 MCQs [All-Courses]

thumb

Get exam-focused Computer MCQs covering everything from basic computer fundamentals to advanced topics. Prepare for PPSC, FPSC, NTS, OTS, PTS, KPPSC, BPSC, AJKPSC, PMS, CSS, and Computer Operator tests with 1977+ solved MCQs. Topics include MS Office, MS Word, MS Excel, PowerPoint, Computer Networking, Hardware, Software, and Cyber Security. Whether you are a beginner or preparing for a written test or screening, MCQsDrive covers all courses to help you score higher.

What is the use of a horizontal Scroll Bar in MS Excel?

A to view the data from left to the right
B to view the data in Excel from up and down
C to view the data from right to the left
D None of these
Correct Answer: to view the data from left to the right

Ctrl +U is used for ____________________?

A underline
B italic
C bold
D none
Correct Answer: underline

________________________ is not a valid data type in excel?

A Number
B Label
C Character
D none
Correct Answer: Character

In MS Word, the shortcut for paste command is _________________________?

A Ctrl+V
B Ctrl+X
C Alt+X
D Shift+Alt+X
Correct Answer: Ctrl+V

Which shortcut key is for auto sum ?

A Alt + =
B Ctrl + Shift
C Alt + F1
D Ctrl + =
Correct Answer: Alt + =

Which shortkey is suitable for reach at the last Row of MS Excel?

A Ctrl + Space
B Shift + Ctrl +Enter
C Ctrl + Down Arrow
D Ctrl + =
Correct Answer: Ctrl + Down Arrow

Which of the following is last column in MS Excel-2016?

A XFD
B ZZZ
C ZXF
D ZAZ
Correct Answer: XFD

In MS Excel, you have a list of sales data in column A, and you need to find the second highest unique value in this list. Which of the following formulas will correctly return the second highest unique value?

A #NUM!
B #NUM!
C You can edit existing Excel data by pressing the:________ key?
D #NUM!
Correct Answer: You can edit existing Excel data by pressing the:________ key?

In MS Excel, which of the following functions can be used to remove all spaces from a text string except for single spaces between words?

A TRIM
B SUBSTITUTE
C CLEAN
D REPT
Correct Answer: TRIM

What is a group of cells called in Excel?

A Cell Range
B Workbook
C Margin
D None of these
Correct Answer: Cell Range