Case EX 13-1 Kim is a photographer. To supplement her income, she also teaches a basic photography class in her studio. She uses an Excel workbook to keep track of information related to her class. The columns in her worksheet are: Student Name, Address, Phone number, Fees, Fees Paid. To find out the number of students in her class based on the Student Name column, she can use the ____ function.

Question

Quizplus · Accepted Answer

The COUNTA function is used to count the number of non-empty cells in a range, which is suitable for counting the number of students based on the Student Name column.

Case EX 13-1 Kim Is a Photographer