Gain Immediate access to our Essays
FREE access exchanged for your work, or pay £9.99
Words: | Submitted: Mon Jun 19 2006
... make sure that the data within them is correct. The sizes of the columns and rows will need to be adjustable. To set up my first grid I thought of appropriate names for column. I then entered the names that I was given for the rows. Formulas I used many formulas in this spreadsheet as it will in future save the manager time. I mostly used the =SUM formula and I also used the =IF formula as shown on the printouts. I have also explained what the formulas I have used do in the spread sheet. Graph Generation Once I had made my spreadsheet I needed to make a graph so that it was easier to understand the results. I selected the columns and rows that were needed so that I could make a bar graph. As this screen shot shows I selected from cells A3 - E8. I then clicked the graph button bringing up the screen shown ...
FREE access exchanged for your work, or pay £9.99