1. PURPOSE OF THE DATA
In this spread sheet the purpose of the data was to show the forecast of Humber Computing Solutions for the period of one year for three different services/products. The data represents the income from each product/service and total income and the same for expenditures. There is also a section that shows the amount of hours clients had issues with products/services and what was offered back to them as a way of compensation for any income they could have lost to no fault of their own. The data was supposed to be easy to read and understand by whoever was using the data sheet the graphs and charts were well displayed on their own pages rather than having them all squashed to fit one page.
Although many formulas have been used all are performing the same type of calculation. Each monthly sum is using the add formula to calculate the month by month income. There are many formulas that are possible to use but in this case the add formula was the one that fit the purpose. There are also two IF statements in the data sheet. (Office.microsoft.com, 2014) “The IF function checks to see if a condition you specify is true or false. If true, one thing happens if false, something else happens” as described by the makers of Excel. The IF statements are logical tests so in this data sheet the bonus IF statement =IF(O28