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

Eddie collected data about his friends’ favorite candy bar. He found that 7/42 liked snickers. In his pie graph this would repre

zaharov [31]

B) 60 because all you need to do is part / whole = degrees/360 so 7/42=degrees/360 then cross multiply and divide 7x360/42= 60 degrees

7 0

3 years ago

Read 2 more answers

What are the main two sources of a natural fibres?

pentagon [3]

Natural fibres can be classified according to their origin. The vegetable, or cellulose-base, class includes such important fibres as cotton, flax, and jute. The animal, or protein-base, fibres include wool, mohair, and silk. An important fibre in the mineral class is asbestos.

5 0

3 years ago

In the pillbug experiment, your hypothesis

riadik2000 [5.3K]

In the pillbug experiment, your hypothesis was related to the environment Pillbugs prefer. This is further explained below.

<h3>What is a pillbug experiment?</h3>

Generally, Terrestrial isopods, such as pillbugs, are members of the crustacean family. Pillbugs, often known as roly-polys, are the subjects of this experiment, which examines their preference for lighting or darkness.

In conclusion, In the experiment with the pillbugs, your hypothesis