Solved

You Are a Scientist Studying Beach Erosion at Your Local

Question 1

Essay

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. 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? 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?

Correct Answer:

verifed

Verified

Related Questions

Q2: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9074/.jpg" alt=" As shown in

Q3: The order of precedence in Excel formulas

Q4: When you click the Insert Function button

Q5: You can click the AutoSum button list

Q6: When you cut cells, the original data

Q7: The _ feature makes it easier to

Q8: Functions are organized into categories, such as

Q9: Absolute cell references are the default in

Q10: The information in the parentheses in =MAX(A1:F5)

Q11: <img src="https://d2lvgg3v3hfg70.cloudfront.net/TBX9074/.jpg" alt=" As shown in