MS Excel Questions and Answers

Answer: D

Correct answer: all of above

All three make a sheet easier to read: AutoFormat applies a coordinated set of formats at once, styles apply a named combination consistently, and the choice of font affects legibility directly.

Answer: A

Correct answer: Displays long text on several lines within the same cell

Wrap Text makes long content display on several lines inside its own cell, increasing the row height to fit. The cell’s value is unchanged; only its display is affected. Without it, text that overflows spills across neighbouring cells if they are empty, and is cut off at the boundary if they are not. That behaviour is often mistaken for data loss, when the content is in fact intact and merely hidden. Alt + Enter inserts a line break at a chosen point within a cell, which gives control over where the text divides rather than leaving it to the column width. The neighbouring option, Shrink to fit in the Format Cells dialogue, is the third answer here: it reduces the displayed font size instead of wrapping. Orientation, on the Home tab, rotates text and is the fourth. Merge and Centre sits beside Wrap Text and is best avoided in data ranges, since merged cells break sorting, filtering and many formulas.

Answer: C

Correct answer: Series

Qtr 1, Qtr 2, Qtr 3 is a series - a sequence Excel recognises and can continue with the fill handle. A formula computes and a function is a named operation.

Answer: D

Correct answer: Goal Seek

Goal Seek works backwards: you say what result you want from a formula and which cell may be altered, and Excel adjusts that cell until the formula produces it. A trend line is a chart annotation and does not change anything.

Answer: D

Correct answer: 500

Excel's zoom runs from 10 per cent to 400 per cent, so 500 is outside the range. The other three are all within it.

Answer: C

Correct answer: Tools

In the classic menu interface a macro is run from Tools → Macro → Macros (Alt + F8), which lists the available macros and offers the Run button. The same submenu holds Record New Macro and the Visual Basic Editor. Insert, Format and Data have no macro commands.

Answer: A

Correct answer: Standard

The spelling button belongs to the Standard toolbar, alongside new, open, save and print. The Formatting toolbar carries font and alignment controls.

Answer: B

Correct answer: View different rows and columns

Scroll bars change which part of the sheet is displayed and nothing else - the active cell and the contents are untouched. Splitting panes is a separate command, though the split box sits at the end of the scroll bar.

Answer: D

Correct answer: All of the above

Copying is available from the Edit menu, from the right-click shortcut menu, from the toolbar buttons and from the keyboard - four routes to the same command.

Answer: B

Correct answer: Using the Tools – Wizard – Web Form menu item

Italics can be applied with Ctrl + I, with the Italic button on the Formatting toolbar, or through Format → Cells → Font. The Tools → Wizard → Web Form command builds a web form and has nothing to do with character formatting, so it is the one that will not italicise the selection.