Spreadsheet Formatting, Using Formulas and Functions

Standard 16:  Create new formulas to analyze data by calculating with, extracting from, presenting, and/or summarizing, including:  a) basic arithmetic calculations, b)basic mathematic functions (e.g. SUM, AVG, MIN, MAX), c) copying formulas that include both relative and absolute cell references d) sorting in ascending/descending order  e) filtering data to retrieve specific values f) basic conditional formatting (e.g., red for negative values)

Bell Work

Read the following article and write a paragraph on your own paper about the value of learning excel in this class.  The Key to a Good Paying Job is ... Microsoft Excel?

Guided Practice: Use Basic Formulas & Functions

Open the link to Independent Practice: Spreadsheet Formatting. (Technology Advancements)  Download (using Microsoft excel) and make a copy.  Rename sheet "GP Use Basic Formulas & Functions."  Follow along to enter data into a spreadsheet and perform simple calculations.  You will use operations and functions listed below.

• Addition, Subtraction, Multiplication, Division
• Average, Sum, Maximum, Minimum
• Absolute reference

Guided Practice: More Formatting

Open the GP More-Student spreadsheet. Download (using Microsoft excel) and make a copy and rename the spreadsheet "GP More Formatting."  Follow along to enter and format data and complete the following tasks:

• Format numbers and labels 
• Format borders 
• Insert and delete columns and rows
• Rename a spreadsheet
• Move a spreadsheet
• Use functions and formulas

To think about:
Why might a column need to be added or deleted?
Why might a spreadsheet need to be moved or renamed?

Independent Practice: Use Basic Functions

Open the GP Spreadsheet Formatting.  Download (using Microsoft excel) and make a copy and rename the spreadsheet "IP Use Basic Functions".  Follow the instructions from the worksheet to complete the spreadsheet accurately.  When complete send as an attachment in an email to julie6davis@gmail.com.