Microsoft Office Tutorials and References
In Depth Information
Apply Your Knowledge
Reinforce the skills and apply the concepts you learned in this chapter.
Proﬁ t Analysis Worksheet
Instructions Part 1: Start Excel. Open the workbook Apply 2-1 Car-B-Clean Proﬁ t Analysis. See
the inside back cover of this topic for instructions for downloading the Data Files for Students or see
your instructor for information on accessing the ﬁ les required in this topic. The purpose of this exercise
is to open a partially completed workbook, enter formulas and functions, copy the formulas and
functions, and then format the worksheet titles and numbers. As shown in Figure 2–84, the completed
worksheet analyzes proﬁ ts by product.
Perform the following tasks.
1. Use the following formulas in cells E4, F4, and G4:
Total Sales (cell E4) = Units Sold * (Unit Cost + Unit Proﬁ t) or =D4 * (B4 + C4)
Total Proﬁ t (cell F4) = Units Sold * Unit Proﬁ t or = D4 * C4
% Total Proﬁ t (cell G4) = Total Proﬁ t / Total Sales or = F4 / E4
Use the ﬁ ll handle to copy the three formulas in the range E4:G4 to the range E5:G12.
2. Determine totals for the units sold, total sales, and total proﬁ t in row 13. Copy cell G12 to G13 to
assign the formula in cell G12 to G13 in the total line.