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

What does someone with a Growth Mindset not believe?

Aleks [24]

Answer :

O I believe that there are some subjects I will never do well in
O I believe that hard work can improve my intelligence.

I’m torn between the last two options B & D

6 0

3 years ago

The barry family invited 100 relatives to their christmas party. 90 guests had italian heritage, 80 had german heritage and 75 h

Maslowich

The minimum number of people who claimed ancestry from all three heritages is : 45

Given that there are 100 relatives

let's assume that 1 relative = 1 room

100 relatives = 100 rooms

Number of relatives with Italian heritage = 90

Number of relatives with German heritage = 80

Number of relatives with swiss heritage = 75

Step 1 :

Fill up the first 90 rooms with Italian heritage relatives

Fill up the remaining 10 rooms with 10 Relatives with German heritage

Step 2 :

Distribute the remaining 70 relatives with German heritage into 70 rooms out of the 90 rooms already occupied by the relatives with Italian heritage

Step 3:

Distribute the 75 relatives with swiss heritage into the 20 rooms occupied by Italian heritage relatives only and 45 rooms occupied by both German and Italian relatives and into the 10 rooms occupied by the German heritage relatives

Therefore we can conclude that the minimum number of people who claimed ancestry from all three heritages is : 45

Learn more about pie chart : brainly.com/question/25666939

6 0

3 years ago

Read 2 more answers

a 6.10 m nacl can be made by adding [x]g of nacl to a container and making the volume of water up to the 1.00 l line. round the

Stels [109]

Answer:

fat come get me

Exp

4 0

3 years ago

Calista is struggling to balance her home life, part-time job, and school work. Her grades have begun to slip, and she is consid

kakasveta [241]

Calista should not give up on her education and she should set a timetable.

<h3>Advices that Calista can follow </h3>

She should not give up, Calista should not give up on her education since she had already started, but continue to encourage herself.
Set a timetable, Calista should have a timetable of how to run her day to day activities which can better help her have time for her studies.

Therefore, Calista should not give up on her education and she should set a timetable for herself that will work for her.

Learn more on importance of education here,

brainly.com/question/13341331

6 0

3 years ago

With what software tool can you see the applications that are currently running on your computer.

Tresset [83]

The Microsoft Windows Task Manager is a general, quick, and easy method of viewing what programs, background processes, and apps are running on the computer . Hope this helps

6 0

3 years ago