microsoft office

Project Description:

make sure to make correct use of range names because it is a significant portion of the grade.

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 their 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.

open “3100 excel task 4 outline fall 2015.

calculate the “total intake for the week” using the sum function.

assign range name “ treadmill_cost” to cell e3.

assign range name “interest_rate” to cell e4.

calculate the monthly payment for option 1, option 2 and option 3 using the pmt function (use the given treadmill cost and interest rate, and the # of years to do your calculations) note: convert years to months when using the formula.

insert a pie chart that depicts the calories for breakfast, lunch, snack and dinner for wednesday.

add chart title “calories for wednesday.”

legend should say: breakfast, lunch, snack and dinner accordingly.

for the nested if statement, set it as follows:

if the “hours of exercise needed” is >=2 then display “see trainer” if “hours of exercise needed” =1.5 then display “zumba” and for everything else display “yoga.”

calculate “number of days for yoga” using a countif function.

calculate “number of days total intake greater than 2300” using a countif function.

page orientation landscape; create a header to include your name (center section), infs 3100 fall 2015 (right section), and excel task # 4 (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)

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: $10 to $20
Completed
Total Proposals: 6
1 Current viewersl
82 Total views
Project posted by:

Proposals

Proposals Reputation Price offered
  • 4.8
    119 Jobs 55 Reviews
    $40 in 2 Days
  • 4.4
    84 Jobs 35 Reviews
    $30 in 1 Day
  • 4.9
    114 Jobs 49 Reviews
    $30 in 2 Days
  • 4.9
    503 Jobs 278 Reviews
    $30 in 1 Day
  • 4.6
    647 Jobs 468 Reviews
    $20 in 3 Days
  • 5.0
    147 Jobs 118 Reviews
    $25 in 3 Days