Heart Rate

B

Project Description:

In this problem, you will investigate the heart rate at different ages. You will also provide the results as a column chart.

Use a cell reference or a single formula where appropriate in order to receive full credit. Do not copy and paste values or type values, as you will not receive full credit for your answers.

Steps to Perform:

$8$

Step

Instructions

$91$ Start Excel. Download and open the workbook named:

Chapter$\_1-1\_$Heart$\_$Rate$\_$Start

In cell C$11$; use the appropriate formula to calculate the heart rate for the age in cell C$10.$ Format cell $C11$ as Number with $1$ decimal place.

In cell C$16,$ use the appropriate formula to calculate the heart rate for the age in cell B$16.$ Fill cell C$16$ down the column to cell C$25.$

In cells K$18$:R$33,$ insert a Clustered Column Chart to show the relationship between the heart rate and the age. Select the range B$16$:C$25.$ On the Insert tab, click Recommended Charts, and

then click Clustered Column. Apply Style $6$ on the Design tab. Add a chart title and choose the Above Chart option. Replace Chart Title with Heart Rate. Add axis titles. Replace Axis Title for the

horizontal axis with Age $($years$)$ and Axis Title for the vertical axis with Beats per Minute.

Note: The category $x-$axis labels should be from $10$ to $100$ with increment $10.$

$5$ Save your file and submit for grading.