Search Header Logo

Writing Formulas in Excel

Computers, Mathematics

7th - 9th Grade

5 Questions

Used 45+ times

Writing Formulas in Excel
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?