If Function $(15$ points$)$

Download the file $-$ BonusPay$-1.$xlsx ubrace$(darrubrace)$

In C$4$ create an IF function that determines if the sales representative

gets a bonus this month. Return a Yes for a bonus, No if no bonus. Bonuses

are awarded for sales greater than $60,000.$ Copy the function to the

remaining cells in the column.

In D$4$ create an IF function that determines the dollar amount for a bonus.

If Yes is in C$4,$ calculate the bonus $\%$ shown in G$2($HINT: Use absolute cell

reference$)$ of the sales from column B$4.$ Return a $0$ if there is no bonus.

Copy the formula to the remaining cells in column $D.$

Set to Landscape. Place your name in cell A$13.$

Create a new worksheet called formulas. Copy the original worksheet to the

new worksheet. Expose the formulas on the new worksheet $-$ fit it to one

page, landscape.

Make a third worksheet and copy the first worksheet to it$.$ Call it changed

value. Change the value in G$2$ to $5\%$ and save the results as Mod $5-3$Excel$-$

Bonuspay$-$Yourname.