Spreadsheets Quiz 1

What is one reason to use cell references in a formula?

• The answer will change if the numbers in referenced cells change.

• You need cell references to use functions.

• Only formulas with cell references can be copied and pasted.

• You need cell references to use operators.

Tags

TA.6.L.ii

Which of these adds two referenced cells?

• =B3+C3

• =B+C+3+3

• =(B3,C3)

• =B+C

Tags

TA.6.L.ii

What is the operator used to multiply?

• @

• ^

• /

• *

Tags

TA.6.L.ii

If you type =1+1 in the formula bar, what will show in the cell after you hit Enter or Return?

• =1+1

• 2

• 1+1

• =2

Tags

TA.6.L.ii

Cell C1 has =A1+B1 in it. If you copy and paste cell C1 into cell C2, what will show in the formula bar for C2?

• =A1+B1

• =C1+C2

• =A2+B2

• =A1+B1+A2+B2

Tags

TA.6.L.ii

What would you type to find the sum of the cells D4 through D6?

• =SUM(D4/D6)

• =SUM(D4,D6)

• =SUM(D4:D6)

• =SUM(D4-D6)

Tags

TA.6.L.ii

How do you copy a formula from one cell into a large group of cells?

• Select the group of cells and type the formula into the formula bar.

• Retype the formula into each cell.

• Copy the formula, select the group of cells, and paste.

• Select the group of cells and hit Enter or Return.

Tags

TA.6.L.ii

What icon is used to add up selected cells?

• 
• 
• 
• 

Tags

TA.6.L.ii

In which table will the formula in cell B5 find the average distance of the player's two tosses?

• 
• 
• 
• 

Tags

TA.6.L.ii

Which of these will always divide the value of a cell A1 by 2?

• =A1*B1

• =A1/B1

• =A1*2

• =A1/2

Tags

TA.6.L.ii