Excel Crash Course Exam study guide
COMPLETE EXAM Questions and Answers
(Verified Answers) (Latest Update 2026)
UPDATE!!
Save
Terms in this set (80)
All of the following are keyboard Alt h i w
shortcut that allow the user input to
add more sheets to a workbook
EXCEPT:
What is a keyboard shortcut to Ctrl o
open a file?
What is the recommended Automatic except for Data Tables
workbook calculation setting for
Excel?
To add a cell reference from a 1. Hit F2 to get into the existing formula; delete
different worksheet into an existing any incorrect formulas or operators 2. Hit F2
formula with your keyboard, you again to enable "Enter" mode on the bottom-left
should follow the following steps: 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 exact column width
, Alt h o w identical column widths
Alt h o h identical column height
Control + Space highlight column
Shift + Space highlight row
Command + B bold
Command + I italicize
Alt e s / control command v paste special
What is the keyboard shortcut to Alt H O M
move sheets within a workbook?
What is the keyboard shortcut to Ctrl 1
open the formatting cells dialog
box?
What are the keyboard shortcuts 1) Select the columns by hitting Ctrl Spacebar. 2)
for auto-fitting a range of columns? 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.
COMPLETE EXAM Questions and Answers
(Verified Answers) (Latest Update 2026)
UPDATE!!
Save
Terms in this set (80)
All of the following are keyboard Alt h i w
shortcut that allow the user input to
add more sheets to a workbook
EXCEPT:
What is a keyboard shortcut to Ctrl o
open a file?
What is the recommended Automatic except for Data Tables
workbook calculation setting for
Excel?
To add a cell reference from a 1. Hit F2 to get into the existing formula; delete
different worksheet into an existing any incorrect formulas or operators 2. Hit F2
formula with your keyboard, you again to enable "Enter" mode on the bottom-left
should follow the following steps: 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 exact column width
, Alt h o w identical column widths
Alt h o h identical column height
Control + Space highlight column
Shift + Space highlight row
Command + B bold
Command + I italicize
Alt e s / control command v paste special
What is the keyboard shortcut to Alt H O M
move sheets within a workbook?
What is the keyboard shortcut to Ctrl 1
open the formatting cells dialog
box?
What are the keyboard shortcuts 1) Select the columns by hitting Ctrl Spacebar. 2)
for auto-fitting a range of columns? 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.
