MICROSOFT EXCEL EXAM
Cancel
-
+
Take an exam to see how well you know some Excel basics. Content in this quiz was excerpted from Training on Microsoft Office Online.
- 1.A fast way to add up this column of numbers is to click in the cell below the numbers and then:
- 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.Say that 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.There are three worksheets with every new workbook. You can change that automatic number if you want to.
- A.
True
- B.
False
- 5.
- 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.
- A.
True
- B.
False
- 9.A user wishes to remove a spreadsheet from a workbook. Which is the correct sequence of events that will do this ?
- 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.Is it possible to insert an image from a file into an Excel spreadsheet ?
- 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.In order to multiply items in Excel you would use:
- A.
^
- B.
@
- C.
*
- D.
#
- 16.
- A.
True
- B.
False
- 17.
- 18.
- 19.
- 20.
Back to top
