Hide Assignment Information

Recommend to complete before midterm. Some parts we will cover on Oct.19.

3 Marks

Purpose: Complete functions/formulas in excel spreadsheet Recruiter.xlxs

1.) Download Spread sheet Recruiter2021.xlxs off Nexus. It is located below.

2.) On sheet Client sheet find the following for column G entitled “Amount Paid”:Highest Amount PaidLowest Amount PaidAverage Amount PaidThe Total Amount paidThe total amount paid for all clients who are from “Berridge”. Do not sort the data.Note above all highlighted in yellow.

3.) Client sheet- In column J determine for each row if the Client has paid more than 10k and has a Current Due of 0. If so display “Gold Client” else display “Regular Client” in column J.

4.) Client sheet- Modify column I (in grey) recruiter number so that if the recruiters number changed on the Recruiter sheet it would also update on the Client sheet.

5.) Client sheet- For any Client who owes more than 40k (Current Due) highlight in red via a conditional formatting rule for that column.

6.) Client sheet- Merge and center title “Clients”.

7.) City sheet- On the City worksheet show the total Current Due for each City.

8.) Paid sheet- On Paid sheet create a 3D column chart like on the Chart tab.

9.) On the Lookup sheet use a vlookup to get Amount Paid value from the Client worksheet.