EXCEL CRASH COURSE EXAM 2026 PRACTICE
TEST SHEET FULL SOLUTIONS CORRECT
ANSWERS PREPARATION SET
◉ Control + Space
Answer: highlight column
◉ Shift + Space
Answer: highlight row
◉ Command + B
Answer: bold
◉ Command + I
Answer: italicize
◉ Alt e s / control command v
Answer: paste special
◉ What is the keyboard shortcut to move sheets within a workbook?
Answer: Alt H O M
, ◉ What is the keyboard shortcut to open the formatting cells dialog
box?
Answer: Ctrl 1
◉ What are the keyboard shortcuts for auto-fitting a range of
columns?
Answer: 1) Select the columns by hitting Ctrl Spacebar. 2) Hold
down the shift key and use left and right arrow keys to highlight the
range of columns. 3) Hit Alt H O I to auto fit the columns.
◉ When you are in the Format Cells dialog (Ctrl 1):
What is the keyboard shortcut for moving across tabs (Number,
Alignment, Font Border, Fill, Protection)?
How do you move counter clockwise across form elements?
How do you select a checkbox (put a checkbox next to it)
Answer: 1) Ctrl Tab
2) Shift Tab
3) Spacebar
◉ alt w f f
Answer: freeze pane
TEST SHEET FULL SOLUTIONS CORRECT
ANSWERS PREPARATION SET
◉ Control + Space
Answer: highlight column
◉ Shift + Space
Answer: highlight row
◉ Command + B
Answer: bold
◉ Command + I
Answer: italicize
◉ Alt e s / control command v
Answer: paste special
◉ What is the keyboard shortcut to move sheets within a workbook?
Answer: Alt H O M
, ◉ What is the keyboard shortcut to open the formatting cells dialog
box?
Answer: Ctrl 1
◉ What are the keyboard shortcuts for auto-fitting a range of
columns?
Answer: 1) Select the columns by hitting Ctrl Spacebar. 2) Hold
down the shift key and use left and right arrow keys to highlight the
range of columns. 3) Hit Alt H O I to auto fit the columns.
◉ When you are in the Format Cells dialog (Ctrl 1):
What is the keyboard shortcut for moving across tabs (Number,
Alignment, Font Border, Fill, Protection)?
How do you move counter clockwise across form elements?
How do you select a checkbox (put a checkbox next to it)
Answer: 1) Ctrl Tab
2) Shift Tab
3) Spacebar
◉ alt w f f
Answer: freeze pane