Question: Update this spreadsheet to provide the following information: 1 ) Use the XLOOKUP function to update Column E with miles flown by looking up the

Update this spreadsheet to provide the following information:
1) Use the XLOOKUP function to update Column E with miles flown by looking up the frequent flyer number
on the "Miles Flown" tab
2) Format the "Miles Flown" column using "Comma Style" with no decimal places
3) Use conditional formatting in Column E to highlight in red the miles flown of all frequent fliers who have
less than 4,000 total miles
4) Sort the frequent fliers by total miles in descending orde

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!