MS Excel Questions and Answers

Answer: D

Correct answer: All of above

Sheet protection covers the cell contents, the objects drawn on the sheet and the scenarios stored with it, each with its own check box.

Answer: A

Correct answer: Apostrophe (’)

A leading apostrophe forces the entry to be treated as text, so a number keeps its leading zeros and is aligned left. The apostrophe is not displayed or stored as part of the value.

Answer: C

Correct answer: Ctrl + Home

Ctrl + Home jumps to the beginning of the presentation, and Ctrl + End to the last slide. Page Up and the Previous Slide button move back only one slide at a time.

Answer: B

Correct answer: $A$1

A dollar sign fixes the part of the reference that follows it, so $A$1 fixes both column and row and does not change when the formula is copied. A1 is relative and $A1 or A$1 mixed.

Answer: A

Correct answer: PMT (payments)

PMT returns the constant payment on a loan, given the rate, the number of periods and the present value:

\[ \text{PMT}(rate, nper, pv) \]

NPER computes how many periods are needed and PV the amount that can be borrowed.

Answer: A

Correct answer: Printer selection

Page Setup covers orientation, scaling, margins, headers and footers, and the rows or columns to repeat on each page. Which printer to use is chosen in the Print dialog instead.

Answer: B

Correct answer: Freeze panes command on the window menu

Freeze Panes locks the rows above and the columns to the left of the active cell, so headings stay in view while the rest of the sheet scrolls. Split divides the window into panes that scroll independently, which is a different effect.

Answer: C

Correct answer: Window > split

Window > Split divides the window into panes that scroll independently, which is how two distant parts of a sheet are viewed at once. Dragging the split box at the end of a scroll bar does the same thing.

Answer: C

Correct answer: None

A new worksheet has no header or footer at all. The sheet name, page number and date are among the built-in choices, but each must be selected.

Answer: A

Correct answer: display only the rows that meet chosen criteria

AutoFilter, applied with Ctrl + Shift + L or from the Data tab, adds a drop-down arrow to each header and lets rows be hidden unless they meet the chosen criteria. It hides rather than deletes: clearing the filter brings everything back, and the row numbers turning blue with gaps in the sequence is the sign that a filter is active. Forgetting that is a common source of confusion, since a filtered sheet can look as though data has been lost. The filter offered depends on the column’s content. Text columns get Text Filters, with options such as begins with and contains; numeric columns get Number Filters, including Top 10 and Above Average; date columns get date-aware options such as Last Month. One caution worth knowing: functions such as SUM include hidden rows, whereas SUBTOTAL and AGGREGATE can be told to ignore them - which is why a filtered total should use SUBTOTAL.