Target Exam

CUET

Subject

-- Accountancy Part C

Chapter

Spreadsheet

Question:

................. 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.

Options:

Array

Count

Round

None of these

Correct Answer:

Array

Explanation:

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.