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 Wayground
13 questions
Break-even Y11

Quiz
•
8th - 11th Grade
10 questions
Warm Up: Basic Spreadsheet Functions and Formulas Assessment

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

Quiz
•
8th Grade
15 questions
OFFICE STATIONERY

Quiz
•
8th Grade
14 questions
S1 Spreadsheets Functions/Formulae

Quiz
•
7th - 11th Grade
10 questions
Excel 2019 Formulas and Functions

Quiz
•
8th - 12th Grade
10 questions
Receipts (Basic)

Quiz
•
8th Grade
10 questions
DIAMOND DASH (POWERPRENEUR VIRTUAL)

Quiz
•
2nd Grade - Professio...
Popular Resources on Wayground
25 questions
Equations of Circles

Quiz
•
10th - 11th Grade
30 questions
Week 5 Memory Builder 1 (Multiplication and Division Facts)

Quiz
•
9th Grade
33 questions
Unit 3 Summative - Summer School: Immune System

Quiz
•
10th Grade
10 questions
Writing and Identifying Ratios Practice

Quiz
•
5th - 6th Grade
36 questions
Prime and Composite Numbers

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

Quiz
•
8th Grade
37 questions
Camp Re-cap Week 1 (no regression)

Quiz
•
9th - 12th Grade
46 questions
Biology Semester 1 Review

Quiz
•
10th Grade