Excel Formulas and Functions

Excel Formulas and Functions

Pay attention to the next 9 slides.

You will complete a short quiz at the end.

What is a function?

They are provided by Excel to help you perform operations.

What are the functions of a spreadsheet?

• A function is built into the spreadsheet.

• All functions allow simple or complex operations.

• Each function has specific rules that need to be followed.

  
  

Functions are written like code.

=AVERGAE (D4:D14) / calculates the average of the numbers from cell D4 to D14.

Several types of functions

• Logical

• Text

• Financial

• Date and Time

• Math

What is a formula?

• An equation that is used to perform a calculation.

Formulas

Always start with an equal sign.

followed by values or operators such as the +, -, *, / signs. =D4+D5 will add the numbers 15+17 to make 32.

Multiple Choice

Which are the three essential elements to enter a function?

• Equal sign, function name and cell reference.

• Function name, data and cell reference.

• Equal sign, cell reference and formula.

Multiple Choice

How does a function work in a spreadsheet?

• Accepts values, performs calculations and displays a chart.

• Accepts values, performs calculations and displays a result.

• Performs calculations, displays results and accepts numbers.

Multiple Choice

These are examples of types of functions in a spreadsheet:

• Function sum, function currency and function count.

• Text functions, function currency and logical functions.

• Logical functions, text functions and financial functions.

Multiple Choice

=C4+C5

What is the result?

• 32

• 12

• 17

• 15

Open Ended

The cash is missing for 'Computers For Dummies'. Write a formula to calculate it.

All done!

I will check your answers and give you feedback. THANK YOU!