Finance > EXAM > Excel Crash course: Wall Street Prep: Questions & Answers: Latest Updated (All)

Excel Crash course: Wall Street Prep: Questions & Answers: Latest Updated

Document Content and Description Below

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 What is a keyboard shortcut to open a file?` (Ans- Ctrl o What i ... s 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 What is the keyboard shortcut to open the formatting cells dialog box? (Ans- Ctrl 1 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. 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) (Ans- 1) Ctrl Tab 2) Shift Tab 3) Spacebar [Show More]

Last updated: 2 years ago

Preview 1 out of 6 pages

Buy Now

Instant download

We Accept: