You can zoom a worksheet
Answer: D
Correct answer: All of the above
The view can be magnified from the Zoom box on the toolbar, from View > Zoom, and in Print Preview both by the Zoom button and by clicking the page with the magnifier pointer.
Please log in or register to report this question.
Which of the following is the latest version of Excel
Answer: D
Correct answer: Excel XP
Of those listed, Excel XP (Excel 2002) is the most recent; Excel 2000 preceded it and Excel ME was never a product - ME was a version of Windows.
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.
Excel is a
Answer: D
Correct answer: A spreadsheet
Excel is a spreadsheet: a grid of cells holding values and formulas, recalculated whenever anything they depend on changes.
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.
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.
You can add an image to a template by clicking the Insert Picture From File button on the …. Toolbar.
Answer: D
Correct answer: Picture
The Insert Picture From File button is on the Picture toolbar, which appears whenever a picture is selected.
Please log in or register to report this question.
How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
Answer: B
Correct answer: On the file menu, click print, and then click selection under print what
Setting a print area stores it with the sheet, so it would have to be cleared before printing something else. Choosing Selection in the Print dialog applies to that one printing only, which is what the question asks for.
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.
How can you remove borders applied in cells?
Answer: C
Correct answer: Both of above
Borders are removed either by choosing None on the Border tab of Format Cells, or by picking the no-border square from the Borders button on the Formatting toolbar.
Please log in or register to report this question.
