Spreadsheet - Formula Quiz

What is the name of this cell?

• B10

• 5B

• B5

• you cannot know the name from this picture

All formulas in spreadsheet begin with the following symbol:

• +
• -
• =
• %

Columns are labeled by ______________.

• numbers
• letters
• symbols
• colors

Rows are labeled by __________.

• numbers
• letters
• symbols
• colors

The correct formula to add cell B1 and B2 is

• AddB1+C1
• =sum(B1+C1)
•  =B1+B2

Which is the correct formula to add cells A1 THROUGH A5?

• =SUM(A2+A5)

• =SUM(A1:A5)

• =A1+A2+A3

• =SUM(A1:A4)

What formula should be written in cell D2 if I wanted to add the number in cell B2 with the number in cell C2?

• 498+5

• =B2+C2

• B2/C2

• B2+C2=

What symbol do we use for multiplication in a Spreadsheet program? 

• /
• =
• ^
• *

If we are only trying to add 2 cells together, which one of the formulas in correct?

• =sum(A2+A3)

• =A2+A3

• =sum(A2:A3)

• =A2*A3

Answer explanation

Remember we only use the Sum Function if we are added a lot of numbers together

To figure out the Subtotal you need to add the Labor plus the Parts. Which formula is correct?

• =sum(B6+C6)

• =B6+C6

• =SUM(B6:C6)

• =Labor+Parts

Answer explanation

Remember, we are only adding 2 numbers so we do NOT need to use the Sum function