M C Q s D r i v e

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.

By default, how many worksheets are there in a new Microsoft Excel workbook?
A 1
B 3
C 5
D 10
Correct Answer: 1
What is the maximum number of rows that can be used in Microsoft Excel (Excel 2016 and later)?
A 500,000
B 100,000
C 65,536
D 1,048,576
Correct Answer: 1,048,576
In Excel, Conditional formatting is in: ______________?
A Insert Tab
B Page layout
C View Tab
D Home Tab
Correct Answer: Home Tab
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