Excel Crash Course Exam Questions and
Answers | Latest Test Bank with Verified
Solutions | A+ Pass Guaranteed
What is a keyboard shortcut to open a file? -✓✓Ctrl o
What is the recommended workbook calculation setting for Excel? -✓✓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: -✓✓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 -✓✓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 move sheets within a workbook? -✓✓Alt H O M
What is the keyboard shortcut to open the formatting cells dialog box? -✓✓Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? -✓✓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) -✓✓1) Ctrl Tab
2) Shift Tab
3) Spacebar
alt w f f -✓✓freeze pane
alt w s -✓✓split pane
F6 -✓✓jump between panes
Alt H E A -✓✓delete everything about a cell
Control Shift + -✓✓insert new row
Control Shift ! -✓✓number format; 2 decimals
Control Shift $ -✓✓currency format; 2 decimals
Control Shift % -✓✓percentage format with no decimal points
Control Shift _ -✓✓remove all borders
Alt H I S -✓✓new worksheet
Alt e l -✓✓delete worksheet
Alt h o r -✓✓rename worksheet
To Group Columns -✓✓1. Ctrl Space to select desired columns
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the columns
4. Alt A J will unhide the columns
5. Shift Alt Left Arrow Key to remove group
To Group Rows -✓✓1. Shift Space to select desired rows
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the rows
4. Alt A J will unhide the rows
5. Shift Alt Left Arrow Key to remove group
Ctrl [ or Ctrl ] -✓✓formula audit
Answers | Latest Test Bank with Verified
Solutions | A+ Pass Guaranteed
What is a keyboard shortcut to open a file? -✓✓Ctrl o
What is the recommended workbook calculation setting for Excel? -✓✓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: -✓✓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 -✓✓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 move sheets within a workbook? -✓✓Alt H O M
What is the keyboard shortcut to open the formatting cells dialog box? -✓✓Ctrl 1
What are the keyboard shortcuts for auto-fitting a range of columns? -✓✓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) -✓✓1) Ctrl Tab
2) Shift Tab
3) Spacebar
alt w f f -✓✓freeze pane
alt w s -✓✓split pane
F6 -✓✓jump between panes
Alt H E A -✓✓delete everything about a cell
Control Shift + -✓✓insert new row
Control Shift ! -✓✓number format; 2 decimals
Control Shift $ -✓✓currency format; 2 decimals
Control Shift % -✓✓percentage format with no decimal points
Control Shift _ -✓✓remove all borders
Alt H I S -✓✓new worksheet
Alt e l -✓✓delete worksheet
Alt h o r -✓✓rename worksheet
To Group Columns -✓✓1. Ctrl Space to select desired columns
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the columns
4. Alt A J will unhide the columns
5. Shift Alt Left Arrow Key to remove group
To Group Rows -✓✓1. Shift Space to select desired rows
2. Shift Alt Right Arrow Key to create the group
3. Alt A H to hide the rows
4. Alt A J will unhide the rows
5. Shift Alt Left Arrow Key to remove group
Ctrl [ or Ctrl ] -✓✓formula audit
