Excel Crash Course EXAM QUESTIONS AND VERIFIED
ANSWERS (2025) ALREADY GRADED A+
All of the following are keyboard shortcut that allow the user input to add more
sheets to a workbook EXCEPT: - ...(ANSWERS)....Alt h i w
What is a keyboard shortcut to open a file? - ...(ANSWERS)....Ctrl o
What is the recommended workbook calculation setting for Excel? -
...(ANSWERS)....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: - ...(ANSWERS)....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 - ...(ANSWERS)....exact column width
Alt h o w - ...(ANSWERS)....identical column widths
Alt h o h - ...(ANSWERS)....identical column height
Control + Space - ...(ANSWERS)....highlight column
, Shift + Space - ...(ANSWERS)....highlight row
Command + B - ...(ANSWERS)....bold
Command + I - ...(ANSWERS)....italicize
Alt e s / control command v - ...(ANSWERS)....paste special
What is the keyboard shortcut to move sheets within a workbook? -
...(ANSWERS)....Alt H O M
What is the keyboard shortcut to open the formatting cells dialog box? -
...(ANSWERS)....Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? -
...(ANSWERS)....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?
ANSWERS (2025) ALREADY GRADED A+
All of the following are keyboard shortcut that allow the user input to add more
sheets to a workbook EXCEPT: - ...(ANSWERS)....Alt h i w
What is a keyboard shortcut to open a file? - ...(ANSWERS)....Ctrl o
What is the recommended workbook calculation setting for Excel? -
...(ANSWERS)....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: - ...(ANSWERS)....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 - ...(ANSWERS)....exact column width
Alt h o w - ...(ANSWERS)....identical column widths
Alt h o h - ...(ANSWERS)....identical column height
Control + Space - ...(ANSWERS)....highlight column
, Shift + Space - ...(ANSWERS)....highlight row
Command + B - ...(ANSWERS)....bold
Command + I - ...(ANSWERS)....italicize
Alt e s / control command v - ...(ANSWERS)....paste special
What is the keyboard shortcut to move sheets within a workbook? -
...(ANSWERS)....Alt H O M
What is the keyboard shortcut to open the formatting cells dialog box? -
...(ANSWERS)....Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? -
...(ANSWERS)....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?
