Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

x eBook: How to Use Microsoft Ex X + structure.com/courses/17433/assignments/388636 on-2.docx 16 17 18 19 20 21 22 Download Page < On the Faculty Data

x eBook: How to Use Microsoft Ex X + structure.com/courses/17433/assignments/388636 on-2.docx 16 17 18 19 20 21 22 Download Page < On the Faculty Data Exam worksheet, sort the table data by Department, then by Rank, both in ascending order. Insert a comment in cell J3 with the text Matching Rate Should Be Raised! Use Find & Replace to replace all instances of Full with Full Professor in the Rank column. AutoFit the width of column D. Use the Quick Analysis tool to insert Data Bars in the Salary column. Change color of the data bars to Blue (under Gradient Fill). In cell J3, use the IF function to calculate the retirement matching for each faculty member participating in the retirement plan. For participating members, the function should multiply their salary by the retirement matching percentage. For all other members, the function should return 0. Be sure to make the reference to cell J1 an absolute reference in the function. Use the fill handle to copy the function down through the column. Apply the currency format to the values. Display the Faculty Data worksheet, and then create a table with headers using the data in the range A2:J8. Change the name of the table to FacultyData. Sort in ascending order by YearHired, and then filter the table to show only those faculty hired between 1982 and 1985. Using

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Students also viewed these Accounting questions