Writing Formulas in Excel

Writing Formulas in Excel

7th - 9th Grade

5 Qs

quiz-placeholder

Similar activities

Статистикалық мәліметтер

Статистикалық мәліметтер

1st - 10th Grade

9 Qs

Excel Skills Quiz

Excel Skills Quiz

7th Grade

10 Qs

PIDAUSE-Hojas de Cálculo  T2G2

PIDAUSE-Hojas de Cálculo T2G2

8th Grade

10 Qs

Sum or Difference of Two cubes

Sum or Difference of Two cubes

8th - 10th Grade

10 Qs

Informática Saenz

Informática Saenz

7th Grade

10 Qs

ÔN TẬP HKI TIN 8

ÔN TẬP HKI TIN 8

8th Grade

10 Qs

BÀi 7: Tính toán tự động trên trang tính (tin học 7)

BÀi 7: Tính toán tự động trên trang tính (tin học 7)

7th Grade

10 Qs

MATH IDENTITIES-TAYTOTHTES

MATH IDENTITIES-TAYTOTHTES

9th - 10th Grade

10 Qs

Writing Formulas in Excel

Writing Formulas in Excel

Assessment

Quiz

Computers, Mathematics

7th - 9th Grade

Hard

Used 45+ times

FREE Resource

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