To protect a worksheet, you can choose Protection and the Protect Sheet from the ….. menu
Answer: C
Correct answer: Tools
Sheet and workbook protection are under Tools > Protection, along with the workbook sharing commands.
Please log in or register to report this question.
You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
Answer: D
Correct answer: Tools
Track Changes and the Highlight Changes dialog are under Tools, with the other shared-workbook commands.
Please log in or register to report this question.
Which of the following is not a worksheet design criterion?
Answer: C
Correct answer: Description
A worksheet is judged on whether it is efficient, clear to read and auditable - that is, whether its calculations can be traced and checked. Description is not one of the design criteria.
Please log in or register to report this question.
To copy cell contents using drag and drop, press the
Answer: D
Correct answer: None of above
Drag and drop moves the cells by default; holding Ctrl makes it copy instead. None of the three keys listed does that.
Please log in or register to report this question.
If you press …., the cell accepts your typing as its contents.
Answer: A
Correct answer: Enter
Enter commits what has been typed and moves to the next cell. Ctrl + Enter commits it to every cell of a selection at once, and Esc abandons it.
Please log in or register to report this question.
The autofill feature
Answer: A
Correct answer: Extends a sequential series of data
AutoFill continues a pattern: dragging the fill handle from cells containing 1 and 2 gives 3, 4, 5, and from Mon gives the rest of the week. It recognises the series rather than adding anything up.
Please log in or register to report this question.
What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
Answer: D
Correct answer: F11
F11 creates a chart from the selected range on a new chart sheet; Alt + F1 creates the same chart embedded in the current sheet.
Please log in or register to report this question.
you can use the formula palette to
Answer: B
Correct answer: create and edit formulas containing functions
The formula palette appears when a function is inserted and shows each argument with a box to fill and the result so far, so a nested function can be built without remembering its syntax.
Please log in or register to report this question.
Which Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data has changed?
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.
Please log in or register to report this question.
What is an expression that tells how the numbers in a determined set of cells are to be calculated?
Answer: A
Correct answer: Formula
A formula is the expression that tells Excel how to compute a value from the contents of other cells. A field and a query belong to databases.
Please log in or register to report this question.
