Solved Microsoft Excel (Office Applications) MCQs:

Microsoft Excel MCQs for Competitive Exams

Practice with answers, explanations, and exam-focused revision notes.

2246 MCQs Page 12

Topic Notes: Microsoft Excel

These notes summarize the key preparation context before you attempt the MCQs. Review the topic focus, then practice the questions below with answers and explanations.

Quick Overview

Microsoft Excel MCQs in Computer Science - IT are useful for candidates who need targeted practice for CSS, PMS, FPSC, PPSC, NTS, entry tests, and other competitive exams in Pakistan. This topic page is designed for quick revision, repeated practice, and exam-focused preparation.

Attempt the questions page by page, check the correct answers, read the explanations where available, and compare your weak areas with past papers and mock test performance. Consistent MCQ practice improves speed, confidence, and retention for objective exam sections.

Want adaptive tracking for this topic?

Session Progress 0 / 0 Solved

Reveal answers to start tracking your session progress!

111

How can you configure text within a cell to appear vertically in Microsoft Excel?

A Choose Distributed from the Vertical drop down list of Format Cells dialog box B Choose Vertical on Text alignment in Format Cells dialog box C Choose Center Across Selection from Horizontal combo box in Format Cells dialog box D Choose 90 Degrees in Orientation of Format Cells dialog box

112

To effectively visualize data, what must a PivotChart be linked to within a spreadsheet application?

113

What is the correct syntax error in the Excel formula '=Average (B9, B12)'?

114

What is the primary function of the COUNTA() formula in Microsoft Excel?

115

Which tool button in Microsoft Excel allows users to quickly calculate the sum of a large range of data?

116

Which ribbon tab in Microsoft Excel contains the tools necessary to add a comment to a specific worksheet cell?

117

What is the most efficient method to create a sequential number series, such as 1 through 20, in Excel?

A Select the range you want, include both cells, point to fill on the Edit menu, and then click down. B Select both cells, and then drag the fill handle over the range you want, for instance 18 more rows C All of above D Copy the second cell, click in the cell below it, on the standard toolbar click the down arrow on the Paste button, and then click Paste Special

118

How can you configure a cell to accept only whole numbers within the range of 9 to 99?

A The Settings tab under the menu Data -> Validation B The Settings tab under the menu Data -> Filter -> Advanced Filter C the Settings tab under the menu Format -> Conditional Formatting D The Settings tab under the menu Format -> Cells

119

What is the standard keyboard shortcut to open the 'Find and Replace' dialog box in most Microsoft applications?

120

What is the standard file extension for files created using the Lotus 1-2-3 spreadsheet application?

Microsoft Excel MCQs for Competitive Exams

Microsoft Excel MCQs for Competitive Exams

Topic Notes: Microsoft Excel

Quick Overview

Browse categories

Mock Test

Latest Menu

Popular Categories