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

Contact Info

03079682698

mcqsdrive@gmail.com

Ad Banner

Computer Science Mcqs 1971 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.

All Topics  1971

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.