Writing Formulas in Excel

Writing Formulas in Excel

7th - 9th Grade

5 Qs

quiz-placeholder

Similar activities

test tin 7

test tin 7

7th Grade

10 Qs

ÔN TẬP HKI TIN 8

ÔN TẬP HKI TIN 8

8th Grade

10 Qs

Index laws

Index laws

7th - 8th Grade

10 Qs

GVBM: THIÊN HƯƠNG_TIN HỌC 7_ CÂU HỎI ÔN BÀI 2

GVBM: THIÊN HƯƠNG_TIN HỌC 7_ CÂU HỎI ÔN BÀI 2

7th Grade

10 Qs

sử dụng các hàm để tính toán

sử dụng các hàm để tính toán

7th Grade

10 Qs

Excel Skills Quiz

Excel Skills Quiz

7th Grade

10 Qs

3ème Statistiques - Tableur

3ème Statistiques - Tableur

KG - Professional Development

10 Qs

Evaluación de math tercer trimetre

Evaluación de math tercer trimetre

8th 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

Discover more resources for Computers