MS Excel MCQs with Answers

What does the distributed alignment choice do in cell formatting?

• A.Spreads data across the width of the cell
• B.Centers data both horizontally and vertically
• C.Aligns data to the right edge of the cell
• D.Rotates data diagonally within the cell

In MS Excel's accounting style, how are negative numbers typically displayed?

• A.With parentheses
• B.With a minus sign before the number
• C.In red font color only
• D.With a trailing minus sign

What is the maximum number of rows available in a single worksheet in MS Excel?

• A.65536
• B.1048576
• C.16384
• D.524288

Which symbol is used to perform division in an Excel formula?

• A./
• B.\
• C.÷
• D.%

What does the title bar in MS Excel display?

• A.Worksheet name
• B.Workbook name
• C.Cell reference
• D.Formula bar

What does the Auto Sum feature do in spreadsheet applications?

• A.It adds a range of cell values
• B.It multiplies a range of cell values
• C.It counts the number of cells in a range
• D.It finds the average of a range of cell values

Pivot Table is a feature of which software application commonly used for data analysis and management?

• A.Microsoft Word
• B.Microsoft PowerPoint
• C.Microsoft Excel
• D.Microsoft Access

Which function in Excel calculates the number of whole days between two dates?

• A.DAYS360()
• B.DATEDIF()
• C.NETWORKDAYS()
• D.DAY()

Past Paper MCQ

A spreadsheet is typically created using which software application?

• A.MS Word
• B.MS PowerPoint
• C.MS Excel
• D.MS Access

Which of the following expressions is invalid in a spreadsheet application due to improper referencing?

• A.=A1+B2
• B.=SUM(C1:C5)
• C.B1*17
• D.=$D$3+E4