Writing Formulas in Excel

Writing Formulas in Excel

7th - 9th Grade

5 Qs

quiz-placeholder

Similar activities

พีทาโกรัส

พีทาโกรัส

1st - 9th Grade

10 Qs

Sports Math

Sports Math

7th - 8th Grade

10 Qs

menentukan fungsi kuadrat

menentukan fungsi kuadrat

9th Grade

10 Qs

7 ICT Sem 2 Reviewer

7 ICT Sem 2 Reviewer

7th Grade

10 Qs

Rational Exponents and Complex Numbers

Rational Exponents and Complex Numbers

8th Grade

10 Qs

Technology Week HTG Quiz - Monday

Technology Week HTG Quiz - Monday

7th - 12th Grade

10 Qs

Thinglink

Thinglink

9th - 12th Grade

10 Qs

Arwynebedd arwyneb silindr

Arwynebedd arwyneb silindr

7th Grade

10 Qs

Writing Formulas in Excel

Writing Formulas in Excel

Assessment

Quiz

Computers, Mathematics

7th - 9th Grade

Practice Problem

Hard

Used 45+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

5 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

I need my pool cleaned. I have received estimates from three companies on how long it would take them to clean my pool. They have also told me how much they charge per hour. I want to find the best value. What formula would I enter into D3?

=$50*C3
=$50+C3
=B3+C3
=B3*C3

2.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

I have a chart of my monthly bills. I want to know the total cost of my utilities for the month. What formula would I enter into D6?

=SUM(D3:D5)
=104.23+80.00+5.04
=D3-D4-D5
=MAX(D3:D5)

3.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

I have a lawnmowing service. I want to find the amount I should charge each customer. Which formula would I enter into C3?

B3+20
=B3+20
=20*(B3+B4+B5)
=B3*20

4.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

I am buying some items online. I want to find the total cost of each item. Which formula(s) would I enter into C2?

=8.25*B2
=8.25%*B2+B2
=8.25/B2+B2
=SUM(B2:B4)

5.

MULTIPLE CHOICE QUESTION

5 mins • 1 pt

Media Image

I own a furniture store. Each customer made a purchase, and then made payments toward that purchase. I want to find out how much each customer still owes. Which formula would I enter into D3?

=B4-C4
=B3-C3
=B3+C3
B3-C3