Module 02 Exercises SelfChecking Discussion
Module 02 Exercises SelfChecking Discussion
The exercise comes in three parts. The first part, a tutorial in spreadsheet skills, is intended to help you prepare for the second and third parts. 2.1. 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. 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 different chart of accounts) on the blue tabs. 2.2. Copy the information from the “Source” tab to the “Expenses” 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 the “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 in the example. The “subtotal” function is explained in Appendix B, in the section “Formulas and Functions for Budgeting.” 2.3. 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.” x 0 Part 1 Do the ENTIRE tutorial as called for on the tab “Exercise 1 Tutorial.” This provides the skills for Exercises 2 and 3. Even experienced users of spreadsheets will find something new. THEN review the examples. Then do Part 2 and Part 3. In general, the cells you can enter data into are highlighted, mostly yellow, but occassionally another color. Sometimes cells are highlighted for other reasons. Part 2 1. Copy the information from the “Source” tab to the “Expenses” tab. Put these data in blocks reflecting the categories shown on the “Summary” tab (look at the “Example Summary” tab first). (You can only copy one block of data at a time because the “Expense” tab has areas that are locked.) 2. Format the copied information in a pleasing manner resembling the example of the first block at the top of the “Expenses” tab. 3. Calculate subtotals (totals) for blocks, using the “subtotal” function, which should be shown at the bottom of each block, as with the example. 4. Validate success by finding that the “Self-Check” columns haveturned completely to “TRUE.” Part 3 1. Carry the subtotals for each section to the “Summary” tab using the “=” sign as practiced on the “Tutorial” tab. 2. Calculate sums as indicated by the “Total” labels on the “Summary” tab using the “subtotal” function. 3. Validate success by finding that the “Self-Check” columns have turned completely to “TRUE.” 4. Format as needed. Note the “Example Expenses” tab and “Example Summary” tab (using a different chart of accounts) that are shown on separate sheets (tabs). 0,0% Percent Correct All Pages, Not Adjusted for outline format (graded manually) 0 Grade If a range requires formatting and cannot be accessed, use the password “Student” In column F you will find some cells and data exhibiting many of the skills you need to learn. ———————–This part describes how cells F6 through F10 were prepared. (shown as an example). (this is how it was done, not what you are to do, see the “Try this yourself” for what to do) To get the dark bold outline (from the top of row 5 to the bottom of row 10) use the outline/border icon on the formatting ribbon. Highlight all rows from 5 to 10. Then click the drop-down arrow beside the outline/border icon. Select the broad boarder icon. $ $ $ 500 300 499 $ $ $ 123 345 1.767 7000-7999 Personnel 7000 Grants, contracts, & direct assistance 7100 Salaries & related expenses Total
