CAT G11 Excel - Extra activity

What function would we use to calculate the total amount paid by Grade 10 learners? 

Type out the full function in the space provided, with the relevant cells included. 

What function would we use to determine how many learners are male? 

Type out the full function in the space provided, with the relevant cells included. 

What function would we use to calculate the least amount paid? 

Type out the full function in the space provided, with the relevant cells included. 

What function would we use to calculate the third-lowest amount paid? 

Type out the full function in the space provided, with the relevant cells included. 

What function would we use to assign a random number between 10 and 40 to the learners? 

Type out the full function in the space provided, with the relevant cells included. 

Provide a function that will give the answer for what is demonstrated in the image.