MS Excel Questions and Answers

Answer: A

Correct answer: The print density of characters

Weight is the thickness of the strokes - light, regular, bold. Height is size, slant is style, and the design as a whole is the typeface.

Answer: C

Correct answer: Clicking file open

New presentations are created by the New button, by File > New, or by Ctrl + N. File > Open opens an existing one, which is the opposite operation.

Answer: D

Correct answer: None of the above

Ctrl + I and Format > Cells > Font both apply italics, and the Tools > Wizard > Web Form item does not exist at all, so it cannot set italics either. Since the question asks which will not italicise and two of the three do, none of the listed options is the answer.

Answer: D

Correct answer: All of above

Auto ClipArt watches the words you type, so it both places suggested clip art in the presentation and checks the text - on the slides and in WordArt objects - as it does so. Since each statement describes part of what the feature does, the combined option is the right one.

Answer: A

Correct answer: Returns one value when a condition is true and another when it is false

IF tests a condition and returns one value if it is true and another if it is false: =IF(A1>=40,"Pass","Fail"). Its three arguments are the test, the value if true, and the value if false. Omitting the third returns FALSE rather than a blank, so it is usually supplied even when the answer is an empty string. IF functions can be nested to handle several cases - grades, slabs, bands - but nesting quickly becomes unreadable. IFS, in newer versions, takes a list of condition-and-result pairs and is clearer, and a VLOOKUP against a small band table is often better still. The logical functions that combine with it are worth knowing: AND requires every condition, OR requires any, and NOT reverses one. So =IF(AND(A1>=40,B1>=40),"Pass","Fail") requires both marks. IFERROR is the specialised form that catches errors.

Answer: B

Correct answer: from Format >> Autoformat

AutoFormat applies a ready-made combination of number formats, borders, fonts, patterns and column widths to a selected range.

Answer: B

Correct answer: apply an animation scheme

An animation scheme is a ready-made set of coordinated effects that can be applied to the selected slides - or to all of them - in one click, which is by far the quickest way to animate text across a deck. The Custom Animation pane gives finer control but has to be set up effect by effect.

Answer: A

Correct answer: Click the object command on the insert menu

Insert > Object creates a new embedded object of a chosen type, so a blank Excel worksheet appears in the Word document ready to be filled in.

Answer: D

Correct answer: a, b and c

Display and printing are controlled separately: gridlines may be shown on screen but not printed, printed but not shown, or neither. All three statements are therefore true.

Answer: C

Correct answer: Refresh Data

A pivot table holds a snapshot of its source, so changes to the source do not appear until Refresh Data is pressed. That is deliberate: recalculating a large pivot table on every edit would be slow.