Tuesday, February 5, 2013

IT Application Assignment 2013

Nutritional Spreadsheet :

Data Collection


VlookUP

Chart 


FORMULA AND FUNCTIONS
Product
=PRODUCT(Number1,Number2)
Multiplies the values in a particular field of records that match the criteria in a database
Percentage of Fat
=(Grams of Fat * 9 / Total Calories per serving) * 100

To find the percentage of fat.

No comments: