Question: If you enter the formula = AVERAGE ( B 1 0 :B 1 8 ) into a cell and insert two rows between rows 1

If you enter the formula =AVERAGE(B10:B18) into a cell and insert two rows between rows 12 and 13, the formula will now read
=AVERAGE(B12:B20)
=AVERAGE(B10:B12,B15:B20)
=AVERAGE(B10:B20)
=AVERAGE(B10:B18)

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!

Q:

QUESTION 2 [20 Marks] The Pines Cottage is a luxury holiday cottage set in the heart of pretty Burford in Oxfordshire. It was established by Harry and Megan over ten years ago. This property has...

Q:

Preview Your objective is to develop a simple payroll spreadsheet application for the employees of a French bakery. Background: Jack and his wife Susan own a small French bakery in Chula Vista,...

Q:

I need help answering this excel assignment. Accounting Information Systems Office 2013 - myitlab:grader - Instructions Exploring Series Vol. 2 Multiple-Sheet Workbook Management Project Description:...

Q:

plz show work and formula used thanks B D E F G H 1 2 Loan Payment Calculator 44454 Rate Charles Street Term in Months 1150000 Monthly Payment 230000 Total Interest =(1-Down_Payment/Price)*Price...

Q:

0/6 Create a formula using a function. 5. In cell D, enter a formula without using a function that multiples the Monthly_Payment (cell D6) by the Term_in_Months (cell D5) and then subtracts the...

Q:

Dear Tutor, I need some help with my Accounting assignment. Let you know that company A is Michael Hill (MHJ), and company B is Blackmores (BKL) I have already attached three documents: 1) ACCT7101...

Q:

Project Description: You have volunteered to be the statistician for your high school?s football team. As part of your assignment you will organize, and present statistics to the coach. Currently the...

Q:

someone please help me with this project by step by step explaining. 1. Open the start file EX2019-SkillReview-6-2. The file will be renamed automatically to include your name file name if directed...

Q:

are these answers correct? please help correct them if they're wrong AutoSave OF A APO... Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 12 AA 2 Wran...

Q:

Help im not the best at excel. \begin{tabular}{|c|c|} \hline 1. & \begin{tabular}{l} Adjust column width until all column headers are correctly visible (don't \\ waste unnecessary space in the column...

Q:

Repeat the directions of Exercise 6 with the same vector w but with Exercise 6 Consider the bases B = {u1, u2} and Bʹ = {v1, v2} for R2, where (a) Find the transition matrix from B' to B....

Q:

Drawing on material covered during this term, make an investment analysis in PowerPoint format for your assigned company (see below). Begin your presentation with a "Buy", "Hold", or "Sell"...

Q:

Blaine Medical Center has seen a growth in patient volumes since its primary competitor decided to relocate to a different area of the city. To accommodate this growth, a consultant has advised...

Q:

Question 1 0 1 pts Company sales are increasing each month. You know that this is positive, but your company does not have the capability to increase inventory at the same rate that sales are...

Q:

10. We look at opportunities through internal lenses rather than starting with customers needs and problems. (para. 3)

Q:

6. We do not have a standard process to nurture the development of new ideas.

Q:

8. Managers are not trained to be innovation leaders.