EXCEL CRASH COURSE EXAM FROM WALL STREET PREP - WALL STREET PREP QUESTIONS AND ANSWERS UPDATED 2025 | ASSURED SUCCESS

EXCEL CRASH COURSE EXAM FROM WALL STREET PREP - WALL STREET PREP QUESTIONS AND ANSWERS UPDATED 2025 | ASSURED SUCCESS What are the keyboard shortcuts for auto-fitting a range of columns? - ANSWER- 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) - ANSWER-1) Ctrl Tab 2) Shift Tab 3) Spacebar alt w f f - ANSWER-freeze pane alt w s - ANSWER-split pane F6 - ANSWER-jump between panes Alt H E A - ANSWER-delete everything about a cell Control Shift + - ANSWER-insert new row 2 | Page Control Shift ! - ANSWER-number format; 2 decimals Control Shift $ - ANSWER-currency format; 2 decimals Control Shift % - ANSWER-percentage format with no decimal points Control Shift _ - ANSWER-remove all borders Alt H I S - ANSWER-new worksheet Alt e l - ANSWER-delete worksheet Alt h o r - ANSWER-rename worksheet To Group Columns - ANSWER-1. Ctrl Space to select desired columns 2. Shift Alt Right Arrow Key to create the group 3. Alt A H to hide the columns 4. Alt A J will unhide the columns 5. Shift Alt Left Arrow Key to remove group To Group Rows - ANSWER-1. Shift Space to select desired rows 2. Shift Alt Right Arrow Key to create the group 3. Alt A H to hide the rows 4. Alt A J will unhide the rows 5. Shift Alt Left Arrow Key to remove group 3 | Page All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: - ANSWER-Alt h i w What is a keyboard shortcut to open a file? - ANSWER-Ctrl o What is the recommended workbook calculation setting for Excel? - 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: - 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 Alt h o i - ANSWER-exact column width Alt h o w - ANSWER-identical column widths Alt h o h - ANSWER-identical column height Control + Space - ANSWER-highlight column Shift + Space - ANSWER-highlight row Command + B - ANSWER-bold