Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Human Resource Management

Authors: John Ivancevich, Robert Konopaske

12th edition

9780077496906, 78029120, 77496906, 978-0078029127

More Books

Students also viewed these Accounting questions