logo Hurry, Grab up to 30% discount on the entire course
Order Now logo

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Aidan CampbellTechnical writing
(5/5)

537 Answers

Hire Me
expert
Riya ChopraComputer science
(5/5)

929 Answers

Hire Me
expert
Jacob CaleGeneral article writing
(5/5)

907 Answers

Hire Me
expert
MAHIMAStatistics
(/5)

766 Answers

Hire Me
Microsoft Excel
(5/5)

You have been asked by the director of sales and marketing at Campus Travel to help with analyzing prior sales data to design better marketing strategies.

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Microsoft Excel Exercise 1 (20 points)

You have been asked by the director of sales and marketing at Campus Travel to help with analyzing prior sales data to design better marketing strategies. The spreadsheet TicketSales.xlsx contains the ticket sales data for a 3-month period. Your director has asked you for the following information regarding ticket sales. Modify TicketSales.xlsx spreadsheet to provide the following information for your director:

The total number of tickets sold

o Select the data from the “tickets sold” column

o Then select the “autosum” function

The largest amount of tickets sold by a certain salesperson to any one location

o Select the appropriate cell

o Use the “MAX” function to calculate each salesperson’s highest ticket total in one transaction

The least amount of tickets sold by a certain salesperson to any one location

o Select the appropriate cells

o Use the “MIN” function to calculate the “least tickets sold.”

The average number of tickets sold

o Select the cells

o Use the “AVERAGE” function to calculate the “average number of tickets sold” using the same data you had selected in previous steps

 

Microsoft Excel Exercise 2 (20 points)

You have been assigned to evaluate the total cost of ownership (TCO) of a few systems that are currently in use by Campus Travel employees. Take a look at TCO.xlsx file to obtain the list of systems that are in use and the costs associated with maintaining the software, hardware, and the associated personnel for each type of system. Calculate the following for your operations manager:

The costs for server hardware by adding a new row to include web servers. This includes $4,500 for the main campus and $2,200 for the other campuses

The TCO for the entire information system used at Campus Travel (Hint: Sum all the values for all the systems together)

The TCO for servers and network components of the information system

Make sure that you format the table, including using the currency format, in a professional manner

 

Microsoft Excel Exercise 3 (20 points)

You have recently landed a part-time job as a business analyst for Campus Travel. Your manager 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. You suggest setting up one workbook to handle both functions. To complete this, you must do the following:

Open the spreadsheet FrequentFlier.xlsx. 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

Sort the frequent fliers by total miles in descending order

 

(5/5)
Attachments:

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme