Excel Assessment - Level 1
8 Questions
| Attempts: 1219
This assessment will be used to measure your knowledge of Excel.
Questions and Answers
- 1.C4:D11 is an example of a .
- A.
Formula
- B.
Range
- C.
Column
- D.
Cell
- 2.What symbol is missing in the beginning of this formula? SUM(B2:B11)
- A.
;
- B.
*
- C.
=
- D.
/
- E.
//
- 3.There are multiple ways to insert a hyperlink into a cell.
- A.
True
- B.
False
- 4.Data can be sorted by ____________ ? (Please check all answers that apply)
- A.
Font type
- B.
Value
- C.
Cell Color
- D.
Alphabetically
- E.
All of the above
- 5.The two orientation styles of a page layout are landscape and .
- 6.If you need a total of C1:D2, which of the following would you use? (Check all answers that apply)
- A.
Sum(C1:D2)
- B.
Total(C1:D2)
- C.
C1+D2
- D.
C1+C2+D1+D2
- 7.Select the best description(s) for applying a macro to a sheet.
- A.
Insert -> Sheet Options -> Insert Macro
- B.
View -> Record Macro -> Stop Recording
- C.
Developer -> Design Mode -> Run Macro -> Stop Macro
- D.
Developer -> Record Macro -> Stop Recording
- E.
Both B and D
Related Topics
Recent Quizzes
Back to top