M C Q s D r i v e

Computer Science Mcqs 1983 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 are the small squares arranged in rows and columns called in Excel?

A Cells
B Columns
C Blocks
D Rows
Correct Answer: Cells

In Ms Excel Ready made templates are available under _______ tab ?

A File
B Insert
C Design
D None of Above
Correct Answer: File

Maximum zoom percentage in Excel is _________?

A 100%
B 300%
C 400%
D 500%
Correct Answer: 400%

Default file name in MS Excel is?

A Document 1
B Workbook 1
C Book1
D Worksheet
Correct Answer: Book1

To insert chart in MS Excel, which shortcut key used?

A Alt+F1
B F2
C F3
D F4
Correct Answer: Alt+F1

What is the function of the VLOOKUP function in Excel?

A To perform a vertical lookup and return a value based on a specified criteria
B To perform a horizontal lookup and return a value based on a specified criteria
C To add up a range of cells
D To find the average of a range of cells
Correct Answer: To perform a vertical lookup and return a value based on a specified criteria

What is the function of the IF function in Excel?

A To perform a logical test and return a value based on the result
B To add up a range of cells
C To find the average of a range of cells
D To count the number of cells in a range
Correct Answer: To perform a logical test and return a value based on the result

What is the function of the SUM function in Excel?

A To add up a range of cells
B To find the average of a range of cells
C To count the number of cells in a range
D To find the maximum value in a range of cells
Correct Answer: To add up a range of cells

What is the intersection of a column and row called in Excel?

A A cell
B A range
C A column header
D A row header
Correct Answer: A cell

Title bar in MS-Excel displays name of the __________ ?

A Worksheet
B Workbook
C Formula
D Location
Correct Answer: Workbook