Microsoft Excel 2021365 - Beginner to Advanced - Making Decisions with IF Statements

This video tutorial explores the use of logical functions in Excel, focusing on the IF function. It provides a detailed example of calculating shipping charges based on total cost using the IF formula. The tutorial guides viewers through constructing the formula, ensuring correct formatting, and completing the table with total cost and shipping calculations. It also introduces advanced concepts like nested IFs and other related formulas, encouraging further learning in an intermediate course.

What is the primary purpose of using the IF function in the given example?

• To calculate the total number of items sold

• To find the most popular product

• To calculate the total sales for 2019

• To determine if a shipping charge should be applied

In the IF formula, what does the logical test check for?

• If the total cost is exactly 1500

• If the total cost is equal to the item cost

• If the total cost is greater than 1500

• If the total cost is less than 1000

How is the cell reference locked in the formula to prevent it from moving?

• By using the F1 key

• By using the F3 key

• By using the F2 key

• By using the F4 key

What is the final step to complete the table in the example?

• Dividing the total cost by the number of items

• Subtracting the shipping from the total cost

• Multiplying the total cost by the number of items

• Adding the total cost and shipping to get the grand total

Which of the following is NOT mentioned as an intermediate formula?

• AVERAGEIF

• SUMIF

• IFS

• COUNTIF