Basic Quiz On Microsoft Excel Exam!
Settings
-
+
- 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.
- 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.###### 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.
- 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.Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
- 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.If cells: A1=90 A2=85 A3=80 A4=75 A5=75 What will be your formula if you are going to get the total?
- 19.
- 20.
Back to top
