Spreadsheet

In order to learn more about spreadsheets you are going to create a Google, Numbers or Excel Spreadsheet designed to track the progress of 8 publicly traded companies. Your spreadsheet must look and function according to the criteria listed below. Use the **Spreadsheet Exemplar** to see what your spreadsheet should look like when finish (with different companies you choose).

** Tech Tip: **

 * Did you know Microsoft offers web-based versions of Excel, Word and PowerPoint? **
 * Click HERE to set up a Microsoft Live account **

__**Exemplar:**__
Open this **Google Spreadsheet Exemplar** to see what your spreadsheet **//should//** look like when you finish.


 * Now open a BLANK spreadsheet in Google Apps, Numbers or Excel and get started. **

1. Headers:
- Select Cells A1 to H20 and Align to CENTER - Enter ALL Headings EXACTLY as they appear on The Exemplar - Re-size EVERY column to appear the same as The Exemplar

2. Research:
Use the Google Finance Tool to find financial data for 8 listed companies. Record the following in Columns A, B + C: - Company Name - Trading Symbol - Purchase Price per Share of Stock (Large number without a $ sign)

3. Shares:
For now, “purchase” 10 shares of EVERY company’s stock (Column D). You will adjust the number of shares for each company later.

4. Formulas:
Enter the necessary Formulas (=) for ALL of the following COLUMNS: - Purchase Value of Investment ($) - New Value of Investment ($) - Investment Gain/Loss ($)

5. Functions:
Enter the appropriate Functions (Sigma) for ALL of the following ROWS: - Totals (SUM) - Highest (MAX) - Lowest (MIN) - Average

6. Invest:
Now go back to **Column D** and ADJUST the number of each company’s shares **UNTIL** the Total Purchase Value of Investment (**Cell E11**) is as close to $10,000 without going over!

7. Formatting:
Format each Row and Column correctly: - Currency must be formatted to appear as dollars (Ex. $4.50) - Gains must be “conditionally formatted” to appear GREEN - Losses must be “conditionally formatted” to appear RED - The Total Purchase Value of Investment (Cell E11) must be “conditionally formatted” to appear RED if it exceeds $10,000 - New Pricesmust appear BLUE font

All Done?
Take the time to compare **//your//** spreadsheet to the ** Google Spreadsheet Exemplar ** one more time to be sure your formatting is correct (Headers, $, Colors, etc.). Then enter ** New Prices ** for ALL 8 companies to test whether your Formulas, Functions and Conditional Formatting work correctly.

__** Submission: **__
Upload your document to your student portfolio under your **Digital Literacy Unit**.

** Need Help? **
//**Google**// //**Youtube**//
 * Try the following:**
 * //Help Menu//**
 * //Classmate//**