Mi Inbox $(279)-$sdcourtneyholcro

Home $|$ MyRSU

LTI Launch

Excel Challenge $3-$ SIMnet

rsu.simnetonline.com$/$sp$/$assignments$/$projects$/$details$/8714730$

Do the same for Total Units $($cell B$6)$ and Total Cost $($cell B$9).$

Compute the Average Cost Per Unit by dividing the Total Cost $($cell B$8)$ by the Total Units $($cell B$6).$

In cell B$14,$ enter a formula using a statistical function to calculate the most paid for any semester. Reference cells $B17$ and $B23$ in the GPA sheet. Hint: You will need two arguments.

e$.$ In cell B$16,$ enter a formula to sheet. Hint: You will need two calculate the two arguments. if the GPA in B$5$ is greater than or will determine if the GPA Goal should be "Yes" and the Val or equal to the GPA goal in F$5.$ The was met. The Logical Test needs to determine

g$.$ In cell F$2,$ determi, enter an IF function that will determine B$6>$ B$6$ F$6.$ The Value if True should greater than or equal to thequirement was met. The Logical Test needs to should be "Yes" and the Value if the # of units required in F$6.$ This is written as

a$.$ In cells B$7$ History worksheet. $2020$ GPA and B$8,$ enter simple $2020$ GPA on the GPA worksheet

Create a $2-$D$.$

to reference the cells that contain the Fall $2019$ GPA and the Winter Move and resize the chart so the chart of the GPA History line

Change the chart title to to top left corner is in cell $D1$ story. Hint: select $A3$:$B8$ as the data range for the chart. Apply Style $2.$

$5.$

History.