Posted: February 8th, 2015

Excel Math Features

Paper, Order, or Assignment Requirements

In this assignment you will explore Microsoft Excel’s mathematical features. Begin by creating an Excel workbook and put your name and the title “Unit 6: Excel Math Features” in cell A1.

In Row 3, put the following labels in columns A through F:

Name
Age
Height
Weight
Height per Year
Pounds per Inch

Beginning in cell A4, put the first names of 8 to 10 family members, friends, co-workers, and acquaintances. Enter the age, height in inches, and weight in pounds of each. (It is okay to estimate or guess the data.) Next, using Excel’s mathematical capabilities (addition, subtraction, multiplication, and division), enter formulas to calculate “Height per Year” and “Pounds per Inch.” (Assume simple average growth.) Add one final row below the last name and enter totals for each column of data. Remember to save and name your Excel file before exiting the program.