Insert the DMAX function in cell N4 to calculate the highest sales based on the criteria entered in range G2:K3.
1 answer:
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.
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
#SPJ1
You might be interested in
The people of Aad were an ancient tribe of Saudi Arabia. Their city was known as Iram. The tribe was popular for its cleverness and physical strength and therefore, they are also called giants. They were so strong and intelligent that they could carve mountains and use it as their homes. , the Thamūd were the successors of a previous nation called the ʿĀd, who had also been destroyed for their sins. They lived in houses carved into the surface of the earth. God chose the prophet Ṣāliḥ to warn the polytheistic Thamūd that they should worship the One God.
Here thx have a nice day please mark brainlist
Here thx have a nice day please mark brainlist