MS Excel: Functions, Errors and Features MCQs – Page 2

Solved MS Excel MCQs on functions (VLOOKUP, SUMIF, COUNTIF, TODAY, LEN), error values like #DIV/0!, shortcuts, Freeze Panes, Pivot Tables and formatting.

1. 21

   In Excel, the shortcut Alt + = inserts:

   AA chartBA new sheetCThe current dateDAutoSum

   Correct answer: D. AutoSum

   Alt + = inserts a SUM formula for the adjacent range of numbers.

   hardShow answer
2. 22

   In Excel, Ctrl + Home moves the cursor to:

   AThe next worksheetBCell A1CThe last used cellDThe top of the current column

   Correct answer: B. Cell A1

   Ctrl + Home goes to cell A1. Ctrl + End goes to the last cell that contains data.

   mediumShow answer
3. 23

   In Excel, Ctrl + 1 opens:

   AThe Format Cells dialog boxBHelpCThe Print dialog boxDA new workbook

   Correct answer: A. The Format Cells dialog box

   Format Cells lets you set number formats, alignment, fonts, borders and fill.

   hardShow answer
4. 24

   The small square at the bottom-right corner of a selected cell, used to copy formulas or fill series, is called the:

   AFill handleBStatus barCFormula barDName box

   Correct answer: A. Fill handle

   Dragging the fill handle copies formulas or continues a series such as 1, 2, 3 or Jan, Feb, Mar.

   easyShow answer
5. 25

   The box at the left of the formula bar that shows the address of the active cell is called the:

   ACell BoxBName BoxCTitle BarDAddress Bar

   Correct answer: B. Name Box

   The Name Box shows the selected cell's address, such as C5, and can also be used to jump to a cell or named range.

   mediumShow answer