What formula would you use to calculate total profit for an ingredient?

Spreadsheet Skills Warm-Up: Formulas, Functions & Totals

Quiz
•
Business
•
8th Grade
•
Medium
MOIRA HOWEE
Used 5+ times
FREE Resource
12 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
=Quantity + Price
=Price - Quantity
=Quantity * Price
=SUM(Quantity, Price)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which function would give you the smallest number in a group of cells?
A. MAX
B. MIN
C. LOW
D. SMALLER
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which Excel function gives you the largest number in a list?
=BIG()
=LARGE()
=MAX()
=TOP()
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct formula to total values in cells B2 through B6?
=TOTAL(B2:B6)
=ADD(B2:B6)
=SUM(B2:B6)
=B2 + B6
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
You want to find the ingredient with the most units sold. Which formula would help?
=MIN(range)
=MAX(range)
=AVERAGE(range)
=COUNT(range)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula would calculate total revenue if Quantity is in D2 and Price in E2?
=D2 * E2
=SUM(D2 + E2)
=E2 / D2
=D2 + E2
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
If the daily quantities sold are in cells C2 to C6, which formula gives the total?
=TOTAL(C2,C6)
=SUM(C2:C6)
=C2 + C6
=ADD(C2:C6)
Create a free account and access millions of resources
Similar Resources on Quizizz
8 questions
Savings

Quiz
•
8th Grade
14 questions
Excel Module 3 Vocabulary

Quiz
•
8th - 12th Grade
15 questions
HASS YR8 SM2 QUIZ

Quiz
•
6th - 8th Grade
10 questions
CLASE 17 COSTOS Y PRESUPUESTOS

Quiz
•
1st - 11th Grade
16 questions
Costs and Revenue

Quiz
•
6th - 10th Grade
10 questions
Profit and Loss Quiz

Quiz
•
8th Grade
15 questions
BTEC L2 U2 - Profit and Loss

Quiz
•
8th Grade
16 questions
Short-run and Long-run: Theory of Production I

Quiz
•
7th Grade - University
Popular Resources on Quizizz
15 questions
Multiplication Facts

Quiz
•
4th Grade
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
40 questions
Week 4 Student In Class Practice Set

Quiz
•
9th - 12th Grade
40 questions
SOL: ILE DNA Tech, Gen, Evol 2025

Quiz
•
9th - 12th Grade
20 questions
NC Universities (R2H)

Quiz
•
9th - 12th Grade
15 questions
June Review Quiz

Quiz
•
Professional Development
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
25 questions
Triangle Inequalities

Quiz
•
10th - 12th Grade
Discover more resources for Business
25 questions
SS Combined Advisory Quiz

Quiz
•
6th - 8th Grade
20 questions
Congruent and Similar Triangles

Quiz
•
8th Grade
14 questions
Exterior and Interior angles of Polygons

Quiz
•
8th Grade
6 questions
Earth's energy budget and the greenhouse effect

Lesson
•
6th - 8th Grade
15 questions
SMART Goals

Quiz
•
8th - 12th Grade
20 questions
Lesson: Slope and Y-intercept from a graph

Quiz
•
8th Grade