Search Header Logo
PIT - L26

PIT - L26

Assessment

Presentation

Business

9th Grade

Medium

Created by

Britney Martin

Used 1+ times

FREE Resource

21 Slides • 11 Questions

1

media

2

media

3

media

4

media

5

media

6

media

7

Open Ended

What is a spreadsheet?

8

media

9

Open Ended

Have you used spreadsheets before? If so, what did you do with them?

10

media

11

media

12

media

13

media

14

media

15

media

16

Multiple Choice

Question image

If you wanted to add the cost of pens and pencils to determine how much was spend on writing utensils, what would your formula be?

1

=A6+B6

2

=A6+A7

3

=B6+B7

4

=B7+A7

17

media

18

Multiple Choice

Question image

If you wanted to add the cost of ALL of the office supplies listed, what would your formula be?

1

=SUM(A1:A7)

2

=SUM(B1:B7)

3

=SUM(A2:A7)

4

=SUM(B2:B7)

19

media

20

Multiple Choice

Question image

What formula would you use to determine how much yeast is needed for 6 loaves of bread?

1

=A3+B3

2

=B3*D3

3

=B3+D3

4

=A3*D3

21

Multiple Choice

Question image

What formula would you use to determine how much flour is needed to make 3 loaves of bread?

1

=E2*F2

2

=E2/F2

3

=A2*E2

4

=F2-E2

22

media

23

Multiple Choice

Question image

Using the information in the table above, which formula would you use to determine the percent of total sales from cookies?

1

=A4/A7

2

=B4*B7

3

+B4/B7

4

=B4/B7

24

media

25

media

26

media

27

media

28

Multiple Choice

A spreadsheet is made up of _____ - where the rows and columns intersect and you can enter data.

1

cells

2

functions

3

values

4

workspaces

29

Multiple Choice

The cell that is in effect and will display the information typed into the spreadsheet

1

select cell

2

active cell

3

display cell

4

definite cell

30

Multiple Choice

Which is the acronym that correctly represents the order of operations?

1

SAMPED

2

SPAMED

3

PEMDAS

4

PAMSED

31

Multiple Choice

A _________ allows you to add many cells at once.

1

ROUND function

2

SUM function

3

percentage

4

formatting

32

media
media

Show answer

Auto Play

Slide 1 / 32

SLIDE