MS Excel MCQs with Answers

Past Paper MCQ

What does moving from cell C9 to C11 indicate in MS Excel?

• A.Moving content from C9 to C11
• B.Selection of only cell C11
• C.Selection of cells C9 and C11 only
• D.Selection of cells C9:C11

Which Excel function is used to calculate the average of values from A1 to A5?

• A.AVERAGE(A1:A5)
• B.SUM(A1:A5)/5
• C.MEAN(A1:A5)
• D.AVG(A1:A5)

In MS Excel, which tab allows you to format the date as YYYY/MM/DD?

• A.Home
• B.Format
• C.Data
• D.Insert

Which of the following statements is true regarding the use of copy and paste buttons on the standard toolbar for linking Excel worksheet data to a Word document?

• A.They can be used to link data with automatic updates
• B.They can be used to link data only if both files are in the same folder
• C.They cannot be used to link data
• D.They can be used to link data only in read-only mode

Which of the following can be renamed in Microsoft Excel?

• A.Worksheet only
• B.Workbook only
• C.Both worksheet and workbook
• D.Neither worksheet nor workbook

What is the primary function of the formula bar in an Excel window?

• A.Displaying cell formatting options
• B.Entering values and formulas
• C.Managing worksheet tabs
• D.Navigating between cells

Which type of chart is typically used to display changes over time in a project?

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

In a spreadsheet application like MS Excel, what is typically used to perform calculations?

• A.Function
• B.Formula
• C.Macro
• D.Chart

Which type of chart in MS Excel is ideal for displaying the parts of a whole?

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

Which of the following is not a 'what-if' analysis function in MS Excel?

• A.Goal Seek
• B.Scenario Manager
• C.Data Table
• D.Auto Outline