MS Excel Questions and Answers

Answer: B

Correct answer: On the file menu, click print, and then click selection under print what

Select the cells you want, then open File → Print and choose Selection under “Print what”. That prints just the highlighted range for this one job and leaves any saved print area untouched - which is what you need when the area differs from the usual one. Setting a print area would overwrite the stored setting, and custom views belong to Excel’s view management.

Answer: A

Correct answer: rotate text on the chart

Fill Effects offers gradients, textures, patterns and pictures, each with foreground and background colours. Rotating text is done from the axis or data label format dialog, not from a fill.

Answer: B

Correct answer: Cycles the selected cell reference between relative, absolute and mixed

While editing a formula, F4 cycles the reference at the cursor through its four forms: A1, $A$1, A$1, $A1, and back again. It saves typing dollar signs and is one of the most-used keys in Excel. Outside formula editing, F4 has a quite different role: it repeats the last action, which makes it useful for applying the same formatting to several places in turn. Its behaviour therefore depends entirely on the mode Excel is in. The other function keys are worth knowing alongside it. F2 edits the active cell in place. F9 recalculates all open workbooks - and, when part of a formula is selected in the formula bar, evaluates just that part, which is the standard way to debug a long formula. F11 creates a chart on a new sheet. F5 opens Go To, whose Special button selects all blanks, constants or formulas at once.

Answer: B

Correct answer: Re-apply the footer placeholder

If a footer placeholder is deleted in master view, Format → Master Layout lets you tick the footer box again and PowerPoint restores the placeholder in its original position. Re-applying the slide layout affects individual slides, and creating a new master would discard all the other formatting.

Answer: C

Correct answer: From Format Cells dialog box mark Shrink to fit check box

Shrink to fit reduces the displayed font size until the text fits the column, leaving the column width alone. Autofit does the opposite - it changes the column to suit the text.

Answer: A

Correct answer: texture

A texture fill uses a small tiled image - sand, marble, paper - which is what gives the grainy appearance. A gradient shades smoothly from one colour to another, which is the opposite of grainy.

Answer: A

Correct answer: Use the Excel menu bar and toolbars inside the word application

An embedded object is edited in place: double-clicking it replaces Word's menus and toolbars with Excel's, and the data lives inside the Word file rather than in a separate workbook.

Answer: A

Correct answer: Nested

A function used as an argument of another is nested, as in =IF(SUM(A1:A5)>100,"high","low"). Excel allows several levels of nesting.

Answer: C

Correct answer: Pressing the Esc key

Arrow keys, Tab and the tick on the formula bar all commit what has been typed. Esc abandons it and restores the previous contents, so it is the one that does not enter data.

Answer: D

Correct answer: Tools

Scenarios are on the Tools menu, with Goal Seek and Solver, since all three are what-if analysis commands.