Wall Street Prep |8 Questions| With Correct Answers.

What is the keyboard shortcut to move sheets within a workbook? {Ans: Alt H O M}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}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}What is a keyboard shortcut to open a file? {Ans: Ctrl o}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 is the recommended workbook calculation setting for Excel {Ans: Automatic except for Data Tables}What is the keyboard shortcut to open