MS Excel Questions and Answers

Answer: D

Correct answer: All can be hyperlinks

A hyperlink can be attached to a cell, to a picture, to a drawing object and to an AutoShape alike, so none of the three is excluded.

Answer: C

Correct answer: Double click the chart object

Double-clicking an embedded chart opens it for editing in place, replacing PowerPoint's menus with those of the charting program. A single click merely selects it.

Answer: B

Correct answer: The Word document contains a reference to the original source

A link stores a reference to the workbook rather than the data itself, so the document shows the current figures whenever the source changes. Embedding would store a copy instead.

Answer: B

Correct answer: You can change the position of a data marker and automatically change the data point value in the worksheet

The link runs both ways: dragging a marker on a two-dimensional chart alters the underlying value in the sheet, which is why a chart can be used as an input as well as an output. Formatting a series is not what the link makes possible.

Answer: D

Correct answer: Data

Consolidate combines figures from several ranges or sheets into one summary, which makes it a data command.

Answer: C

Correct answer: It is entered as an array formula

Ctrl + Shift + Enter enters a formula as an array formula, which Excel shows enclosed in braces - braces that are added by Excel and must never be typed. An array formula operates on whole ranges at once rather than on single cells, which allows calculations that would otherwise need a helper column. =SUM(A1:A10*B1:B10) entered this way multiplies the two ranges element by element and adds the products - the same result as SUMPRODUCT, which does it without the special entry. Array formulas cannot be edited or deleted one cell at a time where they occupy a range; the whole block must be selected. Newer versions of Excel use dynamic arrays, in which a formula returning several values simply spills into the neighbouring cells with no special keystroke at all, and the older form is retained only for compatibility. Functions such as FILTER, SORT and UNIQUE work this way.

Answer: C

Correct answer: Left click on the gray column title button

Clicking the grey column heading selects the whole column. Ctrl + A selects the entire sheet rather than one column.

Answer: B

Correct answer: Landscape

PowerPoint slides default to landscape - wider than they are tall (10 × 7.5 inches on the classic 4:3 setting) - because that matches the shape of a projector screen. Portrait is available under File → Page Setup but must be chosen deliberately.

Answer: D

Correct answer: b and c both

An embedded chart is edited either by double-clicking it or by right-clicking and choosing the edit command for that object type - two routes to the same in-place editing.

Answer: B

Correct answer: Apply Conditional Formatting command on Format menu

Conditional formatting applies a format when a condition holds, and re-evaluates it whenever the value changes. An IF function returns a value rather than a format, and formatting the cells by hand would not follow later edits.