Sumproduct - Study guides, Class notes & Summaries

CFI Assessment Exam 15 Questions with Verified Answers What combination of keys will autofill highlighted cells to the right? Review Later a) CTRL + R (PC and Mac) b) CTRL + D (PC and Mac) c) ALT + R (PC) / Alt + R (Mac) d) ATL + D (PC) / Alt + D (Mac) - CORRECT ANSWER a) CTRL + R (PC and Mac) What combination of keys turns the value in a cell into a percentage? a) CTRL + H (PC) / Command + H (Mac) b) ALT + H + P (PC) / Ctrl + Shift + % (Mac) c) ALT + M (PC) / Ctrl + M (Mac) d...

Excel Crash Course Exam 128 Questions with Verified Answers move back and forth between the worksheets in a workbook - CORRECT ANSWER *Ctrl PageUp* or *Ctrl PageDown* open a file - CORRECT ANSWER *alt f o* *ctrl o* save a file - CORRECT ANSWER *alt f s* *ctrl s* print a file - CORRECT ANSWER *alt f p* *ctrl p* navigating to the toolbars without the mouse - CORRECT ANSWER hit *Alt and the appropriate letter* (or use the right/left arrow keys) to get to the desired tab ...

SCM315 Exam Preparetion SUMPRODUCT(array 1, array 2, ...) - answeris a function of adding up the products of numbersat the same positions in multiple arrays SUMPRODUCT Condition: - answerInput arrays must have the same size and structure (orientation).SUMPRODUCT Function VLOOKUP(lookup_value, table_array, col_index_num, range_lookup): - answerreturn a value fromthe specified column (col_index_num) at the row of the matched identifier (lookup_value)in the selected table (table_array) look...

SCM315 Exam Preparetion SUMPRODUCT(array 1, array 2, ...) - answeris a function of adding up the products of numbersat the same positions in multiple arrays SUMPRODUCT Condition: - answerInput arrays must have the same size and structure (orientation).SUMPRODUCT Function VLOOKUP(lookup_value, table_array, col_index_num, range_lookup): - answerreturn a value fromthe specified column (col_index_num) at the row of the matched identifier (lookup_value)in the selected table (table_array) look...

worksheet names are only needed when... - ANSWER-referencing cells in diff worksheets 'Worksheet Name'! Cells $A2 locks... - ANSWER-the column this is mixed cell referencing A$2 locks... - ANSWER-the row this is mixed cell referencing $A$2 locks... - ANSWER-the column and row this is absolute referencing A2:C8 is... - ANSWER-a block range COUNT - ANSWER-determines the # of cells that contain NUMBERS for ROUND what are the numbers? - ANSWER--2 = nearest hundreds -...

changing cells - correct answer a set of designated cells for the decision variables. the values in these changing cells can be changed to optimize the objective Two-way data table - correct answer allows you to see how a single output varies as two inputs vary simultaneously How does solver use whole numbers? - correct answer if you want solver to ch...

Excel Crash Course Exam 36 Questions with Verified Answers All of the following are keyboard shortcut that allow the user input to add more sheets to a workbook EXCEPT: Alt i w Alt h i s Shift F11 Alt Shift F1 Alt h i w Incorrect - CORRECT ANSWER Alt i w, Alt h i s, Shift F11 and Alt Shift F1 are all keyboard shortcuts for adding more sheets to a workbook. Alt h i w is not a valid shortcut. What is a keyboard shortcut to open a file? Ctrl o Ctrl f Alt o Ctrl n - CORRECT ANSWER T...

Wall Street Prep Excel Crash Course Formulas Exam 64 Questions with Verified Answers =AVERAGE(number1,[number2],...) - CORRECT ANSWER Average Function =IF(logical test, [value if true], [value if false]) - CORRECT ANSWER Simple IF Function =IFS(logical test n, value if true n, value if false n) - CORRECT ANSWER IFS Function =IFERROR(value, value_if_error) - CORRECT ANSWER IFERROR Function =EOMONTH(start_date,months) - CORRECT ANSWER EOMONTH Function =EDATE(start date,months) - ...

The histogram below displays the distribution of 50 ages at death due to trauma (accidents and homicides) that were observed in a certain hospital during a week. Which of the following best describes the shape of the histogram? Right-skewed with a possible outlier Here are the number of hours that 9 students spend on the computer on a typical day: 4 5 5 5 8 8 10 12 13 What is the mode number of hours spent on the computer? 5 A recent survey asks 83 students, How many hou...

What combination of keys will autofill highlighted cells to the right? Review Later a) CTRL + R (PC and Mac) b) CTRL + D (PC and Mac) c) ALT + R (PC) / Alt + R (Mac) d) ATL + D (PC) / Alt + D (Mac) → ~~> a) CTRL + R (PC and Mac) What combination of keys turns the value in a cell into a percentage? a) CTRL + H (PC) / Command + H (Mac) b) ALT + H + P (PC) / Ctrl + Shift + % (Mac) c) ALT + M (PC) / Ctrl + M (Mac) d) ALT + P (PC) / Ctrl + P (Mac) → ~~> b) ALT + H + P (PC) / Ctr...