=COUNT(C1:C2, C4:C5) का मान ज्ञात कीजिए जहां C1...C6 क्रमशः 1,A,3,4,B,6 हैं।
Find the value of =COUNT(C1:C2, C4:C5) where C1...C6 are respectively 1,A,3,4,B,6.
A)
B)
C)
D)
Explanation:
The COUNT function in LibreOffice Calc counts the number of numeric values in a given range.
For the formula =COUNT(C1:C2, C4:C5)
with the values C1 = 1, C2 = A, C4 = 3, C5 = 4:
- C1 = 1 is a number.
- C2 = A is not a number (it's a text).
- C4 = 3 is a number.
- C5 = 4 is a number.
So, the numeric values are 1, 3, and 4, giving us a total of 3 numeric values.
Therefore, the correct answer is:
(C) 3.