EXCEL CRASH COURSE EXAM 2026
CERTIFICATION EVALUATION TEST PAPER
QUESTIONS SOLUTIONS GRADED A PLUS
◉ 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
◉ 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
◉ If I want to add the title "Company Financials" in cell A1 ensure
that all columns are the same width across all the worksheets in my
workbook, how would I do that?
Answer: 1. Group the wroksheets by hitting Ctrl Shift and use the
PageUp/Down keys to select the worksheets. 2. In the active sheet
type in "Company Financials" in A1 and apply the desired width to
CERTIFICATION EVALUATION TEST PAPER
QUESTIONS SOLUTIONS GRADED A PLUS
◉ 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
◉ 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
◉ If I want to add the title "Company Financials" in cell A1 ensure
that all columns are the same width across all the worksheets in my
workbook, how would I do that?
Answer: 1. Group the wroksheets by hitting Ctrl Shift and use the
PageUp/Down keys to select the worksheets. 2. In the active sheet
type in "Company Financials" in A1 and apply the desired width to
