tructions

Excel $2022$ Project

Excel$\_3$F$\_$Benefit$\_$Analysis

escription:

wing project, you will edit a worksheet that will be used to prepare a five$-$year forecast of the costs associated with

Perform:

To the range $A10$:$B10,$ apply Bold and Italic.

In cell $C13,$ construct a formula to calculate the annual projected employee benefit costs for the year $2021$ after the projected increase of $3\%$ is applied. Fill the formula through cell $F13,$ and then use Format Painter to copy the formatting from cell B$13$ to the range C$13$:F$13.$

In cell A$15,$ type Projected Estimates $2020$ to $2024$ and then use Format Painter to copy the format from cell A$8$ to cell A$15.$ In cell A$17,$ type Year; in cell A$18,$ type $3\%$ Increase; and in cell A$19,$ type $5\%$ Increase.

$1$

GO$22\_$XL$\_$CH$03\_$GRADER$\_3$F$\_$AS $-$ Ben

$\frac{115}{2022}$