Excel Crash Course Exam Wall
Street Prep 2026/2027 –
Practice Questions, Answers &
Detailed Rationales Guaranteed
Pass (GRADED A+)
Question 1
Which Excel function is commonly used to add a range of
numbers?
A. COUNT
B. SUM
C. AVERAGE
D. MAX
Answer: B. SUM
Rationale: The SUM function adds numbers contained in
selected cells or ranges.
Question 2
What does the $ symbol do in an Excel cell reference?
,A. Formats the cell as currency
B. Creates a formula error
C. Locks a row or column reference
D. Deletes the cell reference
Answer: C. Locks a row or column reference
Rationale: The dollar sign creates an absolute reference for the
row, column, or both. For example, $A$1 locks both the column
and row.
Question 3
Which keyboard shortcut is commonly used to save an Excel
workbook?
A. Ctrl + P
B. Ctrl + S
C. Ctrl + F
D. Ctrl + W
Answer: B. Ctrl + S
Rationale: Ctrl + S saves the current workbook.
Question 4
Which function calculates the arithmetic mean of a group of
numbers?
,A. MEDIAN
B. SUM
C. AVERAGE
D. COUNT
Answer: C. AVERAGE
Rationale: AVERAGE adds the numerical values and divides the
total by the number of included values.
Question 5
What is the primary purpose of VLOOKUP?
A. To format a worksheet
B. To search for a value in the first column of a table and return
related information
C. To create a chart
D. To remove duplicate values
Answer: B. To search for a value in the first column of a table
and return related information
Rationale: VLOOKUP searches vertically through the first
column of a specified table and returns a value from another
column in the same row.
Question 6
, Which function is generally more flexible than VLOOKUP
because it can search in multiple directions?
A. SUMIF
B. XLOOKUP
C. ROUND
D. CONCAT
Answer: B. XLOOKUP
Rationale: XLOOKUP can search a lookup array and return a
corresponding value from another array, including searches to
the left or right.
Question 7
What does the IF function primarily do?
A. Creates a chart
B. Tests a condition and returns different results depending on
whether it is TRUE or FALSE
C. Sorts data alphabetically
D. Converts text into numbers
Answer: B. Tests a condition and returns different results
depending on whether it is TRUE or FALSE
Rationale: IF evaluates a logical test and returns one result
when the test is TRUE and another when it is FALSE.
Street Prep 2026/2027 –
Practice Questions, Answers &
Detailed Rationales Guaranteed
Pass (GRADED A+)
Question 1
Which Excel function is commonly used to add a range of
numbers?
A. COUNT
B. SUM
C. AVERAGE
D. MAX
Answer: B. SUM
Rationale: The SUM function adds numbers contained in
selected cells or ranges.
Question 2
What does the $ symbol do in an Excel cell reference?
,A. Formats the cell as currency
B. Creates a formula error
C. Locks a row or column reference
D. Deletes the cell reference
Answer: C. Locks a row or column reference
Rationale: The dollar sign creates an absolute reference for the
row, column, or both. For example, $A$1 locks both the column
and row.
Question 3
Which keyboard shortcut is commonly used to save an Excel
workbook?
A. Ctrl + P
B. Ctrl + S
C. Ctrl + F
D. Ctrl + W
Answer: B. Ctrl + S
Rationale: Ctrl + S saves the current workbook.
Question 4
Which function calculates the arithmetic mean of a group of
numbers?
,A. MEDIAN
B. SUM
C. AVERAGE
D. COUNT
Answer: C. AVERAGE
Rationale: AVERAGE adds the numerical values and divides the
total by the number of included values.
Question 5
What is the primary purpose of VLOOKUP?
A. To format a worksheet
B. To search for a value in the first column of a table and return
related information
C. To create a chart
D. To remove duplicate values
Answer: B. To search for a value in the first column of a table
and return related information
Rationale: VLOOKUP searches vertically through the first
column of a specified table and returns a value from another
column in the same row.
Question 6
, Which function is generally more flexible than VLOOKUP
because it can search in multiple directions?
A. SUMIF
B. XLOOKUP
C. ROUND
D. CONCAT
Answer: B. XLOOKUP
Rationale: XLOOKUP can search a lookup array and return a
corresponding value from another array, including searches to
the left or right.
Question 7
What does the IF function primarily do?
A. Creates a chart
B. Tests a condition and returns different results depending on
whether it is TRUE or FALSE
C. Sorts data alphabetically
D. Converts text into numbers
Answer: B. Tests a condition and returns different results
depending on whether it is TRUE or FALSE
Rationale: IF evaluates a logical test and returns one result
when the test is TRUE and another when it is FALSE.
