\begin{tabular}{|c|c|c|c|c|c|}
\hline \multirow[t]{2}{*}{\[
\begin{array}{l}
\text { AME } \\
\text { SCHOOLNLLC }
\end{array}
\]} & \multicolumn{5}{|l|}{ACTIVIT SHEET FOR LEARMMO STRUDAO} \\
\hline & \multicolumn{5}{|l|}{-} \\
\hline LEVEL & \( \square \) Basto Lleray & date & & & \\
\hline Las title & Applying Arithmetio Fow Blementay & Oistrect & & & \\
\hline LEARNING & Spreadshoets Antic Formula and Functions in & - tanlor He & ytost & Desica Ho & it Sehod \\
\hline COMPETENCY & Employ the following sprenter & Len no. & 23 : & scone & \\
\hline
\end{tabular}
RETERNATIVE LEARNING SYSTEM REGION X- NORTHERN MINDANAO
ACTVITY SHEET FOR LEARNNO STRUNO E: DIGITNL CITRENSHIP
I. CONCEPT NOTES
COUNT - counts number of cells in a range that contains numbers. COUNTA - counts number of cells in a range that are not empty.
Example: Study the picture below and focus on column B. Let's count and counta the column B.
=COUNT(B:B)
\( = \) COUNTA \( (B: B) \)
The illustration shows that the count and counta focuses only on column B, which th unt is 7 and the counta is 8 .
EXERCISES
In the space provided, write TRUE if the statement is correct and FALSE if not.
\( \qquad \) 1. The COUNT in column \( B \) is 8 .
\( \qquad \) 2. The COUNTA in column \( B \) is 8 .
\( \qquad \) 3. The formula in finding the COUNT in column c is =COUNTA(C:C).
\( \qquad \) 4. The COUNT function counts number of cells with number.
5. The COUNTA function counts cell that are empty.