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.

Figure 2–84

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.

Continued >