Harvard Spreadsheet Modeling Practice Exam Questions and Answers 100% Pass

Harvard Spreadsheet Modeling Practice Exam Questions and Answers 100% Pass Ctrl-Home -Answer-Selects cell A1 Ctrl-End -Answer-Selects the cell at the intersection of the last-used column and last- used row on the worksheet Page Up -Answer-Scrolls up one screen Page Down -Answer-Scrolls down one screen Alt-Page Up -Answer-Scrolls left one screen Alt-Page Down -Answer-Scrolls right one screen Ctrl-Page Up -Answer-Selects the previous worksheet Ctrl-Page Down -Answer-Selects the next worksheet Ctrl-Tab -Answer-Moves to the next open Excel workbook ALT key on a mac -Answer-Option key Ctrl-Home on mac -Answer-CONTROL + FN + LEFT ARROW Ctrl-END on mac -Answer-CONTROL + FN + RIGHT ARROW control c -Answer-copy control v -Answer-paste control A -Answer-select all F8 -Answer-Extend a selection, works like Select All SHIFT down -Answer-selecting a range of cells control shift asterisk -Answer-selects all data in the sheet F5 Mac is control + G -Answer-Goes to a dialogue box This feature allows you to shade the boxes which could contain blank cells Reduces human error Selection with centering text -Answer-You can center the text across multiple columns by: Writing text Format Cells Center Across Selection what does each formula start with in excel? -Answer-= $ sign before a letter -Answer-$ sign before the number in a cell reference ensures that when we copy the formula, the column reference remains unchanged Flash fill -Answer-Flash fill allows excel to find patterns. For example, in a list of full length names, the computer will recognize that you only want the last name after entering the last names of the first two people in the list. It will also work if you want to make an email list and take the last name of the person