excel task 2

Project Description:

instructions: (use formulas or functions unless otherwise noted)

fitness club has a large client base that are looking to follow a strict calorie intake diet combined with exercise. therefore, in order to help its clients follow a routine, fitness club has set up a model to keep track of the hours of exercise per day in order to meet the target calorie intake. follow the steps to work through the model to make use of the different built-in excel functions.

create a model using the template on d2l. (filename: 3100 excel task 2 outline fall 2015)

use range names to define the following values:

4%: calorie_decrease

40%: breakfast

30%: lunch

20%: dinner

33%: exercise

assign the “calories to be burned/hours” table a range name as follows: “hoursofexercise”.

(note: do not select the table headers while assigning the table name)

“total calories allowed” for monday is 2100.

calculate the 4% decrease in “total calories allowed” for each day after monday.

breakfast is 40% of “total calories allowed.”

lunch is 30% of “total calories allowed.”

snack for each day is simply 210.

dinner is 20% of “total calories allowed.”

calculate “total calorie intake” using the sum function.

exercise is 33% of the “total calorie intake.”

calculate “net calories consumed” using a formula. (difference between “total calorie intake” and “exercise”)

using the vlookup function calculate the “hours of exercise needed” to burn the calories calculated in “exercise.”

use the goal seek analysis to set the “exercise” for friday to 575. (use the “snack” for friday as the cell to be modified for your model.)

page orientation landscape; create a header to include your name (center section), infs 3100 fall 2015 (right section), and excel task # 2 (left section). (use the header function.)

print a copy of your completed worksheet. (no row or column borders, e.g., a, b, c, 1, 2, 3)

print a copy of your cell formulas.

submit hardcopies of your work. there will be 2 pages. (staple the pages together.)

save your file. you may need to use it again for another task. (i may request to see the file electronically.)
Skills Required:
Project Stats:

Price Type: Fixed

Project Budget: $20 to $50
Completed
Total Proposals: 1
1 Current viewersl
26 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 5.0
    149 Jobs 119 Reviews
    $25 in 10 Days