finish the task 1

Use conditional formatting to highlight the Student ID for those students whose graduation date is on or after 12/31/2020 and the corresponging overall GPA or major GPA is above 2.0 while the other GPA is below 2.0.

Use conditional formatting to show the word “dismissal” if the overall GPA is below 0, but show the word “probation” if both GPAs are below 2 and above 1.

(hint: Use the “custom” number format to place a word in the format of a cell. Use quotation marks around text.)

Need your ASSIGNMENT done? Use our paper writing service to score good grades and meet your deadlines.

Order a Similar Paper Order a Different Paper