Completing this activity will help you learn to:

create Excel formulas uling cell reberences:

create absolute cell references to perform colloulations eftidiently and comecthy.

apptr consitional formming to highligate cells based on citeria that you specty.

Requlred:

Dowilsad spreadshet Commonstrecasebata$-2$tahab.alax

HINT: STEP$-$QY$-$STE w$$LKTHROUGH$,$

have to dra.

$-$Financil Statement $0$ata'is$82/$Finandial Statement $6$ata'i$62$

b$.$ Copy and paste that one formula to all the relevart cells in wour new aheet. Roond wour angwers to two decimal places.

Instead of creating every fosther new sheet bo perform the vertical analyin, comparing each years item to that year's net sales

formila.

:

The correct theet is

Explain the use of the common size financial statements. If you were a manager, which area would require further analysis?

The input in the box below will not be graded, but may be reviewed and considered by your instructor.