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
- I need help with solving this problem. I don't know how to do it, and it seems confusing. Please show how to do it, and an explanation of it.
- A manager at a ski resort in Vermont wanted to determine the effect that weather had on its sales of lift tickets. The manager of the resort collected data
- A neuropsychologist is assessing the relationship between visual attention levels and the ability to multitask in a sample of 14 patients. He administers a