Excel - Functions

Learning Target:

• I can make calculations using functions in a spreadsheet.

We often need to make calculations that, without the use of spreadsheet, are complex and time consuming. We will learn to use a spreadsheet to perform calculations.

Part 1: Learn the basics

Download these 2 files and complete the activity.
• excel_functions_instructions.pdf
• excel_functions.xls

LINKS:

• Excel Tutorials (Clemson U. Physics Lab): http://phoenix.phys.clemson.edu/tutorials/excel/
• Excel Tutorials (Florida Gulf Coast Univ.): http://www.fgcu.edu/Support/office2000/excel/
• Excel Tutorials (University of South Dakota): http://www.usd.edu/trio/tut/excel/
• Excel Tutorials (Saskatchewan): http://www.saskschools.ca/~ehs/HeiseIntra/excel.html
• Excel Tutorials (Bay City Schools): http://www.bcschools.net/staff/ExcelHelp.htm
• Excel VBA: http://www.excel-vba.com/?gclid=CPaFxt-7q5MCFQVvFQodcHP93g
• Excel 2008 Help and How-to: http://www.microsoft.com/mac/help.mspx?app=1

Part 2: Create a spreadsheet that will help you to calculate your composite score.

More to come.