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 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

In excel columns are labelled as____________?

A A, B, C, etc.
B 1, 2, 3, etc.
C A1, A2, A3, etc.
D $A$1, $A$2, etc.
Correct Answer: A, B, C, etc.

which of the following is not a valid Zoom percentage in Excel?

A 10
B 100
C 300
D 500
Correct Answer: 500

User developed instruction for excel are called__________?

A Progrms
B Macros
C Procedured
D All of these
Correct Answer: Macros