Excel formulas

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?

• +

• -

• %

• =

The letters in Excel represent the _______?

• columns

• rows

• data

• functions

The numbers in Excel represent the _____?

• columns

• rows

• data

• functions

When making a graph whats the first thing you need to do?

• Pick the type of Graph

• Use the function = sign

• Highlight your data being used.

• Double click the active cell

The most common way to identify a cell reference is 

• $D2
• $D$2
• D$2
• D2$

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 formula gets the smallest value of a range of cells?

• MAX
• MIN
• SMALL
• SUM

Which formula would you use to calculate how many sales are over $20 from a series.

• sum

• sumif

• count

• countif