1|Page
Excel Crash Course Exam from Wall Street Prep Newest
Version - Wall Street Prep Questions And
Answers(VERIFIED ANSWERS)|Brand New Version !!
Question 21
What is the primary purpose of Excel?
A. Data analysis and calculations
B. Video editing
C. Web browsing
D. Game development
Answer: A. Data analysis and calculations
Rationale: Excel is used for organizing and analyzing data.
Question 22
Which symbol is used to start a formula in Excel?
A. =
B. +
C. #
D. @
Answer: A. =
Rationale: All Excel formulas begin with "=".
pg. 1
,2|Page
Question 23
What does the SUM function do?
A. Adds numbers
B. Subtracts numbers
C. Finds text
D. Deletes data
Answer: A. Adds numbers
Rationale: SUM calculates total values in a range.
Question 24
Which function finds the average?
A. AVERAGE
B. TOTAL
C. MEANING
D. SUMIF
Answer: A. AVERAGE
Rationale: AVERAGE returns the mean of values.
Question 25
What is a cell in Excel?
A. Intersection of row and column
B. Entire worksheet
pg. 2
,3|Page
C. Chart area
D. File type
Answer: A. Intersection of row and column
Rationale: Cells store individual data points.
Question 26
Which feature automatically fills a series?
A. AutoFill
B. Merge
C. Filter
D. Sort
Answer: A. AutoFill
Rationale: AutoFill continues patterns automatically.
Question 27
What is the file extension for Excel files?
A. .xlsx
B. .docx
C. .pptx
D. .txt
Answer: A. .xlsx
pg. 3
, 4|Page
Rationale: Modern Excel files use .xlsx format.
Question 28
What does the MAX function do?
A. Finds largest value
B. Finds smallest value
C. Counts text
D. Adds values
Answer: A. Finds largest value
Rationale: MAX returns the highest number.
Question 29
What does the MIN function do?
A. Finds smallest value
B. Finds largest value
C. Multiplies values
D. Counts cells
Answer: A. Finds smallest value
Rationale: MIN returns the lowest number.
Question 30
Which symbol is used for multiplication?
pg. 4
Excel Crash Course Exam from Wall Street Prep Newest
Version - Wall Street Prep Questions And
Answers(VERIFIED ANSWERS)|Brand New Version !!
Question 21
What is the primary purpose of Excel?
A. Data analysis and calculations
B. Video editing
C. Web browsing
D. Game development
Answer: A. Data analysis and calculations
Rationale: Excel is used for organizing and analyzing data.
Question 22
Which symbol is used to start a formula in Excel?
A. =
B. +
C. #
D. @
Answer: A. =
Rationale: All Excel formulas begin with "=".
pg. 1
,2|Page
Question 23
What does the SUM function do?
A. Adds numbers
B. Subtracts numbers
C. Finds text
D. Deletes data
Answer: A. Adds numbers
Rationale: SUM calculates total values in a range.
Question 24
Which function finds the average?
A. AVERAGE
B. TOTAL
C. MEANING
D. SUMIF
Answer: A. AVERAGE
Rationale: AVERAGE returns the mean of values.
Question 25
What is a cell in Excel?
A. Intersection of row and column
B. Entire worksheet
pg. 2
,3|Page
C. Chart area
D. File type
Answer: A. Intersection of row and column
Rationale: Cells store individual data points.
Question 26
Which feature automatically fills a series?
A. AutoFill
B. Merge
C. Filter
D. Sort
Answer: A. AutoFill
Rationale: AutoFill continues patterns automatically.
Question 27
What is the file extension for Excel files?
A. .xlsx
B. .docx
C. .pptx
D. .txt
Answer: A. .xlsx
pg. 3
, 4|Page
Rationale: Modern Excel files use .xlsx format.
Question 28
What does the MAX function do?
A. Finds largest value
B. Finds smallest value
C. Counts text
D. Adds values
Answer: A. Finds largest value
Rationale: MAX returns the highest number.
Question 29
What does the MIN function do?
A. Finds smallest value
B. Finds largest value
C. Multiplies values
D. Counts cells
Answer: A. Finds smallest value
Rationale: MIN returns the lowest number.
Question 30
Which symbol is used for multiplication?
pg. 4
