Question: 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
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. 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 different chart of accounts) on the blue tabs. 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." 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
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
