INT 1010 assignment 7

  Please complete the steps below and upload your Excel workbook assignment under Chapter 7 Assignment Submit Here. Open a blank Excel workbook Create the following headers in row 1 Class Date Topic of the week Assignment Due Date Possible Points Points Earned Grade Format Class Date column with MM/DD/YY format Format Due Date column with MM/DD/YY format Format Possible Points column as a Number with 0 Decimal Places Format Points Earned column as a Number with 0 Decimal Places Format Grade as a Percentage with two decimals The calculation for the grade column is Points Earned divided by Possible Points.  Complete for each topic. (use formulas) Enter a Row for assignment per the detailed schedule Enter all the Points Earned in the Points Earned Column (use formulas) Calculate the Grade for each Points Earned in the Grade Column (use formulas)  Add the sum of the column labeld Possible Points (use formulas) Add the sum of the column labeld Points Earned (use formulas) The Grade Column is the calculation for the sum of all Points Earned divided by the sum Possible Points (use formulas) Save the file as Excel_Database_StudentFirstandLastName and submit.