Question

14. Emelia is very concerned about safety and has conducted a study to determine how many bike helmets were replaced at each location last year. She wants to include the survey results in this spreadsheet. Switch to the Helmets Per Location worksheet. Open the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook, and then switch back to Helmets Per Location worksheet. Link the data to the Helmets Per Location worksheet as described below: a. In cell C3 of the Helmets Per Location worksheet, create a formula without using a function that contains a relative reference to cell D2 of the 2019 Damaged Helmet Survey worksheet in the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook. b. In the Helmets Per Location worksheet, copy the formula in cell C3 to the range C4:C5 without copying the formatting. c. Close the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook and switch back to the Helmets Per Location worksheet.

Answer 1

Answer:

How can I do this formula please.

Explanation:

Emelia is very concerned about safety and has conducted a study to determine how many bike helmets were replaced at each location last year. She wants to include the survey results in this spreadsheet. Switch to the Helmets Per Location worksheet. Open the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook, and then switch back to Helmets Per Location worksheet. Link the data to the Helmets Per Location worksheet as described below: a. In cell C3 of the Helmets Per Location worksheet, create a formula without using a function that contains a relative reference to cell D2 of the 2019 Damaged Helmet Survey worksheet in the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook. b. In the Helmets Per Location worksheet, copy the formula in cell C3 to the range C4:C5 without copying the formatting. c. Close the Support_SC_EX16_5a_2019HelmetSurvey.xlsx workbook and switch back to the Helmets Per Location worksheet.

Answer 2

Answer:

Explanation:

Known Variables A = max Daily Rentals

X = Damaged helmets %

lets find the formula to calculate Helmets per location :taking 1st row as an example.

412 = B - (B*13/100)

412 = (100B-13B)/100

412*100 = 87B

B= 412*100/87

Hence, the generic formula becomes : B= A*100/(100-X)

Applying the same formula for each row and then using ROUND function of excel to round off the digits

=ROUND(number,digits) where number is the number you would like to round off and the digits is the number of decimal digits for it to round off. Since we want natural numbers in our example, we will be using digits as 0.

Explanation:

See attached pictures also.