EXCEL CRASH COURSE EXAM MODULE
1,2,3,4,5,6,7 & 8 WITH CERIFIED RATIONALES
AND REVISED ANSWERS WITH QUESTIONS 2025 -
2026 | GRADED A+ | 100 % GUARANTEED |
Almost everything that can be done in Excel using a mouse can also be done using:
A) Only VBA
B) Touch commands
C) Keyboard shortcuts
D) The Quick Access Toolbar
Answer: C) Keyboard shortcuts
Rationale: Excel is designed so nearly all actions performed with a mouse can also be
executed using keyboard shortcuts, improving speed and efficiency.
What is considered the best way to learn Excel keyboard shortcuts?
A) Memorizing shortcut lists
B) Watching tutorial videos
C) Disconnecting the mouse and using only the keyboard
D) Practicing formulas only
Answer: C) Disconnecting the mouse and using only the keyboard
Rationale: Removing the mouse forces users to rely on shortcuts, accelerating mastery of
keyboard navigation.
The Name Box in Excel tells you:
A) The formula in the active cell
B) The file name
C) What cell you are currently in
D) The worksheet name
Answer: C) What cell you are currently in
Rationale: The Name Box, located to the left of the formula bar, displays the active cell
reference.
Where is the Formula Bar located?
A) At the bottom of the worksheet
,B) Next to the status bar
C) Below the ribbon next to “fx”
D) On the right-hand panel
Answer: C) Below the ribbon next to “fx”
Rationale: The Formula Bar shows formulas entered into cells and is positioned directly
below the ribbon.
When you enter a formula and press Enter, what does the cell display?
A) The formula
B) The calculation result
C) An error message
D) Nothing
Answer: B) The calculation result
Rationale: Excel displays the output of a formula in the cell, while the formula itself appears
in the Formula Bar.
An Excel file is referred to as a:
A) Spreadsheet
B) Worksheet
C) Workbook
D) Database
Answer: C) Workbook
Rationale: A workbook is the entire Excel file and can contain multiple worksheets.
How many worksheets does a new Excel workbook start with by default?
A) Zero
B) One
C) Three
D) Five
Answer: B) One
Rationale: Modern versions of Excel start with one worksheet, though additional sheets can
be added.
The active worksheet in Excel is identified by:
A) A bold border
,B) A highlighted tab
C) A blinking cursor
D) A shaded background
Answer: B) A highlighted tab
Rationale: The active worksheet tab is visually highlighted at the bottom of the workbook.
Which keyboard shortcut moves between worksheets in Excel on Windows?
A) Ctrl + Tab
B) Ctrl + Arrow Keys
C) Ctrl + Page Up / Page Down
D) Alt + Page Up / Page Down
Answer: C) Ctrl + Page Up / Page Down
Rationale: This shortcut allows quick navigation between worksheets without using the
mouse.
Which shortcut adds a new worksheet to a workbook?
A) Ctrl + N
B) Shift + F11
C) Alt + Enter
D) Ctrl + Shift + S
Answer: B) Shift + F11
Rationale: Shift + F11 instantly inserts a new worksheet.
Columns in Excel are labeled using:
A) Numbers
B) Roman numerals
C) Letters
D) Symbols
Answer: C) Letters
Rationale: Columns are labeled alphabetically (A, B, C, etc.).
Rows in Excel are labeled using:
A) Letters
B) Numbers
, C) Colors
D) Roman numerals
Answer: B) Numbers
Rationale: Rows are numbered sequentially starting from 1.
Which tab contains most formatting tools such as fonts, alignment, and number formats?
A) Insert
B) Page Layout
C) Home
D) View
Answer: C) Home
Rationale: The Home tab contains the most commonly used formatting options.
Which Excel tab includes PivotTables and Charts?
A) Home
B) Data
C) Insert
D) Review
Answer: C) Insert
Rationale: The Insert tab is used to add objects such as PivotTables, charts, and headers.
Which tab contains tools such as Trace Precedents and Trace Dependents?
A) Data
B) Formulas
C) Review
D) Developer
Answer: B) Formulas
Rationale: Formula auditing tools are found under the Formulas tab.
Which Excel tab includes sorting, filtering, and Text to Columns?
A) Insert
B) Home
C) Data
D) View
1,2,3,4,5,6,7 & 8 WITH CERIFIED RATIONALES
AND REVISED ANSWERS WITH QUESTIONS 2025 -
2026 | GRADED A+ | 100 % GUARANTEED |
Almost everything that can be done in Excel using a mouse can also be done using:
A) Only VBA
B) Touch commands
C) Keyboard shortcuts
D) The Quick Access Toolbar
Answer: C) Keyboard shortcuts
Rationale: Excel is designed so nearly all actions performed with a mouse can also be
executed using keyboard shortcuts, improving speed and efficiency.
What is considered the best way to learn Excel keyboard shortcuts?
A) Memorizing shortcut lists
B) Watching tutorial videos
C) Disconnecting the mouse and using only the keyboard
D) Practicing formulas only
Answer: C) Disconnecting the mouse and using only the keyboard
Rationale: Removing the mouse forces users to rely on shortcuts, accelerating mastery of
keyboard navigation.
The Name Box in Excel tells you:
A) The formula in the active cell
B) The file name
C) What cell you are currently in
D) The worksheet name
Answer: C) What cell you are currently in
Rationale: The Name Box, located to the left of the formula bar, displays the active cell
reference.
Where is the Formula Bar located?
A) At the bottom of the worksheet
,B) Next to the status bar
C) Below the ribbon next to “fx”
D) On the right-hand panel
Answer: C) Below the ribbon next to “fx”
Rationale: The Formula Bar shows formulas entered into cells and is positioned directly
below the ribbon.
When you enter a formula and press Enter, what does the cell display?
A) The formula
B) The calculation result
C) An error message
D) Nothing
Answer: B) The calculation result
Rationale: Excel displays the output of a formula in the cell, while the formula itself appears
in the Formula Bar.
An Excel file is referred to as a:
A) Spreadsheet
B) Worksheet
C) Workbook
D) Database
Answer: C) Workbook
Rationale: A workbook is the entire Excel file and can contain multiple worksheets.
How many worksheets does a new Excel workbook start with by default?
A) Zero
B) One
C) Three
D) Five
Answer: B) One
Rationale: Modern versions of Excel start with one worksheet, though additional sheets can
be added.
The active worksheet in Excel is identified by:
A) A bold border
,B) A highlighted tab
C) A blinking cursor
D) A shaded background
Answer: B) A highlighted tab
Rationale: The active worksheet tab is visually highlighted at the bottom of the workbook.
Which keyboard shortcut moves between worksheets in Excel on Windows?
A) Ctrl + Tab
B) Ctrl + Arrow Keys
C) Ctrl + Page Up / Page Down
D) Alt + Page Up / Page Down
Answer: C) Ctrl + Page Up / Page Down
Rationale: This shortcut allows quick navigation between worksheets without using the
mouse.
Which shortcut adds a new worksheet to a workbook?
A) Ctrl + N
B) Shift + F11
C) Alt + Enter
D) Ctrl + Shift + S
Answer: B) Shift + F11
Rationale: Shift + F11 instantly inserts a new worksheet.
Columns in Excel are labeled using:
A) Numbers
B) Roman numerals
C) Letters
D) Symbols
Answer: C) Letters
Rationale: Columns are labeled alphabetically (A, B, C, etc.).
Rows in Excel are labeled using:
A) Letters
B) Numbers
, C) Colors
D) Roman numerals
Answer: B) Numbers
Rationale: Rows are numbered sequentially starting from 1.
Which tab contains most formatting tools such as fonts, alignment, and number formats?
A) Insert
B) Page Layout
C) Home
D) View
Answer: C) Home
Rationale: The Home tab contains the most commonly used formatting options.
Which Excel tab includes PivotTables and Charts?
A) Home
B) Data
C) Insert
D) Review
Answer: C) Insert
Rationale: The Insert tab is used to add objects such as PivotTables, charts, and headers.
Which tab contains tools such as Trace Precedents and Trace Dependents?
A) Data
B) Formulas
C) Review
D) Developer
Answer: B) Formulas
Rationale: Formula auditing tools are found under the Formulas tab.
Which Excel tab includes sorting, filtering, and Text to Columns?
A) Insert
B) Home
C) Data
D) View
