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.

In a computer spreadsheet, function which is used to count numbers of entries in given range is called __________ ?

A Length
B Counter
C Count
D None of These
Correct Answer: Count

What does the term ?filter? refer to in Excel?

A To permanently delete rows or columns
B To format the appearance of cells
C To temporarily hide certain data based on specific criteria
D To create a chart
Correct Answer: To temporarily hide certain data based on specific criteria

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