Spreadsheet Assignment -ALL 3rd Form Classes

Complete the following tasks using MS Excel.  
Submit to marcelliyoung@yahoo.com no later than Monday, November 3, 2014 before 7pm.
Assessment being graded in the category of 'Other'.  
Total points: 30

Recreate the following spreadsheet starting at cell A1.  Font Face: Times New Roman. Font Size: 12
Click on the image to enlarge.

Instructions:

In an appropriate area of your spreadsheet, insert the following:

1. Insert two blank rows and in Cell A1, enter your name and class,  In cell C1, use a function to include the actual date.  [2pts] 
2. Insert a heading labelled as CALORIE COUNTERS.  Bold, center across selection, and change font size to 14.  [3pts]
3. In cell A26, insert the label Number of Items.  In cell B26, using a function, state the number of food items displayed.  [2pts]
4. In cell A27, insert the label Highest Calorie.  In cell B27, using a function, state the highest calories from the range. [2pts]
5. In cell A28, insert the label Lowest Fat.  In cell B28, using a function, state the lowest fat from the range.  [2pts]
6. In cell A29, insert the label Number of Fast Foods.  In cell B29, use a function to state the number of fast food items based on column A contents. [2pts]
7. In column H, insert the column heading Status.  Determine whether the item is Good or Bad based on the following.  If the calories is increased by 5%, and is still less than 180, then the item is good. [4pts]
8. In column I, insert the column heading Recommended.  Using vlookup, determine the status of each item.  [5pts]
9. Create a criterion and extract all Category that are Fast Foods.  Place the results in an appropriate area of the spreadsheet.  [4pts]
10. Create a criterion and extract all Category that are Baked Goods with Calories more than 200.  Place the results in an appropriate area of the spreadsheet.  [4pts]