Excel Crash course: Wall Street Prep
Questions & Answers
, more sheets to a workbook EXCEPT:
(Ans- Alt h i w
What is a keyboard shortcut to open a file?` (Ans-
Ctrl o
What is the recommended workbook calculation setting for Excel?
(Ans- 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:
(Ans-
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
What is the keyboard shortcut to move sheets within a workbook?
(Ans- Alt H O M
Questions & Answers
, more sheets to a workbook EXCEPT:
(Ans- Alt h i w
What is a keyboard shortcut to open a file?` (Ans-
Ctrl o
What is the recommended workbook calculation setting for Excel?
(Ans- 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:
(Ans-
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
What is the keyboard shortcut to move sheets within a workbook?
(Ans- Alt H O M
