revision 2

Define Formula Bar?

• I don't know

• I don't care

• Don't miss this one!

• An element in Excel that appears below the Ribbon and to the right of the Insert command that shows the contents of the active cell so that you edit the text, value, date, formula, or function.

What is the Sum formula?

• Sum( )

• Sum( )=

• =Sum( )

• =( )Sum

Tags

CCSS.6.SP.B.5C

When starting a formula what is the first thing you type in the cell?

• +

• -

• %

• =

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

• A1-C3

• A1-C3=

• =A1-C3

• =C3-A1

What would be a correct formula for SUM in excel?

• =SUM(B3:B9)
• =SUMB3+B9
• SUM(B3:B9)
• =ADD(B3:B9)

Which formula gets the biggest value of a range of cells?

• MAX
• MIN
• LARGE
• SUM

Which of the following formulas is not entered correctly?

• =10+50
• =B7+B8
• =B7+14
• 10+50

Which of these symbols is used for divide on a computer?

• \
• *
• /
• |

Tags

CCSS.4.NBT.B.6

This is a valid simple formula

• A2+A4

• =AB3+Y5

• (a2*t3)/100

• =(a2*t3)/100

+ is a symbol for:

• Multiplication

• Addition

• Subtraction

• Dividing