1
2	Rename sheet 1 to Grades and change the sheet tab colour to Blue
3	In D1 enter the system date. Format the date to the 2020-12-30 style.
4	Merge and Center D1:S1
5	In D1 apply a Heading 2 style, change the font to Times New Roman, and change the text size to 20
6	In D1 change the fill to any colour Lighter 80% and change the text colour to any colour Darker 50%
7	For row 1 change the height to 40 pts
8	For column B change the width to 20 pts
NOTE: Make sure to Copy all formulas down to row 9
9	Calculate the average review marks in cell H5 using the appropriate function.
10	Calculate the average assignment mark in cell L5 using the appropriate function.
11	In O5 entering a formula containing absolute cell references to calculate weight for the average review mark using the weight in O4
12	In P5 entering a formula containing absolute cell references to calculate weight for average assignment marks using the weight in P4

In Q5 calculate the final Marks

In R5 show the Scholarship Money using the Students Scholarship ID & Scholarship Table.

Using the IF fuctiontion in Cell S5. If the Final Mark is greater than 60, multiply the Scholarship Money by 2. otherwise, show 0 (zero))

Format R5:S9 as currency

Apply a conditional formating to R5:R9 that will highlight the amount greater than 100 as Red fill with dark Red text

In Z4 calculate the total Scholarship Money (S5:S9)for the class

In Z5 calculate the average Scholarship Money (S5:S9) for the class

In Z6 calculate the lowest Scholarship Money (S5:S9) for the class

In Z7 calculate the highest Scholarship Money (S5:S9) for the class

Calculate the AVERAGE for each column in the cells D10:P10. -Format the as Total cell style, with no decimals

Select B2:S9 format with Thick Outside Border

The Blackboard Gradebook Average Review Mark Assign 1 Assign 2 Assign Weight for Average Review Average Weight Weight Assignment for test 1 for test 2 Mark 15% 25% Weight for Average Assign. Mark Adjusted Scholarship Money Student Name Scholarship Money Scholarship ID 100 100 100 100 100 100 100 20.0% 40.0% Final Mark Bhua, Li BR125 77 50 100 100 50 100 6 11.6 12.5 Hatt, Jerimiah BR124 37 0 0 37 0 100 100 100 5.6 0.0 Brown, Fred BR123 25 100 90 100 100 80 100 3.8 25.0 1 Rajdeep, Singh BR125 80 50 90 50 0 0 80 100 12.0 12.5 Jang, Lin BR123 56 50 56 50 100 0 100 8.4 12.5 Scholarship Table Scholarship Scholarship Eligible Money Scholarship ID BR123 60.00 $100 BR124 $200 60.00 BR125 $300 60.00 Statistics (Adjusted Scholarship Money) Scholarship Money Total Scholarship Money Average Scholarship Money Lowest Scholarship Money Highest Scholarship Money The Blackboard Gradebook Average Review Mark Assign 1 Assign 2 Assign Weight for Average Review Average Weight Weight Assignment for test 1 for test 2 Mark 15% 25% Weight for Average Assign. Mark Adjusted Scholarship Money Student Name Scholarship Money Scholarship ID 100 100 100 100 100 100 100 20.0% 40.0% Final Mark Bhua, Li BR125 77 50 100 100 50 100 6 11.6 12.5 Hatt, Jerimiah BR124 37 0 0 37 0 100 100 100 5.6 0.0 Brown, Fred BR123 25 100 90 100 100 80 100 3.8 25.0 1 Rajdeep, Singh BR125 80 50 90 50 0 0 80 100 12.0 12.5 Jang, Lin BR123 56 50 56 50 100 0 100 8.4 12.5 Scholarship Table Scholarship Scholarship Eligible Money Scholarship ID BR123 60.00 $100 BR124 $200 60.00 BR125 $300 60.00 Statistics (Adjusted Scholarship Money) Scholarship Money Total Scholarship Money Average Scholarship Money Lowest Scholarship Money Highest Scholarship Money