EXCEL CRASH COURSE EXAM 2026 FINAL
REVIEW QUESTIONS ANSWERS BUNDLED
PRACTICE COLLECTION
◉ What is a keyboard shortcut to open a file?
Answer: Ctrl o
◉ What is the recommended workbook calculation setting for Excel?
Answer: Automatic except for Data Tables
◉ To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following steps:
Answer: 1. Hit F2 to get into the existing formula; delete any
incorrect formulas or operators 2. Hit F2 again to enable "Enter"
mode on the bottom-left corner of the Excel sheet 3. Holding down
Ctrl, use PageUp or PageDown to find the desired worksheet 4. Let
go of the Ctrl and PageUp/Down keys 5. Use the arrow keys to locate
the desired cell reference 6. Hit Enter
◉ Alt h o i
Answer: exact column width
◉ Alt h o w
, Answer: identical column widths
◉ Alt h o h
Answer: identical column height
◉ 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
REVIEW QUESTIONS ANSWERS BUNDLED
PRACTICE COLLECTION
◉ What is a keyboard shortcut to open a file?
Answer: Ctrl o
◉ What is the recommended workbook calculation setting for Excel?
Answer: Automatic except for Data Tables
◉ To add a cell reference from a different worksheet into an existing
formula with your keyboard, you should follow the following steps:
Answer: 1. Hit F2 to get into the existing formula; delete any
incorrect formulas or operators 2. Hit F2 again to enable "Enter"
mode on the bottom-left corner of the Excel sheet 3. Holding down
Ctrl, use PageUp or PageDown to find the desired worksheet 4. Let
go of the Ctrl and PageUp/Down keys 5. Use the arrow keys to locate
the desired cell reference 6. Hit Enter
◉ Alt h o i
Answer: exact column width
◉ Alt h o w
, Answer: identical column widths
◉ Alt h o h
Answer: identical column height
◉ 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