MS Excel Questions and Answers

Answer: D

Correct answer: B1:G10

A range is written as its top-left and bottom-right corners joined by a colon: B1:G10. The semicolon and the full stop are not Excel's range operators.

Answer: D

Correct answer: Zoom

The notes text box in Normal view is small, so the text is displayed at a reduced percentage and is hard to read while typing. Raising the Zoom level enlarges the pane on screen without changing the printed size. Slide Show runs the presentation, Insert adds objects, and the Slide Master governs formatting - none of them make the notes pane easier to read.

Answer: B

Correct answer: Layout of audience handout notes

The handout master controls how printed handouts are arranged - how many slide thumbnails appear per page, where they sit, and the header, footer, date and page-number placeholders. It does not touch slide formatting, which belongs to the slide master, nor the Word export formatting.

Answer: D

Correct answer: All of above

AutoFormat's options let you switch each element on or off individually - number, border, font, patterns, alignment and width or height - so an existing font can be kept while the borders are applied.

Answer: C

Correct answer: Formula bar

The status indicators - Ready, Enter, Edit, Point - sit at the left of the status bar area associated with the formula bar and tell you what mode the cell is in.

Answer: B

Correct answer: A collection of chart data markers

A data series is one row or column of values, drawn as a set of markers of the same colour - one line, or one set of bars. The legend names the series rather than being one.

Answer: A

Correct answer: IF

AND, OR and NOT return TRUE or FALSE and nothing else. IF tests a condition and then returns whichever of two values it is given, so its result can be anything at all.

Answer: C

Correct answer: Tools

Macros are recorded, run and edited from Tools > Macro.

Answer: C

Correct answer: A formula has been given an argument of the wrong type

#VALUE! means a formula has received the wrong kind of argument - most often text where a number was expected, as when =A1+B1 meets a cell containing a word or a stray space. The commonest hidden cause is a number stored as text, which looks identical to a real number but aligns left rather than right and is ignored by arithmetic. Text to Columns, or multiplying by 1, converts such a column. Invisible non-breaking spaces from pasted web data produce the same result and need SUBSTITUTE with CHAR(160) to remove. Date arithmetic against a text date fails the same way. The remedy in a formula is IFERROR, though it is better to find the offending cell with Trace Precedents or Evaluate Formula than to hide the symptom. The other errors have distinct causes: #REF! for a deleted reference, ##### for a narrow column, #NAME? for a misspelt function.

Answer: D

Correct answer: Serial Number 50771

A value is something Excel can compute with, and a number, a date and a percentage all qualify. Serial Number 50771 begins with letters, so the whole entry is text - a label rather than a value.