EXCEL CRASH COURSE WALL STREET PREP
FINAL COMPREHENSIVE ASSESSMENT TEST
PAPER QUESTIONS AND SOLUTIONS
⩥ What is the syntax for the SUM function?
Answer: =SUM(range)
⩥ How do you use AutoSum in Excel?
Answer: Select the cell and click the AutoSum button; Excel proposes a
range automatically.
⩥ What does the AVERAGE function return?
Answer: The arithmetic mean of a specified range.
⩥ What is the syntax for the AVERAGE function?
Answer: =AVERAGE(range)
⩥ What do the MAX and MIN functions return?
Answer: MAX returns the largest value; MIN returns the smallest value
in a specified range.
⩥ What is the syntax for the MAX function?
,Answer: =MAX(range)
⩥ What is the syntax for the MIN function?
Answer: =MIN(range)
⩥ What does the IF function do?
Answer: Returns one value if a condition is TRUE, and another if
FALSE.
⩥ What is the syntax for the IF function?
Answer: =IF(logical_test, value_if_true, value_if_false)
⩥ What is a nested IF function?
Answer: An IF function within another IF function for more complex
logic.
⩥ How do you calculate a percentage in Excel?
Answer: Use the formula =cell/total_cell and format the cell as
Percentage.
⩥ What is the purpose of absolute references in Excel?
Answer: To lock a specific cell reference so it does not change when
copying the formula.
, ⩥ What is the syntax for an absolute reference?
Answer: $A$1 (both row and column are fixed).
⩥ What does a mixed reference look like?
Answer: $A1 (column fixed, row adjusts) or A$1 (row fixed, column
adjusts).
⩥ What is the first step to sort data in Excel?
Answer: Select the entire data range including headers.
⩥ What should you check when sorting data that has headers?
Answer: Always check the box indicating that the data has headers.
⩥ How do you format numbers in Excel?
Answer: Use the Comma Style button in the Home tab's Number group.
⩥ How do you apply conditional formatting in Excel?
Answer: Select the range, go to Home tab > Conditional Formatting, and
choose a style.
⩥ What are data bars in conditional formatting?
FINAL COMPREHENSIVE ASSESSMENT TEST
PAPER QUESTIONS AND SOLUTIONS
⩥ What is the syntax for the SUM function?
Answer: =SUM(range)
⩥ How do you use AutoSum in Excel?
Answer: Select the cell and click the AutoSum button; Excel proposes a
range automatically.
⩥ What does the AVERAGE function return?
Answer: The arithmetic mean of a specified range.
⩥ What is the syntax for the AVERAGE function?
Answer: =AVERAGE(range)
⩥ What do the MAX and MIN functions return?
Answer: MAX returns the largest value; MIN returns the smallest value
in a specified range.
⩥ What is the syntax for the MAX function?
,Answer: =MAX(range)
⩥ What is the syntax for the MIN function?
Answer: =MIN(range)
⩥ What does the IF function do?
Answer: Returns one value if a condition is TRUE, and another if
FALSE.
⩥ What is the syntax for the IF function?
Answer: =IF(logical_test, value_if_true, value_if_false)
⩥ What is a nested IF function?
Answer: An IF function within another IF function for more complex
logic.
⩥ How do you calculate a percentage in Excel?
Answer: Use the formula =cell/total_cell and format the cell as
Percentage.
⩥ What is the purpose of absolute references in Excel?
Answer: To lock a specific cell reference so it does not change when
copying the formula.
, ⩥ What is the syntax for an absolute reference?
Answer: $A$1 (both row and column are fixed).
⩥ What does a mixed reference look like?
Answer: $A1 (column fixed, row adjusts) or A$1 (row fixed, column
adjusts).
⩥ What is the first step to sort data in Excel?
Answer: Select the entire data range including headers.
⩥ What should you check when sorting data that has headers?
Answer: Always check the box indicating that the data has headers.
⩥ How do you format numbers in Excel?
Answer: Use the Comma Style button in the Home tab's Number group.
⩥ How do you apply conditional formatting in Excel?
Answer: Select the range, go to Home tab > Conditional Formatting, and
choose a style.
⩥ What are data bars in conditional formatting?
