Excel Crash Course Exam Questions and
Answers Verified Solutions Latest
Update
Question:
What is a keyboard shortcut to open a file?
Answer:
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
Question:
Shift Tab
Answers Verified Solutions Latest
Update
Question:
What is a keyboard shortcut to open a file?
Answer:
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
Question:
Shift Tab
