Excel Proficiency Assessment
This assessment was created to evaluate your basic knowledge of Excel. We will use the results to determine what level of training you will receive.
- 1.
To create a formula in Excel you must begin with:
- A.
Parentheses
- B.
Numbers
- C.
Equal Sign
Correct Answer
C. Equal Sign -
- 2.
To add a new column, click a cell in the column to the left of where you want the new column.
- A.
True
- B.
False
Correct Answer
B. False -
- 3.
To add a new row, click a cell in the row immediately below where you want the new row.
- A.
True
- B.
False
Correct Answer
A. True -
- 4.
To delete a column or a row, you click in the column or row you want to delete, and then:
- A.
Press the delete button.
- B.
Click the cut button.
- C.
On the Home tab, in the Cells group, click the Delete button.
Correct Answer
C. On the Home tab, in the Cells group, click the Delete button. -
- 5.
To print a spreadsheet, you:
- A.
Right-click in a cell
- B.
Click the FileTab
- C.
Click the HomeTab
Correct Answer
B. Click the FileTab -
- 6.
If you want to add the values that are in cells C1 and C2 (93 and 14), why would you use cell references in the formula (=C1+C2) instead of just writing the formula like this: =93+14?
- A.
The formula result will automatically update when cell values change.
- B.
The formula will be more accurate.
- C.
The formula is more professional looking.
Correct Answer
A. The formula result will automatically update when cell values change. -
- 7.
You can enter formulas at the bottom of columns and at the end of rows.
- A.
True
- B.
False
Correct Answer
A. True -
- 8.
To fill a formula down a column, you copy and paste it from the first cell into the other cells in the column.
- A.
True
- B.
False
Correct Answer
B. False -
- 9.
You have a list of badly capitalized names. You can tidy up the names by using what function?
- A.
UPPER
- B.
TRIM
- C.
PROPER
Correct Answer
C. PROPER -
- 10.
What type of cell reference is this: $A$1.
- A.
Absolute
- B.
Relative
- C.
Active
Correct Answer
A. Absolute -
- 11.
You can sort more than one column at a time.
- A.
True
- B.
False
Correct Answer
B. False -
- 12.
You can filter more than one column at a time.
- A.
True
- B.
False
Correct Answer
A. True -
- 13.
You can copy cell formats from one cell to another by using the:
- A.
Backspace key
- B.
Default font
- C.
Format Painter
Correct Answer
C. Format Painter -
- 14.
A group of cells that forms a rectangle on a spreadsheet is a:
- A.
Range
- B.
Calculation
- C.
Address
Correct Answer
A. Range -
- 15.
The multiplication arithmetic operator is represented by which of the following symbols?
- A.
`
- B.
*
- C.
/
Correct Answer
B. * -
- 16.
Which of the following displays the contents of the active cell?
- A.
Name Box
- B.
Menu Bar
- C.
Formula Bar
Correct Answer
C. Formula Bar -
- 17.
A descending sort arranges rows in reverse alphabetical order or highest value to lowest.
- A.
True
- B.
False
Correct Answer
A. True -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Jan 22, 2013Quiz Edited by
ProProfs Editorial Team -
Jan 27, 2011Quiz Created by
Soblu113
Back to top