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.

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