View the step-by-step solution to:

# In column F you will find some cells and data exhibiting many of the skills you need to learn. It is assumed you can copy and paste data. This part...

Q: Chapter 2 Questions 1-3

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".
7000-7999 Personnel \$500 7000 Grants, contracts, & direct assistance \$1,767 \$300 7100 Salaries & related expenses: \$1,399 \$499 3166 \$123 \$345 \$1,767 \$500 \$400 \$499 \$1,399 The other skills you need can be practiced with cells H4 through J7. First, you need column I to be wider. To achieve this, place your cursor in the space between columns I and J on the label row and quickly click twice (double click). Next you need the total from cell F17 in cell J6. Place your cursor in J6, press the "=" key, then point to cell F17, then hit enter. (This process will also work across separate tabs.) Third, in cell J7, type =subtotal(9,J5:J6) This produces a total just like in cell F10, when you make another "subtotal" that crosses over this cell, the subtotal will be ignored. Now make an appropriate label for row H through J7. Finally, practice your formatting skills. In column F you will find some cells and data exhibiting many of the skills you need to learn. It is assumed you can copy and paste data. This part describes how cells F6 through F10 were prepared. To get the dark bold outline (from the top of row 5 to the bottom of row 10) you should use the outline/border icon on the formatting toolbar (in Excel 2007, find this 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 border icon. You can then highlight row 9 and repeat and select the narrow bottom border. The \$ mark is achieved through two steps. First, highlight the cells (5 through 10) and click the \$ mark format icon. Then highlight again and click twice on the fewer decimal point icon to remove the decimals. To put the total in row 10, click on the cell F10, then type =subtotal(9,F5:F9) Try this yourself for rows 14-16. Put the total in cell F17. You should get a total of \$1,399.
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). 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. Part 3 1. Carry the totals 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" column on the "Summary" tab has turned completely to "TRUE." Note the "Example Expenses" tab and "Example Summary" tab (using a different chart of accounts) that are shown on separate sheets.
Show entire document

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

Browse Documents