Microsoft Excel 2021365 - Beginner to Advanced - Exercise 03 - work with formulas and use functions in calculations

This video tutorial covers working with formulas and functions in Excel. It begins with calculating total sales and sales tax, emphasizing the importance of absolute and relative referencing. The tutorial then explores using functions like SUM, AVERAGE, MIN, and MAX to perform various calculations. A detailed walkthrough demonstrates how to apply these calculations and ensure formulas update correctly when data changes.

In cell I4, what calculation do you need to perform to find the total sales?

What function do you use to calculate the average quantity of items bought by each customer?

How do you ensure that the sales tax amount updates correctly when changed?