Excel Crash Course Exam (Wall Street Prep) Actual Exam and Practice Tests Newest with Complete Questions and Correct Detailed Answers| Brand New Version!

Excel Crash Course Exam (Wall Street
Prep) Actual Exam and Practice Tests
Newest with Complete Questions and
Correct Detailed Answers| Brand New
Version!
1. Which symbol is used to begin a formula in Excel?
A. @
B. #
C. =
D. %
Answer: C
Rationale: All Excel formulas begin with an equal sign (=).
2. Which function adds a range of numbers?
A. COUNT
B. SUM
C. AVERAGE
D. MAX
Answer: B
Rationale: SUM returns the total of selected values.
3. Which function calculates the average of a range?
A. AVERAGE
B. SUM
C. COUNT
D. MIN
Answer: A
Rationale: AVERAGE returns the arithmetic mean.

,4. Which function returns the largest value in a range?
A. MAX
B. MIN
C. SUM
D. COUNT
Answer: A
Rationale: MAX identifies the highest value.
5. Which function returns the smallest value in a range?
A. MAX
B. MIN
C. AVERAGE
D. ROUND
Answer: B
Rationale: MIN identifies the lowest value.
6. What does the COUNT function do?
A. Counts text cells
B. Counts numeric cells
C. Counts formulas only
D. Counts blank cells
Answer: B
Rationale: COUNT counts cells containing numbers.
7. Which key edits the active cell?
A. F1
B. F2
C. F4
D. F7
Answer: B
Rationale: F2 places the cursor into edit mode.
8. Which shortcut copies selected cells?
A. Ctrl + V
B. Ctrl + X

, C. Ctrl + C
D. Ctrl + Z
Answer: C
Rationale: Ctrl+C copies selected content.
9. Which shortcut pastes copied content?
A. Ctrl + P
B. Ctrl + V
C. Ctrl + D
D. Ctrl + S
Answer: B
Rationale: Ctrl+V pastes copied data.
10. Which shortcut saves a workbook?
A. Ctrl + S
B. Ctrl + A
C. Ctrl + B
D. Ctrl + F
Answer: A
Rationale: Ctrl+S saves the current workbook.
11. What is a workbook?
A. A single cell
B. An Excel file
C. A formula
D. A chart only
Answer: B
Rationale: A workbook is the entire Excel file.
12. What is a worksheet?
A. A page within a workbook
B. A formula
C. A chart
D. A function