Answered step by step
Verified Expert Solution
Question
1 Approved Answer
1. There are five homework assignments worth 25 points each and three exams worth 100 points each. Grades are computed using a weighted scale.
1. There are five homework assignments worth 25 points each and three exams worth 100 points each. Grades are computed using a weighted scale. The homework is worth 35% and the exams are worth 65% of the grades respectively. Complete the worksheet that calculates a final grade for the students and allows for the grade weights to be changed. The grades are based on percentages like 90% or 80% so there will need to be a conversion of the homework to match the value of the exams (see videos). 2. Complete a budget. There are two columns, expected and actual. Expected is what you thought you were going to receive. Actual is what you actually received (you make up the numbers in both columns). After completing the income and expenses in both columns, subtract the expected from the actual to determine the difference (it will be a positive or negative number). Once you determine if you have a negative or positive number, create an IF statement that will tell you if you are over budget or under budget using the words "over budget" or "under budget". If you are underbudget the number in the difference should be negative. If you are over budget the number in the difference should be positive. Finally, create totals for the income and expenses (expected and actual) using a function that adds the numbers (do not use a =a1+a2+a3 formula). 3. On the spreadsheet tab named Conditional Formatting, highlight in purple all 2nd quarter revenues and highlight in yellow all 4th quarter revenues. - using conditional formatting not the paint can or highlighter. Assignment spreadsheet Excel 1-2022.xlsx Course C
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started