Question

1.DETERMINE OTHER INSTANCES WHERE YOU CAN USE THE COUNTIF,SUMIF,AND AVERAGEIF FUNCTIONS. 2.HOW DOES EXCEL INTERPRET DATA?

Answer 1

1. We can use COUNTIF, SUMIF, AVERAGEIF if we only need to perform operations within filled cells/empty cells.

2. Excel interprets data in the form of matrix (a database consisting of rows and columns).