Microsoft Office Tutorials and References
In Depth Information
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
Lost per Month
Ofﬁ ce work/sitting