Use an appropriate function to enter the letter grade in column F based on the following scale:

$90\%$ and above $-$ A

At least $80\%$ but less than $90\%-$ B

At least $70\%$ but less than $80\%-$ C

At least $60\%$ but less than $70\%-$ D

Less than $60\%-$ F

Create a PivotTable on this tab showing the count of each Letter Grade by Academic Level.

Format the PivotTable in Tabular form such that the letter grades are the row labels and the academic levels are the column headers.

Adjust your PivotTable so that blank cells show as $0.$

$($You may create a new worksheet for your PivotTable or place it in this sheet. If you create a new sheet, be sure to label it clearly.$)$