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

Which evidence is used in this excerpt? select 2 options. opinion statistic example quotation story

Vladimir [108]

The evidence is used in this excerpt is known as a quotation and story. Check more about evidence below.

<h3>What is evidence?</h3>

This is known to be any fact that is presented that shows that a given thing or action is true.

Note that in the excerpt below, the The evidence is used in this excerpt is known as a quotation and story

See full question below

Read the excerpt from "Lise Marie de Baissac.”

According to her SOE file, "[s]he was the inspiration of groups on the Orne [river] and by her initiative caused heavy losses to the Germans. . . . She also took part in several armed attacks on enemy columns."

Which evidence is used in this excerpt? Check all that apply.

opinion

statistic

example

quotation

story

Learn more about evidence from

brainly.com/question/10149901

#SPJ2

8 0

2 years ago

In the country of United States of Height, the height measurements of ten-year-old children are approximately normally distribut

Rashid [163]

Answer:

a) We need to find p(x<68.15)

Standardize x to z, we have, z = (68.15-μ)/σ

=(68.15-57)/8.1

=1.38

Reading from standard normal tables,

p(z<1.38) =0.9162.

b) We need to find p(x>54.4)

Standardize x to z, we have, z = (54.4-μ)/σ

=(54.4-57)/8.1

=-0.32

Reading from standard normal tables,

p(z>-0.32) = 0.6255

7 0

2 years ago

The best way to register for the SAT is:

wel

I would say online since that's the method everyone I've ever talked to signs up

6 0

3 years ago

Read 2 more answers

In casting experiments performed using a certain alloy.

jeyben [28]

Answer:
A) Cm = 2.232 s/mm²
B) Time taken to solidify = 74.3 seconds
Explanation:
(A) Since a side is 50mm and all sides of a cube are equal, thus, Volume of the cube is;V = 50 x 50 x 50 = 125,000 mm³
There are 6 faces of the cube, thus Surface Area A = 6 x (50 x 50) = 15,000 mm²
So, Volume/Area = (V/A) = 125,000/15,000 = 8.333 mm
Cm is given by the formula; Cm =[Tts] /(V/A)² where Tts is time taken to solidify and it's 155 seconds in the question. Thus;
Cm = 155/(8.333)²= 2.232 s/mm²
(B) For;Cylindrical casting with D = 30 mm and L = 50 mm.;
Volume of cylinder is;
V = (πD²L) /4
So,V = (π x 30² x 50)/4 = 35,343mm³
Surface area of cylinder is;
A = (2πD²)/4 + (πDL)
Thus, A = ((π x 30²)/2) + (π x 30 x 50) = 6126 mm²
Volume/Area is;
V/A = 35,343/6126 = 5.77 mm
Same alloy and mold type was hsed as in a above, thus, Cm is still 2.232 s/mm²
Since Cm =[Tts] /(V/A)²
Making Tts the subject, we have;
Tts =Cm x (V/A)²
Tts = 2.232 x (5.77)² = 74.3 seconds

7 0

2 years ago

_____________ was the desire for a people with a common language, history, and culture to create there own nation.

Alex Ar [27]

Answer:

copulation was

7 0

3 years ago