Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

help the class is information system in organization Rename the Excel file to TourRevenueAnalysis YourNameLastName 2. Centralize the Title of the document from column A-F

help the class is information system in organization
image text in transcribed
image text in transcribed
image text in transcribed
Rename the Excel file to TourRevenueAnalysis YourNameLastName 2. Centralize the Title of the document from column A-F 3. As they are numerical data, use the "\$" symbol in the boxes corresponding 4. For the total of column F they will add manually each cell by country is say B23+B24+B25... etc. 5. For the total of cell 12 they will use the AutoSum . 6. Using the "round" formula in cell 14 you are going to predict a 20 growth percent. For each total of each quarter. 7. Using the percent formula, determine what the average of each trimester. Remember not to use the total for the formula. 8. Using the maximum formula determine which quarter has the greatest value in your data. Remember not to use the total for the formula. 9. Using the minimum formula, determine which quarter has the value maximum of your data. Remember not to use the total for the formula. 10.Using Absolute Reference you are going to forecast a change in the totals of column F of 2.2%. Put G4 as active cell then activate formula with " = " then select cell F4 multiplied by cell H1. When they select cell H1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions