EXCEL CRASH COURSE EXAM | COMPLETE QUESTIONS WITH
EXPERT SOLUTIONS | 2026 LATEST UPDATED | GET A+
All of the following are keyboard shortcut that allow the user input to add more sheets to a
workbook EXCEPT: - (answer)Alt h i w
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.
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
alt w s - (answer)split pane
F6 - (answer)jump between panes
Alt H E A - (answer)delete everything about a cell
EXPERT SOLUTIONS | 2026 LATEST UPDATED | GET A+
All of the following are keyboard shortcut that allow the user input to add more sheets to a
workbook EXCEPT: - (answer)Alt h i w
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.
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
alt w s - (answer)split pane
F6 - (answer)jump between panes
Alt H E A - (answer)delete everything about a cell
