Explore BrainMass
Share

Conditional Formatting

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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.

© BrainMass Inc. brainmass.com October 25, 2018, 5:00 am ad1c9bdddf
https://brainmass.com/business/management-information-systems/conditional-formatting-403221

Attachments

Solution Summary

The solution perform conditional formatting with given data in excel.

$2.19
See Also This Related BrainMass Solution

Accounting Information Sysytem

See the attachment.

Jessica, the financial manager at Chila restaurant, is checking to see if there is any relationship between newspaper advertising and sales revenues at the restaurant. She has accumulated the following data for the past 10 months:
Month Revenues Advertising Costs
March $150,000 $20,000
April 170,000 30,000
May 155,000 15,000
June 165,000 35,000
July 155,000 10,000
August 165,000 20,000
September 145,000 15,000
October 180,000 40,000
November 155,000 25,000
December 160,000 25,000

Required:
a. Use Excel's regression features to determine the regression line. What is the increase in revenues for each $1,000 spent on advertising? Use Excel's built-in function to determine the R-squared value for this regression line.

b. Use Excel's conditional formatting feature to place borders around all months with sales greater than $150,000.

c. Would you recommend that Chila continue advertising? Why or why not? Using Word and an appropriate memo format, write a short (1-2 paragraph) memo to Jessica summarizing your recommendation and the reasons for your recommendation. Grammar counts.

View Full Posting Details