Purchase Solution

Conditional Formatting

Not what you're looking for?

Ask Custom Question

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 introduction 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 worksheets. 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 worksheet to handle both functions. To complete this, you must do the following:
1.) Open the (attached spreadsheet). You will see a tab for customers and a tab labeled "miles flown."
2.) 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).
3.) Use conditional formatting to highlight all frequent fliers who have less than 4,000 total miles.
4.) Finally, sort the frequent fliers by total miles in descending order and print out the spreadsheet.

Purchase this Solution

Solution Summary

The solution perform conditional formatting with given data in excel.

Purchase this Solution


Free BrainMass Quizzes
Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Six Sigma for Process Improvement

A high level understanding of Six Sigma and what it is all about. This just gives you a glimpse of Six Sigma which entails more in-depth knowledge of processes and techniques.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.