EXCEL CRASH COURSE EXAM 259 ACTUAL
TEST PAPER 2026 QUESTIONS WITH
SOLUTIONS GRADED A+
◉ 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
◉ 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.
TEST PAPER 2026 QUESTIONS WITH
SOLUTIONS GRADED A+
◉ 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
◉ 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.
