1. PURPOSE OF THE DATAIn this spreadsheet, the purpose of the data was to show Humber Computing Solutions' forecasts for a one-year period for three different services/products. The data represents revenue from each product/service and total revenue and the same goes for expenses. There is also a section that shows the number of hours customers had issues with the products/services and what they were offered as compensation for any revenue they may have lost through no fault of their own. their fault. The data was intended to be easy to read and understand by anyone using the data sheet. Graphs and charts were nicely displayed on their own pages rather than having them all squashed to fit on one page.2. FORMULAS Although many formulas have been used, all perform the same type of calculation. Each monthly sum uses the addition formula to calculate income month by month. There are many possible formulas to use, but in this case the addition formula was the one that fit the purpose. There are also two IF instructions in the datasheet. (Office.microsoft.com, 2014) “The IF function checks whether a condition you specify is true or false. If true, one thing happens, if false, something else happens,” as Excel’s creators describe it. IF statements are logic tests, so in this datasheet, the bonus IF statement =IF(O283. AUTOMATED FEATURESCash flow forecasting has been made easier to use...... middle of paper... ...y display as currency in the income and expense cells.7. TEST PLANFor all workbooks produced, a test plan should be available for viewing by anyone who needs to use the document and can explain how troubleshoot if any In the test plan, every aspect is automated was tested to make sure it worked. One of the routines failed and it was an IF statement. was that the = was missing in the code and once added, the problem was corrected and the test passed cells are used for each automated formula or macro Works CitedBIBLIOGARAPHYOffice, microsoft.com, (2014 The IF function: that. what it is and how to use it - Excel [online] Available at: http://office. microsoft.com/en-gb/excel-help/the-if-function-what-it-is-and-how-to-use-it-RZ102425926.aspx [Accessed May 22. 2014].