EXCEL CRASH COURSE EXAM CERTIFICATION EVALUATION TESTED QUESTIONS FULL
SOLUTION GUIDE
Question:
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: -✓✓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
Question:
2) Shift Tab
Answer:
Question:
3) Spacebar alt w f f
Answer:
, 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
Question:
2. Shift Alt Right Arrow Key to create the group
Answer:
Question:
3. Alt A H to hide the columns
Answer:
Question:
4. Alt A J will unhide the columns
Answer:
Question:
5. Shift Alt Left Arrow Key to remove group To Group Rows
Answer:
1. Shift Space to select desired rows
Question:
SOLUTION GUIDE
Question:
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: -✓✓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
Question:
2) Shift Tab
Answer:
Question:
3) Spacebar alt w f f
Answer:
, 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
Question:
2. Shift Alt Right Arrow Key to create the group
Answer:
Question:
3. Alt A H to hide the columns
Answer:
Question:
4. Alt A J will unhide the columns
Answer:
Question:
5. Shift Alt Left Arrow Key to remove group To Group Rows
Answer:
1. Shift Space to select desired rows
Question:
