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.

What is the first step in calculating total sales for all customers?

• Multiply quantity by price per item.

• Use the MAX function.

• Calculate the total sales tax.

• Add the sales tax to the total.

When calculating sales tax, why is it important to consider absolute referencing?

• To avoid using the sales tax figure.

• To ensure the sales tax figure remains constant when copying the formula.

• To allow the sales tax figure to change with each row.

• To make the formula more complex.

Which function would you use to find the average quantity of items bought by each customer?

• SUM

• MIN

• AVERAGE

• MAX

What function is used to determine the minimum price per item?

• MIN

• AVERAGE

• MAX

• SUM

How do you calculate the total number of customers using functions?

• Use the COUNTA function.

• Use the AVERAGE function.

• Use the MAX function.

• Use the SUM function.

What should you do to ensure all figures update when the sales tax changes?

• Ignore the change in sales tax.

• Delete all data and start over.

• Change the sales tax percentage and check if values update.

• Re-enter all formulas manually.

Which function is used to calculate the total sales excluding tax?

• MAX

• SUM

• AVERAGE

• MIN