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. Each month, you will enter the erosion per month (in centimeters). You then want Excel to automatically calculate Total Erosion (of all months) after you enter the erosion for each month. What would you need to enter to accomplish this, and what would the formula read in cell C15?

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.  Each month, you will enter the erosion per month (in centimeters). You then want Excel to automatically calculate Total Erosion (of all months) after you enter the erosion for each month. What would you need to enter to accomplish this, and what would the formula read in cell C15?

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.  Each month, you will enter the erosion per month (in centimeters). You then want Excel to automatically calculate Total Erosion (of all months) after you enter the erosion for each month. What would you need to enter to accomplish this, and what would the formula read in cell C15?

You Are a Scientist Studying Beach Erosion at Your Local