Here's the question bank on all the ICT topics.
How many cells are there in the cell range F4 : P10?
The correct answer is 77. Important Points COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for example, to count the number of times a particular city appears in a customer list. For example, =COUNTIF(A2:A5,"apples")Counts the number of cells with apples in cells A2 through A5. The result is 2. Ways to count the cells in cell range:1. Select the cell where you want the result to appear. 2. On the Formulas tab, click More Functions, point to Statistical, and then click one of the following functions:COUNTA: To count cells that are not emptyCOUNT: To count cells that contain numbers. COUNTBLANK: To count cells that are blank. COUNTIF: To count cells that meet specified criteria. In the above example, the cells have to be counted between a certain range. Hence, we should use the formula of COUNTIF. Hence, the correct answer is 77. Alternate Method Column F to Column P = 11 CellsRow 4 to row 10 = 7 cellsTotal no of cells = 7*11 = 77
Scan QR code to download our App for
more exam-oriented questions
OR
To get link to download app