Question: 1 . In cell J 1 0 , create a formula without using a function that divides the value of cell I 1 0 by

1. In cell J10, create a formula without using a function that divides the value of cell I10 by the value of cell H10. Copy the formula you created to the range J11:J15.
2. 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.

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!

Q:

Cortona University assigns each donation to a level of Gold, Silver, or Bronze depending on the pledge amount. Display the donation level using a nested IF function as follows: In cell H5, insert a...

Q:

What is the answer for this question... I already use this formula but it didn't work IFERROR(B5/$B$11,0%). Data Change the number format. Jane wants to calculate the percentage each type of gift...

Q:

Change the number format. Jane wants to calculate the percentage each type of gift contributed to the total amount of gifts. To avoid a divide by zero error in the calculation, she wants to make the...

Q:

Final Figure 1: Product Lookup Worksheet H You've Got Style 4/25/2016 10.48 shirt Blouse 160 Pecking Weight (oz.) Bored Set 6 Pants/shorts 252 Item Court 7 Dress/Skirt 96 # of Components S Sweater...

Q:

Danilo Lewellen is an entrepreneur planning to manufacture and market an innovative handheld controller for virtual reality gaming. Danilo is building a business plan as he recruits investors and...

Q:

Hello! I am trying to figure out how to input this into excel but no matter what I try I cannot it correct. Much appreciated if I could get some instruction on this 5. Kaleen now wishes to finalize...

Q:

please help with the formula needed for this question? 10. Jane wants to calculate the percentage each type of gift contributed to the total amount of gifts. To avoid a divide by zero error in the...

Q:

9. Go to the Quarter 3 Gifts worksheet. Apply the Accounting number format to the gift amounts (the range B5:B11) to indicate they are dollar amounts. 10. Jane wants to calculate the percentage each...

Q:

Jane wants to calculate the percentage each type of gift contributed to the total amount of gifts. To avoid a divide by zero error in the calculation, she wants to make the calculation using the...

Q:

please provide the formaulas thank you 9. Go to the Quarter 3 Gifts worksheet. Apply the Accounting number format to the gift amounts (the range B5:B11) to indicate they are dollar amounts. 10. Jane...

Q:

The method of instruction in college and university applied statistics courses are changing. Historically, most courses were taught with an emphasis on manual calculation. The alternative is to...

Q:

During electrolysis of aqueous copper (II) sulphate 144750 columbus of electricity were used. Calculate the mass of copper metal that was obtained (CU= 64) (1 Faraday = 96500 Columbus)

Q:

4. What does the Peek method return when the end of the file is reached? a. 1 b. 0 c. the last character in the file d. the newline character

Q:

Write the number in standard form Then write the number in scientific notation The wireless subscriber connections in a country at year s end 2015 were 238 8 million The number in standard form is...