MS Excel MCQs with Answers

What is the process called when you obtain data from a cell located in a different worksheet in MS Excel?

• A.Referencing
• B.Linking
• C.Embedding
• D.Merging

In MS Excel, how can you select an entire column quickly?

• A.Click the column heading letter
• B.Double-click any cell in the column
• C.Press Ctrl + C
• D.Right-click and choose "Select Column"

In a computer spreadsheet application like MS Excel, what are SUM, AVERAGE, MIN, and MAX classified as?

• A.Formulas
• B.Functions
• C.Operators
• D.Cell References

What is the intersection of a row and a column in MS Excel called?

• A.Cell
• B.Range
• C.Worksheet
• D.Grid

When the formula bar is activated in MS-Excel, what can you see displayed?

• A.Cancel and Enter buttons
• B.The contents of the active cell
• C.The Name Box
• D.All of these

What is relative cell referencing in MS Excel?

• A.Using addresses like A$1 or $A1
• B.Using addresses like $A$1
• C.Using only addresses like A1
• D.Using named ranges only

Which symbol is used to represent the 'not equal to' operator in Microsoft Excel formulas?

• A.<>
• B.!=
• C.=/=
• D.!==

What is the default autosave interval set in MS Excel?

• A.5 minutes
• B.10 minutes
• C.15 minutes
• D.20 minutes

Past Paper MCQ

Which of the following mathematical expressions is incorrect?

• A.A1+B2
• B.B1*17
• C.SUM(C1:C5)
• D.D1/E1

What is the primary function of the SUM function in MS Excel?

• A.It returns the maximum value
• B.It finds the average of values
• C.It counts the number of cells
• D.It totals values