MS Excel MCQs with Answers

How can you delete a worksheet from a workbook in MS Excel?

• A.Go to File > Remove Worksheet
• B.Right-click the sheet tab and choose Delete
• C.Select the sheet and press Ctrl + D
• D.Select the sheet, then choose Edit > Delete Sheet

How many columns are present in a typical MS Excel 2003 worksheet?

• A.16,384
• B.65,536
• C.1,048,576
• D.256

Which function in MS Excel is used to sum values based on a specified condition?

• A.SUMPLUS
• B.COUNTIF
• C.IFSUM
• D.SUMIF

What is the term used in MS Excel for altering the visual style of the content in a cell?

• A.Formatting
• B.Editing
• C.Styling
• D.Conditional Logic

In MS Excel, how can data be sorted?

• A.By using the Sort A to Z / Sort Z to A buttons on the Data tab
• B.By using the Sort dialog box (Data tab → Sort) to sort by multiple columns
• C.Only by manually rearranging rows
• D.Both A & B

Which feature in MS Excel allows you to populate cells with a series of data efficiently?

• A.Auto fill
• B.Auto sum
• C.Data validation
• D.Conditional formatting

In a programming context, which character should precede a numeric value to treat it as a label?

• A.# (hash)
• B.' (apostrophe)
• C.@ (at sign)
• D.$ (dollar sign)

In a spreadsheet, what are the horizontal divisions identified by numbers called?

• A.Cells
• B.Columns
• C.Rows
• D.Sheets

In MS Excel, what category of functions does the PMT function belong to?

• A.Financial
• B.Statistical
• C.Logical
• D.Text

Past Paper MCQ

What is the intersection point of a column and a row in a spreadsheet called?

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