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

Interactive Video
•
Information Technology (IT), Architecture, Business
•
University
•
Hard
Quizizz Content
FREE Resource
Read more
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would you use to find the average quantity of items bought by each customer?
SUM
MIN
AVERAGE
MAX
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function is used to determine the minimum price per item?
MIN
AVERAGE
MAX
SUM
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
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.
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function is used to calculate the total sales excluding tax?
MAX
SUM
AVERAGE
MIN
Similar Resources on Wayground
8 questions
Microsoft Excel 2021365 - Beginner to Advanced - Using LARGE and SMALL

Interactive video
•
University
2 questions
Microsoft Excel 2021365 - Beginner to Advanced - Using LARGE and SMALL

Interactive video
•
University
8 questions
Microsoft Excel 2021365 - Beginner to Advanced - The INDIRECT Function

Interactive video
•
University
6 questions
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 08 - copy-paste data in the blank worksheet

Interactive video
•
University
6 questions
UK Economy: Inflation Slows, Boosting Rate Cut Hopes

Interactive video
•
University
8 questions
Microsoft Excel 2021365 - Beginner to Advanced - Exercise 04 - AVERAGE, MEDIAN, and MODE.

Interactive video
•
University
2 questions
Microsoft Excel 2021365 - Beginner to Advanced - Using Named Ranges in Calculations

Interactive video
•
University
6 questions
Why Amazon Shoppers Might Pay More Sales Tax This Year

Interactive video
•
University
Popular Resources on Wayground
11 questions
Hallway & Bathroom Expectations

Quiz
•
6th - 8th Grade
20 questions
PBIS-HGMS

Quiz
•
6th - 8th Grade
10 questions
"LAST STOP ON MARKET STREET" Vocabulary Quiz

Quiz
•
3rd Grade
19 questions
Fractions to Decimals and Decimals to Fractions

Quiz
•
6th Grade
16 questions
Logic and Venn Diagrams

Quiz
•
12th Grade
15 questions
Compare and Order Decimals

Quiz
•
4th - 5th Grade
20 questions
Simplifying Fractions

Quiz
•
6th Grade
20 questions
Multiplication facts 1-12

Quiz
•
2nd - 3rd Grade