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