Spreadsheet Calculations | MCQs

Explanation

In Excel, the COUNT function is used to determine how many numeric entries are present in a range of cells.

COUNT Function:
The COUNT function counts the number of cells that contain numeric values within a specified range.

For example: =COUNT(A1:A10)
This formula will return the number of cells containing numbers in the range A1 through A10.

Explanation

An array formula is a formula that can perform multiple calculations on one or more of the items in an array.