M C Q s D r i v e

Computer Science Mcqs 1977 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