Computer Information and Technology, Due Sunday at 10:00 a.m.

Open a new blank Microsoft Excel Worksheet and complete the following steps to successfully finish and submit your assignment:

1.     In the Microsoft Excel program, fill in data based on the table below. Make sure you start in Cell A1 (meaning “Season” is in Cell A1 and that “Fall” is in A5 and “Total” is in D1)

2.     Type the numbers and formulas, and arrange them exactly as you see them within the table above.

3.     Notice that the Formulas you typed in the Total Column are now the total cost of each season (Quantity x Price).

4.     Select all four rows, Winter, Spring, Summer, Fall, along with the number for quantity and price.

5.     Select the Insert tab, click on the Column icon, and select any chart type under “3-D Column.”

6.     You should see that your total is a formula, not a number entered into the cell.

7.     Save your Excel file as “yourname_IP5.”