wall street prep
All of the following are keyboard shortcut that allow the user input to add more
sheets to a workbook EXCEPT: - ANS - Alt h i w
\To add a cell reference from a different worksheet into an existing formula with
your keyboard , you should follow the following steps: - ANS - 1. Hit F2 to get into
the existing formula 2. Holding down Ctrl, use PageUp or PageDown to find the
desired worksheet 3. Let go of the Ctrl and PageUp/Down keys 4. Use the arrow
keys to locate the desired cell reference 5. Hit enter
\What are the keyboard shortcuts for auto-fitting a range of columns? - ANS - 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
\What is a keyboard shortcut to open a file? - ANS - Ctrl o
\What is the keyboard shortcut to move sheets within a workbook? - ANS - Alt H
OM
\What is the keyboard shortcut to open the formatting cells dialog box? - ANS -
ctrl 1
\What is the recommended workbook calculation setting for Excel - ANS -
Automatic except for Data Tables
\When you are in the Format Cells dialog (Ctrl 1):
1) What is the keyboard shortcut for moving across tabs (Number, Alignment,
Font Border, Fill, Protection)?
2)How do you move counter clockwise across form elements?
3)How do you select a checkbox (put a checkbox next to it) - ANS - 1) Ctrl Tab, 2)
Shift Tab 3) Spacebar
\
All of the following are keyboard shortcut that allow the user input to add more
sheets to a workbook EXCEPT: - ANS - Alt h i w
\To add a cell reference from a different worksheet into an existing formula with
your keyboard , you should follow the following steps: - ANS - 1. Hit F2 to get into
the existing formula 2. Holding down Ctrl, use PageUp or PageDown to find the
desired worksheet 3. Let go of the Ctrl and PageUp/Down keys 4. Use the arrow
keys to locate the desired cell reference 5. Hit enter
\What are the keyboard shortcuts for auto-fitting a range of columns? - ANS - 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
\What is a keyboard shortcut to open a file? - ANS - Ctrl o
\What is the keyboard shortcut to move sheets within a workbook? - ANS - Alt H
OM
\What is the keyboard shortcut to open the formatting cells dialog box? - ANS -
ctrl 1
\What is the recommended workbook calculation setting for Excel - ANS -
Automatic except for Data Tables
\When you are in the Format Cells dialog (Ctrl 1):
1) What is the keyboard shortcut for moving across tabs (Number, Alignment,
Font Border, Fill, Protection)?
2)How do you move counter clockwise across form elements?
3)How do you select a checkbox (put a checkbox next to it) - ANS - 1) Ctrl Tab, 2)
Shift Tab 3) Spacebar
\
