Match List-I with List-II
| List-I | List-II | ||
|---|---|---|---|
| (A) | It is the function which adds the cells as per given specified criteria | (I) | ROUND |
| (B) | It is the function to rounds a number to specified number of digits. | (II) | CONCATENATE |
| (C) | It is used to get the number of the entries in a number field (including date also) i.e. in a range or array of numbers. | (III) | SUMIF |
| (D) | This function joins two or more text strings into one text string | (IV) | COUNT |
Choose the correct answer from the options given below:
Answer & explanation
Correct answer: option 3
The correct answer is Option (3) → (A) - (III), (B) - (I), (C) - (IV), (D) - (II)
Each description in List-I is what one spreadsheet function does; the name of the function usually says it.
(A) It is the function which adds the cells as per given specified criteria — this matches (III) SUMIF. It adds only the cells that meet a condition, for example the depreciation of assets whose value is above a given figure.
(B) It is the function to rounds a number to specified number of digits. — this matches (I) ROUND. It takes a number and the number of digits to round it to.
(C) It is used to get the number of the entries in a number field (including date also) i.e. in a range or array of numbers. — this matches (IV) COUNT. It counts how many cells hold numbers or dates, ignoring text and empty cells.
(D) This function joins two or more text strings into one text string — this matches (II) CONCATENATE. For example, it joins first name, middle name and surname into a full name.
NCERT (2026-27 edition): NCERT (2026-27 edition): |