Microsoft Office Tutorials and References
In Depth Information
EX 156
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
Cases and Places
Apply your creative thinking and problem solving skills to design and implement a solution.
E ASIER •• M ORE D IFFICULT
1: Design and Create a Weight-Loss Plan Worksheet
As a summer intern working for Choose to Lose, a local weight-loss clinic, you have been asked to
create a worksheet that estimates the monthly weight lost for an individual based on recommended
average daily activities. You have been given the numbers of calories burned per hour and the average
number of hours for each activity (Table 2–11). Use the following formulas:
Formula A: Total Calories Burned per Day = Calories burned per Hour
Average Hours Daily
Formula B: Total Pounds Lost per Month (30 days) = 30
Total Calories Burned per Day
3500
Formula C: Average function
Formula D: Max function
Formula E: Min function
Use the concepts and techniques presented in this project to create and format the worksheet. Include an
embedded 3-D Pie chart that shows the contribution of each activity to the total calories burned per day.
Use Microsoft Excel Help to create a professional looking 3-D Pie chart with title and data labels.
Table 2–11 Activities with Corresponding Calories Burned per Hour and Worksheet Layout
Calories
Burned
per Hour
Average
Hours
Daily
Total Calories
Burned per
Day
Total Pounds
Lost per Month
(30 Days)
Activity
Aerobics class
450
0.50
Formula A
Formula B
Brisk walking
350
0.50
House work
150
1.00
Ofﬁ ce work/sitting
120
6.00
Sleeping
70
9.00
Standing
105
2.00
Swimming
290
0.50
Tennis
315
0.25
Walking
240
4.25
Totals
Average
Formula C
Highest
Formula D
Lowest
Formula E
C6161_EXC_02.4c.indd 156
C6161_EXC_02.4c.indd 156
3/6/07 3:30:27 PM
3/6/07 3:30:27 PM

Search JabSto ::

Custom Search