A Basic Quiz On Microsoft Excel Exam!
(61).jpg "A Basic Quiz On Microsoft Excel Exam!")
Have you just finished your training in Microsoft Excel and are looking to test out your understanding? The practice test below is set to test how well you can use excel effectively. Give it a try and ensure to read up on the parts that you don’t get correctly.
- 1.
- A.
Click Subtotals on the Data menu.
- B.
View the sum in the formula bar.
- C.
Click the AutoSum button on the Standard toolbar, then press ENTER.
- 2.If you want to paste a formula result — but not the underlying formula — to another cell. You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?
- A.
Click the Paste button on the Standard toolbar.
- B.
Click the arrow on the Paste button on the Standard toolbar, then click Formulas.
- C.
Click the arrow on the Paste button on the Standard toolbar, then click Values.
- 3.
- A.
Single-click the boundary to the left of the column heading.
- B.
Double-click the boundary to the right of the column heading.
- C.
Press ALT and single-click anywhere in the column.
- 4.
- A.
True
- B.
False
- 5.###### means:
- A.
You've entered a number wrong.
- B.
You've misspelled something.
- C.
The cell is not wide enough.
- 6.
- A.
True
- B.
False
- 7.
- A.
CTRL
- B.
SHIFT
- C.
ALT
- 8.To copy an entire worksheet and all its data, you should click the worksheet tab of the sheet that you want to copy, hold down SHIFT, and then drag the selected sheet along the row of sheet tabs.
- A.
True
- B.
False
- 9.
- A.
Go to FILE - SAVE AS - SAVE AS TYPE - Excel 4.0 Work Sheet
- B.
Right click on the spreadsheet tab and select DELETE
- C.
Right click on the spreadsheet and select INSERT - ENTIRE COLUMN
- 10.
- A.
Count
- B.
Average
- C.
Sum
- 11.
- A.
Yes
- B.
No
- 12.Can an Excel spreadsheet be used as the "data source" for a Word Mail Merge?
- A.
Yes
- B.
No
- 13.On an Excel sheet, the active cell is indicated by ____.
- A.
A dark wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
- 14.
- A.
True
- B.
False
- 15.
- A.
^
- B.
@
- C.
*
- D.
#
- 16.
- A.
True
- B.
False
- 17.
- 18.
- 19.
- 20.
Back to top