This paper concentrates on the primary theme of Create a new worksheet by clicking the tab at the bottom of the page, re-name it “Profits” 20. in which you have to explain and evaluate its intricate aspects in detail. In addition to this, this paper has been reviewed and purchased by most of the students hence; it has been rated 4.8 points on the scale of 5 points. Besides, the price of this paper starts from £ 40. For more details and full access to the paper, please refer to the site.
At the end of the year the owner is going through the books and wants to analyse profits over the year. The profits in March through December were $718, $508, $963, $1370, $1418, $733, $1376, $925, $379, and $1511 respectively 19. Create a new worksheet by clicking the tab at the bottom of the page, re-name it “Profits” 20. Enter the headings (in bold) Month and Profit in cells A1 and B1, respectively 21. Type “January” in cell A2, then, with that cell selected click on the small black square at the bottom right corner of the cell and drag it down to fill A3 to A13 with the months of the year 22. Resize the column width by dragging or double-clicking the line between the A and the B 23. In cell B2 and B3 write a formula to link to the relevant cells in the other worksheets 24. Add in the remaining profit data to cells B4 to B13 25. Add a border around every cell to the table 26. In cell A14 put the header “Average” in bold and in cell B14 write a formula by summing the values and dividing by 12 to calculate the average monthly profit. Add borders around these cells