Spreadsheet Skills Warm-Up: Formulas, Functions & Totals

Spreadsheet Skills Warm-Up: Formulas, Functions & Totals

8th Grade

12 Qs

quiz-placeholder

Similar activities

Excel Module 5

Excel Module 5

8th Grade

11 Qs

MOS Word Test Prep Pt. 1

MOS Word Test Prep Pt. 1

8th - 12th Grade

10 Qs

Spreadsheets

Spreadsheets

8th Grade

8 Qs

BTEC L2 U2 - Profit and Loss

BTEC L2 U2 - Profit and Loss

8th Grade

15 Qs

Spreadsheet Terms

Spreadsheet Terms

1st - 8th Grade

15 Qs

EQL409 Fundamental analysis 3

EQL409 Fundamental analysis 3

8th - 12th Grade

10 Qs

Short-run and Long-run: Theory of Production I

Short-run and Long-run: Theory of Production I

7th Grade - University

16 Qs

Formulas and Functions:  Sheets

Formulas and Functions: Sheets

8th Grade

10 Qs

Spreadsheet Skills Warm-Up: Formulas, Functions & Totals

Spreadsheet Skills Warm-Up: Formulas, Functions & Totals

Assessment

Quiz

Business

8th Grade

Medium

Created by

MOIRA HOWEE

Used 5+ times

FREE Resource

12 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

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

=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

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?