MS Excel MCQs with Answers

In a computer spreadsheet program, what is the term for a cell that is currently selected and highlighted with a heavy border?

• A.Formula cell
• B.Cell reference
• C.Cell pointer
• D.Active cell

Which of the following represents a valid cell address in MS Excel?

• A.C5
• B.5C
• C.C-5
• D.Column5

When you hover your mouse over a chart object in MS Excel, what do you typically see?

• A.Data Label
• B.Screen Tip
• C.Chart Title
• D.Legend

What is the primary working area of Microsoft Excel called?

• A.Workbook
• B.Worksheet
• C.Document
• D.Spreadsheet

Past Paper MCQ

Which type of chart is most suitable for displaying a single series of data?

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

In MS Excel, what does a 'workspace' refer to?

• A.A single worksheet
• B.A collection of workbooks
• C.The entire Excel application window
• D.A saved chart template

How is a cell reference represented in MS Excel?

• A.Row number then column name
• B.Column name then row number
• C.Sheet name then cell number
• D.Cell number then sheet name

What is the result of the Excel formula '=20 * 10 / 5 * 8'?

• A.40
• B.5
• C.320
• D.64

Which function is used in Excel to calculate the product of a range of numbers?

• A.=SUMPRODUCT()
• B.=MULTIPLY()
• C.=PRODUCT()
• D.=MULT()

When a formula from cell D14 containing =B14*C14 is copied to cell D16 in MS Excel, what will be the new formula in D16?

• A.=D14*D14
• B.=B14*C14
• C.=B16*C16
• D.=B16*D16