Using the Quick Analysis tool, create a formula in the Quarter 1 column that uses the SUM function, then copy that formula into the Total row for the remaining Quarters.

Independent Challenge 2

Hie Dog Days Daycare Center is a small, growing pet care center that has hired you to organize its accounting records using Excel, The owners want you to track the company’s expenses. Before you were hired, one of the bookkeepers began entering last year’s expenses in a workbook, but the analysis was never completed.

a. Start Excel, open the file EX B-4.xlsx from the location where you store your Data Files, then save it as EX B-Dog Days Daycare Center Finances. The worksheet includes labels for functions such as the average, maximum, and minimum amounts of each of the expenses in the worksheet.

b. Think about what information would be important for the bookkeeping staff to know.

c. Using the Quick Analysis tool, create a formula in the Quarter 1 column that uses the SUM function, then copy that formula into the Total row for the remaining Quarters.

d. Use the SUM function to create formulas for each expense in the “Ibtal column.

e. Create formulas for each expense and each quarter in the Average, Maximum, and Minimum columns and rows using the method of your choice.

f. Compare your worksheet to the sample shown in FIGURE B-25.

g. Enter your name in cell A25, then save your work.

h. Preview the worksheet, then submit your work to your instructor as directed.

i. Close the workbook and exit Excel.

FIGURE B-25 1 A B Center c Dog Days Daycare 2 3_ 0 • eratin • Expenses for 2016 4_ 5 Expense Quarter 1 Quarter 2 6 Rent 9240 9240 7 Utilities 9000 7982 8 Payroll 23456 26922 9 Insurance 8550i 8194 10 Education 3000 3081 11 Inventory 299861 27115 12 Total 832321 82534 13 14 Average 13872_1 13755.7 15 Maximum 299861 27115 16 Minimum 30001 3081
F
Quarter 3 Quarter 4 Total 9240 9240 7229 8096
25876 8225 6552 25641
82763
29415 8327 4006 32465 91549
13793.8 15258.2 25876 32465 6552 4006

H
1 I Avera • e Maximum I Minimum
36960 32307 105669 33296 16639 115207
9240, 92401 9240 8076.75 ft 9000 7229 26417.31 29415 23456 8324 8550 8194 4159.75 6552 3000 28801.8 32465 25641
4
Your formulas formulas go here

Using the Quick Analysis tool, create a formula in the Quarter 1 column that uses the SUM function, then copy that formula into the Total row for the remaining Quarters.
Scroll to top