M C Q s D r i v e

Computer Science Mcqs 1973 MCQs [All-Courses]

thumb

Get exam-focused Computer MCQs for PPSC, FPSC, NTS, OTS, PTS, AJKPSC, BPSC, KPPSC, PMS, CSS, and all competitive exams.Boost your IT knowledge with MCQs on Computer Basics, MS Office, Networking, Hardware, Software, and Cyber Security.Improve accuracy, strengthen concepts, and prepare smartly for any screening or written test.

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