All categories

2 years ago

Insert the DMAX function in cell N4 to calculate the highest sales based on the criteria entered in range G2:K3.

1 answer:

8 0

In the excel spreadsheet, the way for one to be able to calculate the highest sales based on the criteria entered in range G2:K3 is by:

First select cell N3 and then click on the formula tab. Then also select insert function and then click on Database, select DAVERAGE. Use A2:E52 as range, then do type "highest sales" and G2:K3.

<h3>What does Highest Sales implies?</h3>

Highest Sales is a term that connote the highest from of Qualifying Revenue that is gotten in course of a given period of time (1 year).

In the excel spreadsheet, there are different kinds of shortcut that are often used to make the calculations of works to be very easy.

Thus, In the excel spreadsheet, the way for one to be able to calculate the highest sales based on the criteria entered in range G2:K3 is by:

First select cell N3 and then click on the formula tab. Then also select insert function and then click on Database, select DAVERAGE. Use A2:E52 as range, then do type "highest sales" and G2:K3.

Learn more about sales from

brainly.com/question/14532771

#SPJ1

You might be interested in

As you read the essay, “Congress and the Quest for Power” by Lawrence Dodd, answer the following questions.

Morgarella [4.7K]

According to “Congress and the Quest for Power” by Lawrence Dodd, people enter politics because of their quest for power.

<h3>Dodd asserts that “reelection” is necessary for three reasons. What are these three reasons?</h3>

The three reasons why reelections are required are:

Personal Power
Aura of Personal Legitimacy
Opportunity go gain expertise and experience.

<h3>The “electoral connection” will lead members of Congress to emphasize what traits? </h3>

The “electoral connection” will lead members of Congress to emphasize :

Form over substance
Position Taking
Advertisement
Credit claiming.

<h3>What traits or actions will they begin to care about less?</h3>

The traits or actions they begin to care about less are:

Failure to take clear and controversial positions;
Failure to make hard choices
Failure to exercise power.

<h3>What motive causes each member of Congress to be in conflict with each other?</h3>

The need to exercise power for making key policy decisions.

<h3>Where do Congress members spend the most time? Why?</h3>

They spend most of their time in:

the committee or sub committee rooms
in caucus meetings; or
Office work related to legislation.

Learn more about congress at;
brainly.com/question/491441
#SPJ1

7 0

1 year ago

The seasonal product team needs a vendor who can quickly adjust to changes in product demand. The planning team has sent over a

Artyom0805 [142]

There are different kinds of vendors. The best that I can identify and recommend is Vendor V in the diagram attached.

The seasonal product team should consider taking or using Vendor V. This is because of their performance. When you look at the diagram, you will see that their performance is better in all parameter given in the table (Diagram attached).

Vendor V is in all parameters improving the performance of all the four elements and it can easily adjust to any seasonal changes.

Learn more about Vendors from

brainly.com/question/25946259

7 0

2 years ago

How should the moderator of the group respond to Donnie’s comment? She should ask him to leave the discussion and direct the gro

Citrus2011 [14]

Answer:

she should remind him of the rules for discussion and ask him to provide supporting information.

5 0

2 years ago

Healing after the death of a loved one is most difficult when:

melisa1 [442]

Answer:

The correct answer is B.

Explanation:

If the person isn't allowed to respond to death in the way they which, they may undergo a turmoil of feelings and feel trapped. Death is always hardest when you can't respond to it the way you want to.

As for the other choices, B and C would make death easier on the person. D would probably endow the person with a bit more comfort and freedom to mourn how they want to.

7 0

3 years ago

Read 2 more answers

The operation manager at a tire manufacturing company believes that the mean mileage of a tire is21,009 miles with a variance of

max2010maxim [7]

The probability that the sample mean would differ from the population mean by less than 655 miles in a sample of 79 tires if the manager is correct is = 0.9805.

<h3>

What is the calculation for the above?</h3>

P ( $\bar{x}$ < 655) ≡ P [ |( $\bar{x}$ - μ)/√(σ²/n) | <655/√(6,220,036/ 79)]

= P (| Z | < 3.55)

= P - 3.55 < Z < 3.55) Using the z -score table

= 0.9998 - 0.0193

= 0.9805

Learn more about sample mean at:
brainly.com/question/12892403
#SPJ1

5 0

2 years ago