Question: In cell G10, create a formula that uses the AVERAGE and ROUND functions to calculate the average of cells C10:F10 and round the result to

In cell G10, create a formula that uses the AVERAGE and ROUND functions to calculate the average of cells C10:F10 and round the result to 1 decimal place. Copy the formula you created to the range G11:G15.

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

In cell G 1 create a formula that uses the average in round functions to calculate the average of cells C 1 0 through F 1 0 and round the result to one decimal place copy the formula you created to...

In cell G16, create a formula that uses the AVERAGE and ROUND functions to calculate the average of the range G10:G15 and round the result to 1 decimal place. Copy the formula to cell H16. In cell D21

12. In cell B13, create a formula that uses the ROUND and AVERAGE functions to calculate the average of Quarter 1 orders (the range B5:B10) and round the result to 0 decimal places. Fill the cells...

How to write a formula that uses the AVERAGE and ROUND functions to calculate the average of cells A10:D10 and round the result to 1 decimal place.

in cell g 1 0 create a formula that uses average and round functions to calculate the average ot cells C 1 0 :F 1 0 and round the result to 1 decimal place. copy the formula uou created to the range...

Please tell me how to get the right answer, thank you! 16 VLOOKUP X =($B6-$B5-$B7) *$B8 17 A18 B C D E F G H 6/6 19 1 20 Scrubway Peripherals Profit Projections 21 2 7/7 w N 22 23 24 7/7 25 26...

YO_Excel16_BU02_PS4_v2 Project Description: Painted Paradise Resort and Spa periodically surveys guests prior to departure. You have been asked to assist with the analysis of survey data. To assist...

Problem Data File needed for this Case Problem: NP_EX_11-6.xlsx Computer Discount Essentials Jamere Carter manages inventory for Computer Discount Essentials. Part of Jamere's job is to monitor the...

ofrom the SAM website. PROJECT STEPS 1.Ying Chou is an intern with the Sandhills-Sand River Water District. Ying has collected data on precipitation and reservoir storage and wants to use Excel to...

Mrs. Sheela spends 18% of her monthly income for the children's education. She spends 32% of her monthly income in household expenses and 12% in travelling. She spends 55% of the remaining amount in...

Line x = 3, z = -1 carries charge 20nC/m while the plane x=-2 carries charge 4nC/m. Find the force on a point charge-5 mC located at the origin.

ST Farms have $ 5 8 0 , 0 0 0 of assets and $ 2 7 5 , 0 0 0 of liabilities. Their tax rate is 3 0 % . Their costs of debt and equity are 9 % and 1 2 % , respectively. What is ST Farms weighted...

Suppose that a committee is studying whether or not there is waste of time in our judicial system. It is interested in the mean amount of time individuals waste at the courthouse waiting to be called...

1. The producers said the WGA wasnt bargaining in good faith. What did they mean by that, and do you think the evidence is sufficient to support the claim?

2. The WGA did eventually strike. What tactics could the producers have used to fight back once the strike began? What tactics do you think the WGA used?

5. Explain the supervisors role in safety.