Description
Complete all questions in assignment section of Module. Assignments can be completed in Word documents and/or Excel spreadsheets.
Type your name here, Last Name First
To complete the exercises, use the spreadsheet file titled “Budget Tools 2e Module 02 Exercises SelfChecking.” 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
Purchase answer to see full
attachment
To complete the exercises, use the spreadsheet file titled “Budget Tools 2e Module 02 Exercises SelfChecking.” 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
Purchase answer to see full
attachment
Categories: