Wall Street Prep: Excel Crash Course exam 2023|27 Questions and Answers| A Grade

Wall Street Prep: Excel Crash Course exam
2023|27 Questions and Answers| A Grade

All of the following are keyboard shortcut that allow the user input to add more sheets to
a workbook EXCEPT: - -Alt h i w


-What is a keyboard shortcut to open a file?` - -Ctrl o


-What is the recommended workbook calculation setting for Excel? - -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


-What is the keyboard shortcut to move sheets within a workbook? - -Alt H O M


-What is the keyboard shortcut to open the formatting cells dialog box? - -Ctrl 1


-What are the keyboard shortcuts for auto-fitting a range of columns? - -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?