Question: 2. Get ready Use spreadsheet software to open the WhatIf file. 3. Now you try it 1. Click cell E14 , click the Data tab

2. Get ready

Use spreadsheet software to open the WhatIf file.

3. Now you try it

1. Click cell E14, click the Data tab, click the What-If Analysis button, and then click Goal Seek.

2. Click the To value box,type 4,637,500, click the By changing cell box, click cell E13, and then click OK twice.

What is the average price per trip if Quest sells 12% business trips?

What is the future revenue from sales if Quest sells 12% more trips?

she doesn't provide any excel data..so i dont know ):

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 Finance Questions!

Q:

Find Type your name Objective Performing What If 37 Part 5 Analyses Practice performing what-if analyses by using Microsoft Excel's what if analysis tools. Complete the following steps. You Try It 1....

Q:

2. Get ready Use spreadsheet software to open the Factors file. 3. Now you try it 1. Select the cells C11:C14 , press [Ctrl]+[C] to copy the formulas, select cells D11:F14 , then press [Ctrl]+[V] to...

Q:

Problem This problem is a continuation of Sample Problem 2-S. You will enter the general journal entries for the month of December of the current year and complete the end-of-fiscal period...

Q:

Problem This problem is a continuation of Sample Problem 2-S. You will enter the general journal entries for the month of December of the current year and complete the end-of-fiscal period...

Q:

Question 1 0 / 1 0 Submit Video Question Content Area Introduction When conducting analysis in Excel for business related problems, you will likely encounter the data type of "date" quite often. Many...

Q:

Introduction When conducting analysis in Excel for business related problems, you will likely encounter the data type of "date" quite often. Many elements of business are tied to dates. As such,...

Q:

My assignment for fraud Accounting class. All instructions are in attached files. VENDOR_NAME USERID Air Freight Corp TBK Coffee Serivce TBK Computer Store TBK Copy Machine Service TBK Cosmos Pizza...

Q:

PLEASE HELP! THANKS! Steps to Perform: Points Possible Step Instructions 1. Run a regression analysis using data for January through July. Determine the company's cost equation (use the output from...

Q:

Your supervisor in the finance department at Adaptive Solutions Online has asked you to create a worksheet for the flagship product that will project the annual gross margin, total expenses,...

Q:

Excel Activity: Evaluating Risk and Return Bartman Industries's and Reynolds Inc.'s stock prices and dividends, along with the Winslow 5000 Index, are shown here for the period 2015-2020. The Winslow...

Q:

Rob McNab ordered 18.3 square meters of carpet for his halls, 123.5 square meters for the bedrooms, 28.7 square meters for the family room, and 12.9 square meters for the playroom. Find the total...

Q:

Gregorian and Boudicca each have incomes of $30 and each shop at Star Market, where apples cost $2 each and bananas cost $1 each. Every day, Gregorian buys 6 apples and 18 bananas, and so does...

Q:

8 a Sort these cards into groups of equivalent expressions. b Which card is in a group on its own? A 3xx 4 x+3 B C 4 4 x x D Exx 3 34 FL G+ 3.x 4x 3+x +X H I J 4 3 4

Q:

A company is preparing completing their Cash Budget. The following data has been prepared for cash receipts and payments. January February March Cash receipts $1,061,200 $1,182,400 $1,091,700 Cash...