Part A 1) Using a spreadsheet formula/function to display how many participants in the study are smokers 2) Using a spreadsheet formula/function to display the highest heart rate in the entire dataset. 1) Using a spreadsheet formula/function to display how many participants in the study were male 4) Using a spreadsheet formula/function to display the average BMI in the entire dataset. Part B Insert a Pivot Table that lists the age and the average heart rate for the age and the number of participants that are that particular age. Part C Create a filter so only female smokers are displayed Part D Next, Insert a Scatter Plot comparing the BMI and the Cholesterol (totChol) for the Female Smokers similar to what you see below