MS Excel MCQs with Answers

In MS Excel, which option is used to clear all contents, formats, and comments in a selected cell?

• A.Clear Formats
• B.Clear Contents
• C.Clear All
• D.Clear Comments

Which type of chart in MS Excel is best for comparing values across different categories?

• A.Column Chart
• B.Pie Chart
• C.Line Chart
• D.Scatter Chart

Which method can be used to edit a cell in an MS Excel spreadsheet?

• A.Double-clicking the cell
• B.Pressing F2 key
• C.Clicking the formula bar
• D.All of these

Which Excel function is specifically used to count the number of numeric values in a given range?

• A.COUNT
• B.COUNTA
• C.COUNTIF
• D.SUM

Which function in MS Excel is used to sum up the values in a range of cells?

• A.TOTAL
• B.ADD
• C.SUM
• D.COUNT

What type of software is Microsoft Excel categorized as?

• A.Database Management System
• B.Spreadsheet
• C.Word Processor
• D.Presentation Software

Which Excel function is used to search data in a table and return a corresponding value?

• A.VLOOKUP
• B.HLOOKUP
• C.LOOKUP
• D.SEARCH

Past Paper MCQ

A worksheet in Excel is divided into which of the following components?

• A.Charts & Tables
• B.Cells & Formulas
• C.Sheets & Workbooks
• D.Columns & Rows

In MS Excel, what does the term 'chart wizard data' refer to in relation to the axes?

• A.Vertical axis
• B.Horizontal axis
• C.Z-axis
• D.Both vertical and horizontal axes

Which option in MS Excel allows you to add a mathematical symbol that can be typed through the keyboard?

• A.View → Symbol
• B.Insert → Equation
• C.Insert → Symbol
• D.Home → Symbol