Yorkville High School Computer Science

Computer Applications I :: Projects :: Superhero Stocks

Problem

You are a mutual fund manager and have decided to make a spreadsheet to see how many stocks you should purchase for your fund.

Instructions

1. Create the spreadsheet as shown above. Make sure you give it a title.
2. Use vlookup to determine the number of shares that must be bought based on the table-array below.
3. Write a formula that will calculate the total amount of money spent on each stock.
4. Using vlookup determine what the status of each company is based on the table-array below.
5. Use the choose function to apply the following to each company.
   
6. Make your spreadsheet look professional by using color and borders. Format all the numbers correctly.