Writing Formulas in Excel

Writing Formulas in Excel

7th - 9th Grade

5 Qs

quiz-placeholder

Similar activities

Формули в Excel

Формули в Excel

7th Grade

8 Qs

Spreadsheet Basics

Spreadsheet Basics

6th - 9th Grade

8 Qs

Tin 7 bài 2

Tin 7 bài 2

6th - 9th Grade

10 Qs

Excellente

Excellente

1st - 10th Grade

10 Qs

Fulls de càlcul - LibreOffice Calc

Fulls de càlcul - LibreOffice Calc

8th Grade

8 Qs

Creating Formulas and Functions

Creating Formulas and Functions

7th - 12th Grade

10 Qs

Електронні таблиці (Початок)

Електронні таблиці (Початок)

8th Grade

10 Qs

2.11 Other Processing Methods 2

2.11 Other Processing Methods 2

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