Microsoft Excel 2021365 - Beginner to Advanced - Exercise 01 - apply logical functions

This video tutorial covers logical functions, focusing on nested Ifs and the IFS function to calculate prize money. It also explores COUNTIF and SUMIF functions to analyze data based on various criteria. The tutorial provides step-by-step solutions for exercises, demonstrating how to lock cell references and use multiple criteria in formulas.

What are the criteria used to count female athletes from Australia?

What is the final step to sum the prize money for Canadian female athletes?

How do you calculate the total prize money for athletes from North America?