heart rate-Saved Insert Data Draw Page Layout Formulas Summarize with Pivot Table Remove Duplicates sert Convert to Range Review View Header Row Total Row Banded Rows Table Tell me Pest Column Fiter Button Last Column Banded Columns Refresh DEF G H art Rate 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 rec Average heart rate (in beats per minute) is given by the following formula: Heart Rate - (220 -Age) 70% Input Age: Output Heart Rate: a.) Enter a formula in the output cell that computes the Heart Rate (beats per minute) for a ven input of Age years) sure to use cell references and format to one decimal place of accuracy. Test your formula for an 18-year-old who should have a heart rate of 141.4 beats per minute. Age Heart Rate b.) Create a Table of values, separate from the input/output cells in part a, for Heart Rate as a function of Age. Use cell references and fi down Chart .) c.) Create a well-labeled column chart of this table from part Add axis labels with the units of the variables, and add a title with name of the dependent variable. Axis labels and the title should be chosen from the list a. Heart Rate b. Age (years) Beats per Minute instructions Questions