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 and add "@" Categorizing variables in formulas -Answer-To assign a name to input into a formula with another variable (ex: Chicago, 200), you can highlight the columns you want categorized, hit formula tab, then create from selection Now, 200 should be categorized as Chicago in the little finders window in the top left corner of the workbook. Name Manager -Answer-You can delete, alter, replace range names with Name Manager Using ranges as calculating shortcuts -Answer-Making a range- just as categories with Create from Selection, you can use the following formula =AVERAGE(F3) F3 will then allow you to choose the range that you want to use, and calculate the average for that range. Ex: the average number of sales for Quarter 2 amongst all of the cities listed Source- Range Names INDEX -Answer-extracts an entry from a given row and column of a rectangular array of cells. The syntax of the INDEX function is =INDEX(array, r, c.). Then the INDEX function returns the entry in row r and column c of the given array. MATCH -Answer-If the lookup range is in a single column, the MATCH function finds the first occurrence of the lookup value and returns how many rows down the lookup value is in the lookup range. If the lookup range is in a single row, then the MATCH function finds the first occurrence of the lookup column and returns how many columns across the lookup value is in the lookup range. The last argument of 0 is needed because usually our lookup range will not have sorted values. MATCH and INDEX -Answer-you can use MATCH and INDEX together to find the values of a certain product in a certain month. For example, Pear Charlotte in the month of April produces a number in the data chart which symbolize these two things together. =ROUNDUP -Answer-This rounds numbers up to the nearest whole number =ROUNDDOWN does the opposite =VLOOKUP -Answer-formula to return our percentage penalty. We will show how either the INT function or ROUNDDOWN function can be used to solve this problem. =SUMPRODUCT -Answer-The SUMPRODUCT function multiplies the corresponding components of each cell range. If one cell range is a row with n cells, then the other cell range must also be a row with n cells =RAND -Answer-Returns a random number between 0 and 1 with the F9 key =RANDBETWEEN -Answer-Returns a random number between the numbers you specify =RANDBETWEEN(100,200) *Modeling uncertainty in excel Net Present Value (or NPV) -Answer-a technique used to estimate whether and when an initial capital investment will lead to future cash flows that exceed the cost of the capital