Int 1010 assignment 7 | INT 1010 | Prince George’s Community College

  Please complete the steps below and upload your Excel workbook assignment under Chapter 7 Assignment Submit Here.Open a blank Excel workbookCreate the following headers in row 1Class DateTopic of the weekAssignmentDue DatePossible PointsPoints EarnedGradeFormat Class Date column with MM/DD/YY formatFormat Due Date column with MM/DD/YY formatFormat Possible Points column as a Number with 0 Decimal PlacesFormat Points Earned column as a Number with 0 Decimal PlacesFormat Grade as a Percentage with two decimalsThe 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 scheduleEnter 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.

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *