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
Relative Dating; One fossil is found to be older than another fossil.
Absolute Dating; Age of a fossil is found to be 61.1 million years old.
<h3>How to classify fossils?</h3>Relative dating is defined as the age of a rock layer (or the fossils it contains) compared to other layers. This dating can be gotten by looking at the position of rock layers. Whereas, absolute dating is the numeric age(specific age) of a layer of rocks or fossils. Absolute age can be determined by using radiometric dating.
1. Relative Dating; One fossil is found to be older than another fossil.
This is because In an excavation of a project area, if we see a set of fossils found 5 meters down, they will be younger than fossils found 17 meters down.
2. Absolute Dating; Age of a fossil is found to be 61.1 million years old.
A fossil analyzed with radiometric dating would have undergone maybe 2 half lives of radioactive isotope.
Read more about Fossils at; brainly.com/question/2257012
#SPJ1
