Question

Which MS-Excel function finds the number of data present in the selected cells?
2. Predict the result of the following
a) INSTR(“KOLKATA” , “TA”)
b) FIX(-7.9)
c) LEN(“TAMIL NADU”)
d) SGN(-9)
e) MID$(“FOOTBALL”,5,4)

Answer 1

Answer:

1)Use AutoSum by selecting a range of cells that contains at least one numeric value. Then on the Formulas tab, click AutoSum > Count Numbers.

Explanation:

SORRY, I DONT KNOW THE SECOND ANSWER

PLS THANK SISTER/BROTHER