You are a scientist studying beach erosion at your local beach. You have created a simple worksheet to calculate the yearly erosion rate and to perform some what-if analysis. The spreadsheet that you have so far is given below. In June, you re reviewing your spreadsheet and notice that you ve made an error in March s and April s erosion per month. You used a formula to calculate the values for total erosion. What changes would you need to make to your spreadsheet so that all erosion figures and totals are correct?

Question

You are a scientist studying beach erosion at your local beach. You have created a simple worksheet to calculate the yearly erosion rate and to perform some what-if analysis. The spreadsheet that you have so far is given below.  In June, you re reviewing your spreadsheet and notice that you ve made an error in March s and April s erosion per month. You used a formula to calculate the values for total erosion. What changes would you need to make to your spreadsheet so that all erosion figures and totals are correct?

Quizplus · Accepted Answer

The Answer of You are a scientist studying beach erosion at your local beach. You have created a simple worksheet to calculate the yearly erosion rate and to perform some what-if analysis. The spreadsheet that you have so far is given below.  In June, you re reviewing your spreadsheet and notice that you ve made an error in March s and April s erosion per month. You used a formula to calculate the values for total erosion. What changes would you need to make to your spreadsheet so that all erosion figures and totals are correct?

You Are a Scientist Studying Beach Erosion at Your Local