Question Bank - ICT

Here's the question bank on all the ICT topics.

How many cells are there in the cell range F4 : P10?

A.
66
B.
60
C.
70
D.
77

Solution:

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

For more questions,

Click Here

Download Gyanm App

free current affairs for competitive exams

Scan QR code to download our App for
more exam-oriented questions

free current affairs for competitive exams

OR
To get link to download app

Thank you! Your submission has been received. You will get the pdf soon. Call us if you have any question: 9117343434
Oops! Something went wrong while submitting the form.