Question: 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

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 Select the cells Use the "AVERAGE" function to calculate the "average number of tickets sold" using the same data you had selected in previous steps O O

nalyzing prior sales data to design better marketing strategies. The spreadsheet TicketSales.xlsx ontains the ticket sales data for a 3-month period. Your director has asked you for the fWllowing nformation regarding ticket sales. Modify TicketSales.xlsx spreadsheet to provide the following nformation for your director: - The total number of tickets sold Select the data from the "tickets sold" column Then select the "autosum" function - The largest amount of tickets sold by a certain salesperson to any one location Select the appropriate cell 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 Select the appropriate cells Use the "MIN" function to calculate the "least tickets sold." - The average number of tickets sold Select the cells Use the "AVERAGE" function to calculate the "average number of tickets sold" using the same data you had selected in previous steps

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

2.23 Cost of capital (40%) Calculate the company?s cost of equity using various methods (at least 2); showing your calculations and detailing the source of your data. Calculate the company?s cost of...

Micro Tiles Limited In June of 2014, Bill Madden considered expanding his micro tiles business. He planned to invest $2.0 million in 2016 to produce more and better-quality plaster or metal tiles and...

Just one part of the assignment, Thank you! 2.22 Risk-return analysis (40%) What are the risks of this company? (Where is this risk coming from (market, firm, industry or currency)? How is the risk...

Please note that this individual assignment. Part 1: Using the provided excel workbook TicketSales, answer the application exercise 1-34, page 70. For those who didn't get their books yet, the...

\ table [ [ Date Sold,Salesperson,Destination,Tickets Sold,, ] , [ 2 1 5 ? 2 2 , Lisa,France ( Paris and Nice ) , 3 , , ] , [ 3 4 ? 2 2 , Bob,Hungary and Poland, 2 , , ] , [ 1 2 8 ? 2 2 ,...

Module 1 : Spreadsheet Application: Ticket Sales at Campus Travel The local travel center, Campus Travel, has been losing sales. The presence of online ticketing websites, such as Travelocity.com and...

Students will be provided an IMC strategy document for an existing business and, within the context of the business's growth strategy, will develop an analysis of the effectiveness of the IMC...

Financial Analysis Exercise #1 (100 Points) This exercise will require both a written and Excel spreadsheet component. It is critical to demonstrate the appropriate Excel skills. There are 10 mini...

Instructions on how to submit the Assignment Download the Assignment to your computer. Fill in the blanks. Use BLUE BLUE BLUE BLUE BLUE Ink! (Same shade Blue as this) Blue ink helps me differentiate...

1. How many kinds of mutations can occur? 2. How do point mutations occur? 3. What are the characteristics of a mutation?

The spot rates, 3- month forward rates and 3-month future (speculation) spot rates for the MYR respectively are as below: Buy Sell MYR/$ Spot 4.5311 4.6311 3-month Forward 4.5445 4.6445 3-month...

The tone or culture of a firm: "the control environment sets the tone of an organization, influencing the control consciousness of its people." Question 8Select one: a. Ongoing monitoring b. Risk...

2. Articles on Public-Sector Unionism. The Public Service Research Foundation, a private nonprofit organization, makes available papers and pamphlets that address a variety of issues related to...

2. Since the Priority Consideration under Article 22, Section 13 is included by the parties as a solution to a selection violation, is this priority selection the proper remedy? Why? Why not? At the...

3. What would be your ruling if the plant in Memphis had no union? Explain. TerryWilliams is an employee at a unionized plant in Memphis, Tennessee. Williams is a member of and represented by Local...