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 spreadsheets. It begins with calculating total sales and sales tax, emphasizing the use of absolute and relative referencing. The tutorial then explores various functions such as SUM, AVERAGE, MIN, MAX, and COUNTA to perform different calculations. A detailed walkthrough is provided to ensure understanding, including updating values when the sales tax changes.

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

• Subtract discounts from the total

• Divide the total by the number of items

• Multiply the quantity by the price per item

• Add the sales tax to the total

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

• To allow the tax rate to change automatically

• To simplify the calculation process

• To ensure the formula copies correctly without changing the tax cell reference

• To make the formula more complex

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

• SUM

• MIN

• MAX

• AVERAGE

How do you calculate the minimum price per item using functions?

• Use the SUM function

• Use the MAX function

• Use the MIN function

• Use the AVERAGE function

What function is used to count the total number of customers?

• AVERAGE

• COUNT A

• SUM

• COUNT

What is the purpose of changing the sales tax from 4.5% to 6% in the exercise?

• To test a new tax rate

• To decrease the total sales

• To increase the total sales

• To verify that all formulas update correctly

What should you do if the formulas do not update after changing the sales tax?

• Ignore the issue

• Change the tax rate back to 4.5%

• Re-enter all the formulas

• Check for absolute referencing errors