................. is used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns.
Answer & explanation
Correct answer: option 1
The correct answer is option 1- Array.
Array is used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns.
Array is Used to build single formulas that produce multiple results or that operate on a group of arguments that are arranged in rows and columns. An array range shares a common formula; an array constant is a group of constants used as an argument.
Array formula- A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.
OTHER OPTIONS
- COUNT function counts the number of cells that contain numbers and counts numbers within the list of arguments. COUNT is use to get the number of the entries in a number field (including date also) i.e. in a range or array of numbers.
- ROUND is the function to rounds a number to specified number of digits.