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 is the primary purpose of using nested IFs or the IFS function in this exercise?

• To determine the prize money based on medal type

• To sort the athletes by their country

• To calculate the total number of athletes

• To find the average score of athletes

Which medal type corresponds to a prize of $250 using the IFS function?

• None

• Silver

• Bronze

• Gold

What function would you use to count the number of athletes from a specific country?

• IFS

• AVERAGEIF

• COUNTIF

• SUMIF

How many criteria are used in the COUNTIFS function to find female athletes from Australia?

• Four

• One

• Two

• Three

Which function is used to calculate the total prize money for athletes from the USA?

• IFS

• SUMIF

• AVERAGEIF

• COUNTIF

What is the key difference between SUMIF and SUMIFS functions?

• SUMIF can handle multiple criteria, SUMIFS cannot

• SUMIF is used for counting, SUMIFS is for summing

• SUMIFS can handle multiple criteria, SUMIF cannot

• SUMIF is faster than SUMIFS

How can you calculate the total prize money for both USA and Canada using SUMIF?

• Use a single SUMIF with both criteria

• Perform two separate SUMIF calculations and add them

• Use COUNTIF instead

• It is not possible with SUMIF