Formulas and Functions

Formulas and Functions

Title: Formulas and Functions

Do now:

• What is formula?

• What does the function Max do?

• What does the function Min do?

• What function totals up values?

Title: Formulas and Functions

Do now: Answers

• What is formula? Formulas are usually simple calculations, eg adding two or more numbers together. They always start with an equals sign (=).

• What does the function Max do? Finds largest value

• What does the function Min do? Finds the smallest value

• What function totals up values? SUM

Functions

Example of the SUM formula in use

Multiple Choice

What symbol do all formula start with in Excel?

• +

• -

• =

• *

• /

Multiple Choice

What symbol do you use to add two cells' values in Excel?

• +

• -

• =

• *

• /

Multiple Choice

What symbol do you use to divide two cells' values in Excel?

• +

• -

• =

• *

• /

Multiple Choice

What symbol do you use to times two cells' values in Excel?

• +

• -

• =

• *

• /

Multiple Choice

What symbol do you use to subtract two cells' values in Excel?

• +

• -

• =

• *

• /

Multiple Choice

What is the value of the active cell?

• Y

• N

• Batman

• Superman

Multiple Choice

What is the cell reference of the active cell?

• A1

• 4B

• BB8

• B4

Multiple Choice

What has happened to Superheros in cells B2:D2?

• Merged

• Joined

• Fused

• Nothing

Multiple Choice

What does the function =SUM() do?

• Adds up Cells

• Sells Cells

• Multiplies Cells

• Divides Cells

Multiple Choice

What does the function =MAX() do?

• Finds the smallest number

• Finds the biggest number

• Finds the right number

• Finds the left number

Multiple Choice

What does the function =MIN() do?

• Finds the biggest number

• Finds the smallest number

• Finds the correct number

• Finds the wrong number

Multiple Choice

What type of graph is this?

• Bar

• Line

• Pie

• Scatter