Complete the attached Excel Student File to look like the screenshot below.

a$.$ Add SUM formulas to Column F and Row $8.$

b$.$ Create a Clustered Column chart based on the Range A$3$:E$7.$

i$.$ You can adjust the color scheme as you wish, but match everything else to the screenshot.

c$.$ Save the file as firstnamelastnamePR$1.$

Figure $1$: Screenshot of Project $1-$ Part B