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
CS 340 Milestone One Guidelines and Rubric Overview: For this assignment, you will implement the fundamental operations of create, read, update,
Retail Transaction Programming Project Project Requirements: Develop a program to emulate a purchase transaction at a retail store. This
7COM1028 Secure Systems Programming Referral Coursework: Secure
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
CS 340 Final Project Guidelines and Rubric Overview The final project will encompass developing a web service using a software stack and impleme
