Spreadsheet Formulas/Functions

Spreadsheet Formulas/Functions

6th - 8th Grade

11 Qs

quiz-placeholder

Similar activities

Tin 7 bài 2

Tin 7 bài 2

6th - 9th Grade

10 Qs

Informatika - Berpikir Komputasional

Informatika - Berpikir Komputasional

8th Grade

10 Qs

Информатика база Excel

Информатика база Excel

8th Grade

12 Qs

Microbit +Makecode

Microbit +Makecode

4th - 7th Grade

16 Qs

Excellente

Excellente

1st - 10th Grade

10 Qs

PEMBANGUNAN ALGORITMA TINGKATAN 3

PEMBANGUNAN ALGORITMA TINGKATAN 3

8th Grade

15 Qs

Penugasan Pengolahan Data Dasar

Penugasan Pengolahan Data Dasar

7th Grade

10 Qs

Spreadsheet Formulas/Functions

Spreadsheet Formulas/Functions

Assessment

Quiz

Computers

6th - 8th Grade

Medium

Created by

Bo Riddick

Used 9+ times

FREE Resource

11 questions

Show all answers

1.

LABELLING QUESTION

1 min • 1 pt

What is the formula you would use in cell D2 to find the total cost per item?

a

=B1/C1

=B1-C1

=B1*C1

=B1+C1

2.

LABELLING QUESTION

1 min • 1 pt

What is the formula or function you would use to get the subtotal?

a
c

=D2+D3+D4+D5+D6+D7+D8+D9+D10

=D2+D10

=(D2:D10)

=sum(D2:D10)

3.

LABELLING QUESTION

1 min • 1 pt

How would you calculate the tax in cell D13 ($55.50)

a

=D12+.06

=D12*.06

=D12-.06

=D12/.06

4.

LABELLING QUESTION

1 min • 1 pt

How would you find the total cell D14?

a

=D12-D13

=D12/D13

=D12*D13

=D12+D13

5.

LABELLING QUESTION

1 min • 1 pt

How would you find the remaining balance from your budget of $1,000?

c

=D12-1000

=D13-1000

=D14-1000

6.

LABELLING QUESTION

1 min • 1 pt

What formula would you use the get the total cost (D4)?

b
a

=B4-C4

=B4+C4

=B4*C4

Copy the formula from cell D2 down

7.

LABELLING QUESTION

1 min • 1 pt

What label is in cell B1

b

Quanity

Price per item

Total Cost

Item

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?