The term array is closest in meaning in excel to: spreadsheet standard deviation sumproduct cell range
Answers
Answered by
1
VBA code: display the address of active cell in a specified cell Private Sub Worksheet_SelectionChange(ByVal Target As Range) Range("A1").
Answered by
0
The term array is closest in meaning in excel to: spreadsheet standard deviation sumproduct cell range is True statement.
Explanation:
- An 'Excel array formula' can execute multiple functions and replace thousands of regular formulas.
- An array formula handles a variety of values instead of just one. In other words, the Excel array formula checks all the individual values in the array and performs several calculations on one or more objects as per the conditions specified in the formula.
- The 'SUMPRODUCT' function multiplies corresponding items in the given 'array' set and gives the sum of those products.
To know more
How to split an array to different cell array with respect to specific condition
https://brainly.in/question/10426370
Formula for minimum in excel
https://brainly.in/question/10067253
Similar questions