Ravi Sir's Cards › Excel
Tuition Centre Management System in Excel (card 2 of 2)
Revision card 2 for Tuition Centre Management System in Excel: Test %: =E5/F5 gives 88.0%; Average test %: =AVERAGEIFS(Tests!$G$5:$G$500,Tests!$C$5:$C$500,A5) gives 89.3%; Rank by average: =RANK(K5,$K$5:$K$16) gives 2. Includes an example data table.
Read card text
What this card says
2 for Tuition Centre Management System in Excel: Test %: =E5/F5 gives 88.0%
Average test %: =AVERAGEIFS(Tests!$G$5:$G$500,Tests!$C$5:$C$500,A5) gives 89.3%
Rank by average: =RANK(K5,$K$5:$K$16) gives 2. Includes an
Example
data table
Learn this in the lesson: Tuition Centre Management System in Excel: Groups, Monthly Fees, Test Marks, Progress Card and Dashboard