The spreadsheet opens on the "Tutorial" tab. Instructions are provided in the two highlighted green text boxes. The left text box first describes how cells F5 through F9 are summed in cell F10 and how all of these cells are formatted. It then asks you to do the same with data in cells F14 through F16. The right text box describes some advanced formatting skills and asks you to learn a very straightforward use of the "=" sign. After completing part 1, click on the "Explanation" tab which gives step by step instructions for parts 2 and 3. Before completing these problems, look at the examples (using a dirrent chart of accounts) on the blue tabs.
Copy the information from the "Source" tab to the "Expense" tab. When you copy the data you will learn the relationship between codes and labels. The table also contains dollar values associated with the labels. Put these data in blocks reflecting the categories shown on the "Summary" tab (look at he "Example Summary" tab first). Format the copied information in a pleasing manner resembling the example of the first block at the top of the "Expenses" tab. Calculate subtotals for blocks, using the "subtotal" function, which should be shown at the bottom of each block as with the example. The "subtotal" function is explained in Appendix C, in the section on the spreadsheeting for budgets.
Carry the totals to the "Summary" tab using the "=" sign as practiced on the "Tutorial" tab. Format the "Summary" tab in a pleasing manner. Calculate sums as indicated by the "Total" labels on the "Summary" tab using the "subtotal" function. Validate success by finding that the "Self-Check" column on the "Summary" tab has turned completely to "True".
Recently Asked Questions
- Please explain what are the various categories (5) of the service mix?
- subject : security architecture and design For this week's discussion question, lets do an attack tree. The written assignment this week is to use the STRIDE
- Why was I charged $163 when its supposed to be $9.99 wtf this is misleading i need a refund nowww.