Spreadsheet Formulas/Functions

Spreadsheet Formulas/Functions

6th - 8th Grade

11 Qs

quiz-placeholder

Similar activities

Excel

Excel

6th Grade

12 Qs

Year 6 Introduction to Spreadsheets

Year 6 Introduction to Spreadsheets

6th Grade

10 Qs

What do you know about spreadsheeting?

What do you know about spreadsheeting?

6th - 8th Grade

10 Qs

Excel aula 1

Excel aula 1

7th - 10th Grade

9 Qs

EXCEL - FORMATO

EXCEL - FORMATO

6th - 10th Grade

11 Qs

Data Anaysis

Data Anaysis

7th Grade

15 Qs

Función SUMA

Función SUMA

KG - Professional Development

11 Qs

Puzzle Cells

Puzzle Cells

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

=(D2:D10)

=sum(D2:D10)

=D2+D3+D4+D5+D6+D7+D8+D9+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

Copy the formula from cell D2 down

=B4*C4

=B4-C4

7.

LABELLING QUESTION

1 min • 1 pt

What label is in cell B1

b

Total Cost

Price per item

Item

Quanity

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?