M C Q s D r i v e
03079682698
mcqsdrive@gmail.com
About
Contact
Jobs
Blog

Contact Info

03079682698

mcqsdrive@gmail.com

Ad Banner

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.

All Topics  1983

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

in MS-Excel__________ short cut key is used for hiding rows.

A Ctrl+H
B Ctrl+7
C Ctrl+9
D None of the above
Correct Answer: Ctrl+9

Which of following is not an element of computer spreadsheet interface?

A Pencil work
B Active cell
C Menu bar
D Workbook
Correct Answer: Pencil work

Computer spreadsheet capability to allow a pie chart to be generated from data in spreadsheet cells is termed as __________ ?

A Decoration
B Data appearance
C Functions
D Charting
Correct Answer: Charting

What is a cell in Excel?

A A row
B A column
C A unit of data
D A unit of formatting
Correct Answer: A unit of data

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
03079682698
mcqsdrive@gmail.com

Copyright @ 2026 MCQsDrive . All Rights Reserved.