Wall Street Prep - Excel

Wall Street Prep - Excel All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: Alt i w Alt h i s Shift F11 Alt Shift F1 Alt h i w - ANSWER-Alt h i w What is a keyboard shortcut to open a file? Ctrl o Ctrl f Alt o Ctrl n - ANSWER-Ctrl o What is the recommended workbook calculation setting for Excel? Automatic Manual Automatic except for Data Tables Iterate - 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 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 Alt, 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 Escape - ANSWER-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? Alt F W V Alt H O M Alt D T Alt A W T - ANSWER-Alt H O M What is the keyboard shortcut to open the formatting cells dialog box? Ctrl 1