to activate the previous cell in a pre-selected range, press
Answer: D
Correct answer: none of above
Within a pre-selected range, Enter moves forward and Shift + Enter moves back; Tab and Shift + Tab do the same across the row. None of the three keys listed moves to the previous cell on its own.
Please log in or register to report this question.
When the formula bar is activated, you can see
Answer: D
Correct answer: All of above
While a cell is being edited the formula bar shows three buttons: the cancel cross, the enter tick, and the edit formula equals sign that opens the formula palette.
Please log in or register to report this question.
In a worksheet you can select
Answer: D
Correct answer: a, b, and c
Clicking a row heading selects the row, a column heading the column, and the corner button where they meet selects the whole sheet.
Please log in or register to report this question.
when you print preview a worksheet
Answer: D
Correct answer: a, b and c
Print Preview shows what would be printed, and that depends on the print settings: the active area by default, a selected range if Selection is chosen, or the whole sheet.
Please log in or register to report this question.
You can group noncontiguous worksheets with
Answer: C
Correct answer: The ctrl key and mouse
Ctrl with the mouse picks out sheets that are not next to each other; Shift selects a contiguous run of tabs. Grouped sheets then receive the same entries and formatting together.
Please log in or register to report this question.
Weight refers to
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.
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.
When you see a cell with a red triangle in the top right corner, what does this signify?
Answer: B
Correct answer: There is a comment associated with the cell
A small red triangle in the top right corner marks a comment, which appears when the pointer rests on the cell. A green triangle in the top left corner is Excel's error indicator, which is the mark the other option describes.
Please log in or register to report this question.
To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the
Answer: B
Correct answer: Freeze panes command on the window menu
Freeze Panes locks the rows above and the columns to the left of the active cell, so headings stay in view while the rest of the sheet scrolls. Split divides the window into panes that scroll independently, which is a different effect.
Please log in or register to report this question.
Which of these is a quick way to copy formatting from a selected cell to two other cells on the same worksheet?
Answer: C
Correct answer: Click format painter on the Formatting toolbar twice then click in each cell you want to copy the formatting to
A single click of Format Painter applies the formatting once and switches off; double-clicking it keeps it on until Esc is pressed, so several cells can be painted in turn.
Please log in or register to report this question.
