Excel Crash Course – Wall Street Prep Study Guide 2026 |
Complete Financial Modeling Excel Training Notes, Formulas,
Shortcuts & Practical Exercises for Wall Street Prep Excel
Course Mastery
Question 1: What is the shortcut for creating a new worksheet in Excel?
A) Ctrl + N
B) Ctrl + Shift + N
C) Ctrl + T
D) Ctrl + W
Correct Option: A) Ctrl + N
Rationale: Ctrl + N is the keyboard shortcut to create a new workbook in Excel, including new
worksheets within an existing workbook.
Question 2: Which function is used to find the average of a range of cells?
A) SUM
B) AVG
C) MEAN
D) AVERAGE
Correct Option: D) AVERAGE
Rationale: The AVERAGE function calculates the mean of a specified range of cells in Excel.
Question 3: What does the VLOOKUP function do?
A) Looks up a value across multiple columns.
B) Looks up a value in a table and returns a value in the same row from a specified
column.
C) Validates data entries in a specific range.
D) Exports data to a different format.
Correct Option: B) Looks up a value in a table and returns a value in the same row from a
specified column.
Rationale: VLOOKUP is a vertical lookup function that searches for a value in the first column
of a table and returns a value in the same row from a specified column.
, Excel Crash Course – Wall Street Prep Study Guide 2026 |
Complete Financial Modeling Excel Training Notes, Formulas,
Shortcuts & Practical Exercises for Wall Street Prep Excel
Course Mastery
Question 4: How can you adjust the width of a column automatically to fit the contents?
A) Double-click the right border of the column header.
B) Right-click the column header and select "Adjust Width."
C) Use the "Format" menu to select "AutoFit Column Width."
D) Hold down Alt and click the column header.
Correct Option: A) Double-click the right border of the column header.
Rationale: Double-clicking the right border of a column header automatically resizes the column
to fit the contents.
Question 5: What is the primary function of the Freeze Panes feature in Excel?
A) To remove rows and columns from view.
B) To keep specific rows or columns visible while scrolling through the rest of the
worksheet.
C) To disable cell editing.
D) To protect the worksheet from unwanted changes.
Correct Option: B) To keep specific rows or columns visible while scrolling through the
rest of the worksheet.
Rationale: The Freeze Panes feature allows you to keep header rows or columns visible, which
helps when navigating large datasets
Question 6: Which symbol is used to make a cell reference absolute?
A) %
B) &
C) $
D) #
Correct Option: C) $
Rationale: The dollar sign ($) is used to denote an absolute reference in cell addresses,
preventing it from changing when copied.
Complete Financial Modeling Excel Training Notes, Formulas,
Shortcuts & Practical Exercises for Wall Street Prep Excel
Course Mastery
Question 1: What is the shortcut for creating a new worksheet in Excel?
A) Ctrl + N
B) Ctrl + Shift + N
C) Ctrl + T
D) Ctrl + W
Correct Option: A) Ctrl + N
Rationale: Ctrl + N is the keyboard shortcut to create a new workbook in Excel, including new
worksheets within an existing workbook.
Question 2: Which function is used to find the average of a range of cells?
A) SUM
B) AVG
C) MEAN
D) AVERAGE
Correct Option: D) AVERAGE
Rationale: The AVERAGE function calculates the mean of a specified range of cells in Excel.
Question 3: What does the VLOOKUP function do?
A) Looks up a value across multiple columns.
B) Looks up a value in a table and returns a value in the same row from a specified
column.
C) Validates data entries in a specific range.
D) Exports data to a different format.
Correct Option: B) Looks up a value in a table and returns a value in the same row from a
specified column.
Rationale: VLOOKUP is a vertical lookup function that searches for a value in the first column
of a table and returns a value in the same row from a specified column.
, Excel Crash Course – Wall Street Prep Study Guide 2026 |
Complete Financial Modeling Excel Training Notes, Formulas,
Shortcuts & Practical Exercises for Wall Street Prep Excel
Course Mastery
Question 4: How can you adjust the width of a column automatically to fit the contents?
A) Double-click the right border of the column header.
B) Right-click the column header and select "Adjust Width."
C) Use the "Format" menu to select "AutoFit Column Width."
D) Hold down Alt and click the column header.
Correct Option: A) Double-click the right border of the column header.
Rationale: Double-clicking the right border of a column header automatically resizes the column
to fit the contents.
Question 5: What is the primary function of the Freeze Panes feature in Excel?
A) To remove rows and columns from view.
B) To keep specific rows or columns visible while scrolling through the rest of the
worksheet.
C) To disable cell editing.
D) To protect the worksheet from unwanted changes.
Correct Option: B) To keep specific rows or columns visible while scrolling through the
rest of the worksheet.
Rationale: The Freeze Panes feature allows you to keep header rows or columns visible, which
helps when navigating large datasets
Question 6: Which symbol is used to make a cell reference absolute?
A) %
B) &
C) $
D) #
Correct Option: C) $
Rationale: The dollar sign ($) is used to denote an absolute reference in cell addresses,
preventing it from changing when copied.
