Basic Excel Exam
Settings
-
+
Microsoft Excel is a spreadsheet program used for calculations, making charts and recording data about all sorts of business processes. Most companies wish for their staff to have adequate knowledge on how to use this application. Take an exam to see how well you know some Excel basics. The content in this quiz was excerpted from Training on Microsoft Office Online.
- 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.
- A.
You've entered a number wrong.
- B.
You've misspelled something.
- C.
The cell is not wide enough.
- 6.To add a new row, click a cell in the row immediately above where you want the new row.
- A.
True
- B.
False
- 7.
- A.
CTRL.
- B.
SHIFT
- C.
ALT
- 8.
- A.
True
- B.
False
- 9.Which formula can add the 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
- 10.
- A.
Yes
- B.
No
- 11.
- A.
Yes
- B.
No
- 12.
- A.
A dark wide border
- B.
A dotted border
- C.
A blinking border
- D.
None of the above
- 13.A Formula and a function are the same thing.
- A.
True
- B.
False
- 14.In order to multiply items in Excel you would use:
- A.
^
- B.
@
- C.
*
- D.
#
- 15.The formula = ((A2+B5)*5% is valid
- A.
True
- B.
False
Back to top