MS Excel Questions and Answers

Answer: D

Correct answer: 32,000

A cell holds up to 32,767 characters of text, of which about a thousand are displayed unless the row is enlarged. Of the figures offered, 32,000 is the one that reflects it.

Answer: C

Correct answer: A formula that refers, directly or indirectly, to its own cell

A circular reference occurs when a formula depends on its own cell, either directly - =A1+1 typed into A1 - or through a chain that eventually comes back to it. Excel cannot resolve it, since the answer would depend on itself, so it displays a warning, shows zero, and names the offending cell in the status bar. The full list is found under Formulas, Error Checking, Circular References. The usual cause is accidental: a SUM formula placed inside the range it is adding, most often at the bottom of a column where the range was extended one row too far. Deliberate circularity is possible where a genuinely iterative calculation is intended, by enabling Iterative Calculation in Excel’s options and setting a maximum number of iterations and a change threshold. That is used for engineering and financial models that converge, and should not be left on by default, since it silently masks accidental circular references.

Answer: C

Correct answer: cell B5 on the worksheet named Sheet2

The exclamation mark separates the sheet name from the cell address, so Sheet2!B5 is cell B5 on the sheet called Sheet2. If the sheet name contains a space or a punctuation mark it must be enclosed in single quotation marks: ='Sales Data'!B5. Excel adds them automatically when a reference is built by clicking. A reference to another workbook adds the file name in square brackets: =[Budget.xlsx]Sheet1!A1. That creates a link, which prompts to update when the file is opened and breaks if the source is moved or renamed. Links are managed from Data, Edit Links. A 3-D reference spans several sheets: =SUM(Jan:Dec!B5) adds B5 across twelve monthly sheets, which is how identical sheets are consolidated. Renaming a sheet updates every formula referring to it automatically, which is one reason to rename rather than recreate.

Answer: C

Correct answer: Use comments

Insert → Comment attaches a note to a slide and stamps it automatically with the reviewer’s name and the date, taken from the User Information settings - nothing has to be typed by hand. The notes page is free text with no author or date, and online collaboration is a meeting facility rather than a way of recording remarks.

Answer: C

Correct answer: 123

Lotus 1-2-3 files carry the extension .123 in its later versions; the earlier releases used .WK1 and .WK3, which is why that option is also on the list.

Answer: C

Correct answer: Modify the text within the body placeholder

Notes Master view shows the notes body as a placeholder. Selecting the text inside that placeholder and changing its font size resets the size for the notes of every slide at once. Changing the slide design affects slides, not notes, and moving the placeholder around alters the layout without touching the type size.

Answer: A

Correct answer: Extends a sequential series of data

AutoFill continues a pattern: dragging the fill handle from cells containing 1 and 2 gives 3, 4, 5, and from Mon gives the rest of the week. It recognises the series rather than adding anything up.

Answer: D

Correct answer: Animation Scheme

An animation scheme applies a ready-made set of entrance and emphasis effects to the objects on a slide. Slide transition governs the change between slides rather than movement within one.

Answer: D

Correct answer: extends a sequential series of data

AutoFill continues a pattern: from 1 and 2 it gives 3, 4, 5, and from Jan it gives the rest of the months. It recognises the series rather than adding anything up.

Answer: A

Correct answer: Transitions command

The shortcut menu shown during a running slide show offers navigation commands, speaker notes and the meeting reminder, but transitions must be set beforehand in the editing views - there is no command to change them while the show is running.