Question: in cell C1, edit the function to round the result to thr nearest penny. File Home Insert Page Layout Formulas Data Review C1 A fx

in cell C1, edit the function to round the result to thr nearest penny.

File Home Insert Page Layout Formulas Data Review C1 A fx =AVERAGE(F7:F37) A 1 Average Amount Spent at Spa 2 Number of Weddings 3 Spa Members Scheduling Weddings 4 B C D 874.6993548 5 Number of 6 Wedding Party Name Days Spent 7 Arroyo 1.52 Whole Days Spent 1 Returned Merchandise -37.34 8 Proctor 9 Minor 10 Pearce 11 Shea 2.54 2 41.12 4.32 st -12.7 4.52 4 13.97 2.50 2 18.53

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

Find the derivative of the function. y = e 2x tan 2x

Consuelo Chua, Inc., is a disk drive manufacturer in need of an aggregate plan for July through December. The company has gathered the following data: COSTS Holding cost.................$8/disk/month...

4. The Internet is simultaneously encouraging two opposing trends in organizational purchasing: (1) the growing use of short-term spot market contracts via Web-based auctions and (2) the...

Explain how a clinical psychologist could demonstrate a developmental perspective while assessing children or adolescents.

On December 31, 2016, when the market interest rate is 14%, McCann Realty issues $400,000 of 11.25%, 10-year bonds payable. The bonds pay interest semiannually. Determine the present value of the...

Lena has just become eligible to participate in her company's retirement plan. Her company does not match contributions, but the plan does average an annual return of 14%. Lena is 40 and plans to...

Home Realty, Incorporated, has been operating for three years and is owned by three investors J Doe pwrm 6 percent of the total outstanding stock of 9,000 shares and is the managing executive in...

You are required to design a shell and tube heat exchanger having a rectangular cross section as shown in figure 1 below. The heat exchanger uses water as the cooling fluid to reduce the temperature...

The Bakeoff Case Read "The Bakeoff" case and post approximately 1 page of text (about 4 paragraphs) answering the following questions SOLELY based on the case. Do not use other references. What were...

1. Determine the magnitude and direction of the force that must be applied to the bottom of the gate shown below to keep the gate closed. 3.4 m Water 1.5 m wide gate Hinge T 0.75 m

Lynda is a manager of an investment center. Her division has been performing below expectations recently because one of its larger projects has not been as successful as anticipated. Given the poor...

Question 2 Determine the first two critical speeds for the shaft shown in figure 1 below. Young's modulus for steel should be taken as 200GN/m2. Show all the calculations and state all your...

Lovitz Company is planning to produce 2,000 units of product in 2012. Each unit requires 3 kilograms of materials at $6 per kilogram and a half hour of labour at $14 per hour. The overhead rate is...

A stock has had returns of 8 percent, 26 percent, 14 percent, 17 percent, 31 percent, and 1 percent over the last six years. What are the arithmetic and geometric average returns for the stock?

3.10 List each of the major averages or indexes prepared by (a) Dow Jones & Company and (b) Standard & Poor's Corporation. Indicate the number and source of the securities used in calculating each...

3.1 Discuss the impact of the Internet on the individual investor and summarize the types of resources it provides.

3.7 How would you access each of the following types of information, and how would the content help you make investment decisions? a. Prospectuses c. Investment letters b. Back-office research...