You can quickly change the appearance of your work by choosing Auto Format from the …. Menu
Answer: C
Correct answer: Format
AutoFormat changes appearance, so it is on the Format menu.
Please log in or register to report this question.
Which of the following statement is false?
Answer: B
Correct answer: If you choose to select from the pre-made slide layouts, you cannot change the layout
A layout can be changed at any time simply by choosing another from the pane; the placeholders rearrange and the content stays. The other statements are true.
Please log in or register to report this question.
Hyperlinks cannot be
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.
Please log in or register to report this question.
In order to edit a chart, you can
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.
Please log in or register to report this question.
When you link data maintained in Excel workbook to a Word document
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.
Please log in or register to report this question.
Data marker on a chart are linked to data points in a worksheet, therefore,
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.
Please log in or register to report this question.
You can open the Consolidate dialog box by choosing Consolidate from the ..... menu.
Answer: D
Correct answer: Data
Consolidate combines figures from several ranges or sheets into one summary, which makes it a data command.
Please log in or register to report this question.
In MS Excel, what happens when you press Ctrl + Shift + Enter after typing a formula?
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.
Please log in or register to report this question.
Which of the following describes how to select all the cells in a single column?
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.
Please log in or register to report this question.
Which of the following is the default page setup orientation of slide in PowerPoint
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.
Please log in or register to report this question.
