Spreadsheet

Spreadsheets!

​

Multiple Choice

Which cell contains the HIGHEST number?

• A1

• A2

• A3

• B1

• B2

The highest number is 100 and it is located in cell A2.

​

Multiple Choice

What number would the spreadsheet show in cell A5 if you typed the formula below?

=A2*B3

• 15

• 18

• 20

• 50

A2 = 5

B3 = 10

5 * 10 = 50

​

Multiple Choice

What number would the spreadsheet show in cell A5 if you typed the formula below? 

=A3/A1 

• 3

• 4

• 8

• 12

A3 = 6

A1 = 2

6/2 = 3

"6/2" means "6 divided by 2".

Multiple Choice

What number would the spreadsheet show in cell A5 if you typed the formula below?

=SUM(B1:B3)

• 11

• 13

• 14

• 30

=SUM(B1:B3)

1 + 3 + 10 = 14

=SUM(B1:B3) tells the computer to add all of the values from B1 to B3.

Multiple Choice

Which formula should be written in cell B3 to calculate the sale price?

• =B1 + B2

• =B1 - B2

• =B3 - B1

• =B2 * B1

=B1 - B2

To find the sale price, take the original price and subtract the amount of the coupon.

Multiple Choice

Which formula was written in cell B2 to calculate 5% sales tax?

• =5%B1

• =5PERCENT(A1)

• =0.05*B1

• =B1/5

=0.05*B1

To find 5% of a number, multiply the number by 0.05.