EXCEL CRASH COURSE EXAM 300 ACTUAL
QUESTIONS AND CORRECT ANSWERS WITH
RATIONALE LATEST UPDATE ALREADY GRADED A+
This comprehensive 300-question Excel Crash Course exam bank is meticulously
structured to mirror professional certification exams, covering all core domains
including environment navigation, data entry and formatting, formulas and
functions (VLOOKUP, XLOOKUP, INDEX-MATCH, financial functions, logical
operations), charts and PivotTables, and advanced modeling techniques such as
sensitivity analysis, scenario management, and formula auditing. Each question
presents a realistic Excel scenario requiring application of shortcuts, functions,
formatting best practices, or data analysis tools. Every entry includes four multiple-
choice options, one correct answer, and a detailed rationale explaining the
underlying Excel principle. This resource is ideal for self-assessment, remediation,
or targeted review, providing thorough preparation for Wall Street Prep-style Excel
Crash Course exams, Microsoft Office Specialist certifications (MO-200, MO-210,
MO-211), and professional financial modeling assessments.
Domain 1: Excel Environment and Navigation (Questions 1-50)
This domain covers workbook management, worksheet navigation, keyboard
shortcuts, and interface customization.
Question 1
What is the keyboard shortcut to open an existing file in Excel?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + F12
D) Alt + O
Answer: B
Rationale: Ctrl + O is the standard shortcut to open an existing file. Ctrl + N opens
a new file. Ctrl + F12 also opens the Open dialog in some versions, but Ctrl + O is
the primary shortcut. Alt + O opens the Format menu in older versions.
,Question 2
Which keyboard shortcut does NOT add a new worksheet to a workbook?
A) Shift + F11
B) Alt + Shift + F1
C) Alt + H + I + W
D) Alt + I + W
Answer: C
Rationale: Alt + H + I + W is not a valid shortcut for inserting a new worksheet.
Shift + F11, Alt + Shift + F1, and Alt + I + W are all valid shortcuts to insert a new
sheet. The Alt + H + I + W sequence does not exist in the Excel ribbon navigation.
Question 3
How many worksheets does a new Excel workbook contain by default in current
versions?
A) 1
B) 3
C) 5
D) 7
Answer: A
Rationale: Starting with Excel 2016, the default number of worksheets in a new
workbook is 1. Earlier versions (Excel 2007-2013) defaulted to 3 sheets. This
setting can be changed in Excel Options under the General tab.
Question 4
What does the Ctrl + Page Down shortcut do?
A) Scrolls down one screen
B) Moves to the next worksheet
C) Moves to the next workbook
D) Opens page setup
Answer: B
Rationale: Ctrl + Page Down cycles through worksheets to the right. Ctrl + Page
Up moves to the previous worksheet. These shortcuts are essential for navigating
multi-sheet workbooks efficiently.
,Question 5
Which key allows you to jump between tabs in the Format Cells dialog box?
A) Ctrl + Tab
B) Alt + Tab
C) Shift + Tab
D) F6
Answer: A
Rationale: Ctrl + Tab switches between tabs in dialog boxes such as Format Cells
(Number, Alignment, Font, Border, Fill, Protection). This is a useful navigation
shortcut when working with multi-tab dialog windows.
Question 6
What is the keyboard shortcut to select the entire worksheet?
A) Ctrl + A
B) Ctrl + Shift + Space
C) Both A and B
D) Ctrl + W
Answer: C
Rationale: Both Ctrl + A and Ctrl + Shift + Space select the entire worksheet.
Pressing Ctrl + A once selects the current region; pressing it twice selects the entire
sheet. Ctrl + W closes the current workbook.
Question 7
What does the Name Box display?
A) The active cell's address
B) The active cell's content
C) The workbook name
D) The worksheet name
Answer: A
Rationale: The Name Box, located to the left of the Formula Bar, displays the
address of the currently selected cell or range. It can also be used to create named
ranges and navigate to specific cells.
, Question 8
What is the keyboard shortcut to open the Format Cells dialog box?
A) Ctrl + 1
B) Ctrl + 2
C) Ctrl + Shift + 1
D) Ctrl + Shift + F
Answer: A
Rationale: Ctrl + 1 opens the Format Cells dialog box, which contains tabs for
Number, Alignment, Font, Border, Fill, and Protection. Ctrl + 2 applies bold
formatting. Ctrl + Shift + 1 applies number format with two decimal places.
Question 9
What is the recommended calculation setting for Excel in financial modeling?
A) Manual
B) Automatic
C) Automatic except for Data Tables
D) Iterate
Answer: C
Rationale: "Automatic except for Data Tables" optimizes performance by
excluding data tables from automatic recalculation. Data tables can slow Excel
significantly, so this setting allows them to recalculate only when the user presses
F9.
Question 10
Which shortcut opens the Paste Special dialog?
A) Ctrl + V
B) Alt + E + S
C) Ctrl + Shift + V
D) Alt + H + V + S
Answer: B
Rationale: Both Alt + E + S and Alt + H + V + S open the Paste Special dialog.
Paste Special allows users to paste values, formats, formulas, comments, and
perform arithmetic operations during paste.
QUESTIONS AND CORRECT ANSWERS WITH
RATIONALE LATEST UPDATE ALREADY GRADED A+
This comprehensive 300-question Excel Crash Course exam bank is meticulously
structured to mirror professional certification exams, covering all core domains
including environment navigation, data entry and formatting, formulas and
functions (VLOOKUP, XLOOKUP, INDEX-MATCH, financial functions, logical
operations), charts and PivotTables, and advanced modeling techniques such as
sensitivity analysis, scenario management, and formula auditing. Each question
presents a realistic Excel scenario requiring application of shortcuts, functions,
formatting best practices, or data analysis tools. Every entry includes four multiple-
choice options, one correct answer, and a detailed rationale explaining the
underlying Excel principle. This resource is ideal for self-assessment, remediation,
or targeted review, providing thorough preparation for Wall Street Prep-style Excel
Crash Course exams, Microsoft Office Specialist certifications (MO-200, MO-210,
MO-211), and professional financial modeling assessments.
Domain 1: Excel Environment and Navigation (Questions 1-50)
This domain covers workbook management, worksheet navigation, keyboard
shortcuts, and interface customization.
Question 1
What is the keyboard shortcut to open an existing file in Excel?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + F12
D) Alt + O
Answer: B
Rationale: Ctrl + O is the standard shortcut to open an existing file. Ctrl + N opens
a new file. Ctrl + F12 also opens the Open dialog in some versions, but Ctrl + O is
the primary shortcut. Alt + O opens the Format menu in older versions.
,Question 2
Which keyboard shortcut does NOT add a new worksheet to a workbook?
A) Shift + F11
B) Alt + Shift + F1
C) Alt + H + I + W
D) Alt + I + W
Answer: C
Rationale: Alt + H + I + W is not a valid shortcut for inserting a new worksheet.
Shift + F11, Alt + Shift + F1, and Alt + I + W are all valid shortcuts to insert a new
sheet. The Alt + H + I + W sequence does not exist in the Excel ribbon navigation.
Question 3
How many worksheets does a new Excel workbook contain by default in current
versions?
A) 1
B) 3
C) 5
D) 7
Answer: A
Rationale: Starting with Excel 2016, the default number of worksheets in a new
workbook is 1. Earlier versions (Excel 2007-2013) defaulted to 3 sheets. This
setting can be changed in Excel Options under the General tab.
Question 4
What does the Ctrl + Page Down shortcut do?
A) Scrolls down one screen
B) Moves to the next worksheet
C) Moves to the next workbook
D) Opens page setup
Answer: B
Rationale: Ctrl + Page Down cycles through worksheets to the right. Ctrl + Page
Up moves to the previous worksheet. These shortcuts are essential for navigating
multi-sheet workbooks efficiently.
,Question 5
Which key allows you to jump between tabs in the Format Cells dialog box?
A) Ctrl + Tab
B) Alt + Tab
C) Shift + Tab
D) F6
Answer: A
Rationale: Ctrl + Tab switches between tabs in dialog boxes such as Format Cells
(Number, Alignment, Font, Border, Fill, Protection). This is a useful navigation
shortcut when working with multi-tab dialog windows.
Question 6
What is the keyboard shortcut to select the entire worksheet?
A) Ctrl + A
B) Ctrl + Shift + Space
C) Both A and B
D) Ctrl + W
Answer: C
Rationale: Both Ctrl + A and Ctrl + Shift + Space select the entire worksheet.
Pressing Ctrl + A once selects the current region; pressing it twice selects the entire
sheet. Ctrl + W closes the current workbook.
Question 7
What does the Name Box display?
A) The active cell's address
B) The active cell's content
C) The workbook name
D) The worksheet name
Answer: A
Rationale: The Name Box, located to the left of the Formula Bar, displays the
address of the currently selected cell or range. It can also be used to create named
ranges and navigate to specific cells.
, Question 8
What is the keyboard shortcut to open the Format Cells dialog box?
A) Ctrl + 1
B) Ctrl + 2
C) Ctrl + Shift + 1
D) Ctrl + Shift + F
Answer: A
Rationale: Ctrl + 1 opens the Format Cells dialog box, which contains tabs for
Number, Alignment, Font, Border, Fill, and Protection. Ctrl + 2 applies bold
formatting. Ctrl + Shift + 1 applies number format with two decimal places.
Question 9
What is the recommended calculation setting for Excel in financial modeling?
A) Manual
B) Automatic
C) Automatic except for Data Tables
D) Iterate
Answer: C
Rationale: "Automatic except for Data Tables" optimizes performance by
excluding data tables from automatic recalculation. Data tables can slow Excel
significantly, so this setting allows them to recalculate only when the user presses
F9.
Question 10
Which shortcut opens the Paste Special dialog?
A) Ctrl + V
B) Alt + E + S
C) Ctrl + Shift + V
D) Alt + H + V + S
Answer: B
Rationale: Both Alt + E + S and Alt + H + V + S open the Paste Special dialog.
Paste Special allows users to paste values, formats, formulas, comments, and
perform arithmetic operations during paste.
