Question: Create a worksheet that calculates your average for this class for all 8 assignments past and future. The point values can be found in the

Create a worksheet that calculates your average for this class for all 8 assignments past and
future. The point values can be found in the course syllabus. Add your own personal data that
has been graded through at least 3/18/23. You can then either temporarily enter 0% or 100%
for the rest of your grades whichever you prefer.
There are many possible ways of setting this spreadsheet up, but it must be professionally
formatted so that it is easy to follow, clearly labeled, displays correct results, and demonstrates
that you know how to correctly format an Excel table and cells, use Excels adding and percent
formulas correctly, and use cell references in your formulas. At a minimum, this worksheet must
include the following:
(1) a cell for each of the 8 graded assignments
(2) an Excel-calculated percentage for your points earned on every assignment versus the
assignment value (with the cell formatted in percent form to 1 decimal place)
(3) an Excel-calculated total for all your points earned
(4) an Excel-calculated percentage for your total points earned on each assignment (with the
cell formatted in percent form to 1 decimal place), and
(5) a letter grade based on that percentage and the grading scale shown in the syllabus

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!