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