Material Detail

“Nobody sets out to create a mission critical spreadsheet, they ‘just happen’.”  — Felienne Hermans in “Analyzing and visualizing spreadsheets”

Spreadsheets are great at storing information; for some, it has become a type of database. The real power in Excel can be found within the formulas and functions. With just a few clicks, Excel can do calculations that would make a math teacher jealous.

In this unit, we look at how we use functions and formulas, the proper time to switch between the two, and some standards that you need to know.

Unit Objectives:

• Name a cell and group
• Describe the different types of cell references
• Write a simple Excel formula
• List some common functions and write out examples of each
• Use common format functions to configure cells

This will delete the comment from the database. This operation is not reversible. Are you sure you want to do it?

Thank you for reporting a broken "Go to Material" link in MERLOT to help us maintain a collection of valuable learning materials.

If you feel this material is inappropriate for the MERLOT Collection, please click SEND REPORT, and the MERLOT Team will investigate. Thank you!

You are being taken to the material on another site. This will open a new window.

Do not show me this again