Solved by Expert Tutors
Solved by Expert Tutors
Question

I have project to finish, I need help. Please see an attachment. Thank you.

Instruct Step
Background image of page 01
tions for Assignment 5 a. Freeze the panes (both directions) at cell B2. b. Calculate the average homework grades c. Calculate the total quiz points and subtract the lowest quiz grade d. Calculate the numerical grade with the following: Homework Average * 70% Quiz Average * 20% Final Exam * 10% e. Name the range of the Grading Table (to use in the next step). f. Use a VLookUP function with the grading table to display the letter grade. g. Calculate averages for the following: Average grade for all homework assignments Average grade for all quizzes Average grade for all final exams Average overall numerical grade Average overall letter grade a. Display the average grade for all homework assignments for classes 1 and 2 b. Display the average grade for all quizzes for classes 1 and 2 c. Display the average grade for all final exams for classes 1 and 2 d. Display the average grade for the overall numerical grade for classes 1 and 2 e. Display the average grade for the overall letter grade for classes 1 and 2 f. Display the average of both classes for all columns. c. Create a Pivot Chart with the same data (on a separate sheet). d. Copy the Faculty Data worksheet information and paste it on a new sheet called Subtotals. e. On the Subtotals sheet, sort the data by faculty rank. f. Add subtotals (sorting by rank) for salaries. 5. Save all the changes on this workbook and upload your final product to Blackboard. 1. Complete the following on both the class 1 and the class 2 worksheets: 2. Complete the following on the Summary worksheet: 3. Complete the following on the Faculty Data worksheet: a. Use an IF function to calculate the amount matched (3% of salary) if the faculty member participates in the retirement plan. If not, display 0. b. Create a Pivot Table with the faculty data (display the pivot table on a separate sheet). The pivot table should show the relation between gender and rank. 4. Import the newFaculty.xml file into a new worksheet named New Faculty.
Background image of page 02
Show entire document

Step-by-step answer

or nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus a

a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vitae odio. Donec aliquet. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet.

Subscribe to view the full answer

Other answers

sus ante, dapibus a molestie consequat, ultrices ac magna. Fusce d



, consectetur adipiscing elit. Nam lacinia pulvinar tortor nec facilisis. Pellentesque dapibus efficitur laoreet. Nam risus ante, dapibus a molestie consequat, ultrices ac magna. Fusce dui lectus, congue vel laoreet ac, dictum vita

Subscribe to view the full answer

Subject: Accounting, Business

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Let our 24/7 Accounting tutors help you get unstuck! Ask your first question.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes