Electronic Spreadsheet Applications 

Discussion Topic

Module 3: Performing Calculations with Formulas and Functions

Question/Topic:

David is entering daily rainfall values into a worksheet for a weather report, and wants to speed up data entry by leaving some values as blanks rather than typing zeroes when there is no data collected for a particular day. Explain why this will cause complications or incorrect results in the final calculation of the average rainfall. Cite any example when it might be preferable to use blanks instead of entering a zero into a worksheet for calculations.

At least 250 words, APA Format

 Course Materials: Required Text or eBook: Parsons, J., Oja, D., Ageloff, R., Carey, P., & DesJardins, C.(2020). New Perspectives Microsoft Office 365 & Excel 2019,Comprehensive. Boston, MA: Cengage Learning.