You have recently landed a part-time job as a business analyst for Campus Travel. In your first meeting, the operations manager learned that you are taking an introductory MIS class. As the manager is not very proficient in using office software tools, he is doing all frequent-flier mileage in two separate Excel workbooks. One is the customer’s contact information, and the second is the miles flown. Being familiar with the possibilities of spreadsheet applications, you suggest setting up one workbook to handle both functions. To complete this, you must do the following:

■ Open the spreadsheet frequentflier2.csv. You will see a tab for customers and a tab labeled “miles flown.”

■ Use the vlookup function to enter the miles flown column by looking up the frequent-flier number. (Hint: If done correctly with absolute references, you should be able to enter the vlookup formula in the first cell in the “miles flown” column and copy it down for all the cells.)

â–  Use conditional formatting to highlight all frequent fliers who have less than 4,000 total miles.

â–  Finally, sort the frequent fliers by total miles in descending order.

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
Looking for a Similar Assignment? Our Experts can help. Use the coupon code SAVE30 to get your first order at 30% off!