MS Excel MCQs with Answers

Past Paper MCQ

What is the purpose of the IF function in MS Excel?

• A.Performing logical comparisons
• B.Calculating the average of a range
• C.Merging text from multiple cells
• D.Counting cells that contain numbers

What feature in MS Excel 2016 allows users to work with data one record at a time?

• A.Quick Analysis
• B.Data Validation
• C.Data Form
• D.Flash Fill

Which of the following is NOT a type of chart?

• A.Bar chart
• B.Pie chart
• C.T-graph
• D.Line chart

What are the main components of an MS Excel spreadsheet?

• A.Rows & Columns
• B.Slides & Notes
• C.Pages & Sections
• D.Tables & Queries

In an Excel worksheet, how is the active cell visually indicated?

• A.A dark wide border
• B.A blinking cursor inside the cell
• C.A shaded or highlighted background
• D.A red triangle in the corner

What functionalities does an electronic spreadsheet worksheet offer to users?

• A.Perform calculations using formulas and functions
• B.Create charts and graphs for data visualization
• C.Sort, filter, and analyze tabular data
• D.All of these

How are rows labeled in Microsoft Excel?

• A.A, B, C, etc.
• B.1, 2, 3, etc.
• C.I, II, III, etc.
• D.R1, R2, R3, etc.

Which type of chart is best suited to represent a family's income distribution from different sources?

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

In MS Excel, how can you perform multiple calculations within a single formula?

• A.Using Data Validation
• B.Using Nested IF only
• C.Using Conditional Formatting
• D.Using Array Formula

What is the process to convert rows into columns in MS Excel?

• A.Select the cells, then use Insert tab and choose Swap Rows & Columns
• B.Select the cells, then use Format Cells and choose Rotate
• C.Select the cells, then use Data tab and click Text to Columns
• D.Select the cells, then use Paste Special and mark Transpose