Question

The contents of cell A1, A2, A3, and A4 in a Spreadsheet application are 10, 15, 20, 25 respectively. If the formula =COUNT(A1:A4) is entered in cell A5, _______ value will be displayed in A5.

a. 70

b. 4

c. 45

d. 65

Answer 1

Correct option is (c) 45

The contents of cell A1, A2, A3, and A4 in a Spreadsheet application are 10, 15, 20, 25 respectively. If the formula =COUNT(A1:A4) is entered in cell A5, 45 value will be displayed in A5.