Question

100Point XL Step 724 Use Oi DMAX, and DCOUNT Functions eTh Salary-Excel Share Trace Precedents FinancilDate&Time More Functions MangeCreate trom Selection Remove Arrows -Wndow Wiech Calculation a Windw Optiens Creale a DMIN function in ces 120 to calcutate the minimum salary of employees based on the creeria entered in range A25 F26 Create a DMAX unction in cell 127 to calculate Fntion Function Library Dfine Names 128 LM the maxoimum satary of employees based on the crtena entered in range A25 F26 Create a DCOUNT function in cell 128 to count the number of reDateSalary 10/14/2002 $68,750 11/3/2013 549.575 6/14/2009 $46.000 employees that meet the criteria entered in 12/4/2009 range A25:F26. 9/3/2020 /13/2009 547.240 Va/2009 54715 wis/2011 $46.725 /3/200 $45,125 99 Laing 13/2006 565,500 815/2032 541.00 8 of 12 E View All C Reset Logic-Lookup Database Finance Submit Ask me anything 1.00 Point XL Sep 7 2 4 Use DMIN DMAX, and DCOUINT Fundions fe Σ-· 旧Lagu..-Lokup &﹂. 3 - @Dei. Na ". Dheherde Ei Create a OMIN ntion in cell 12 Function Laray A25 126 Create a DMAX unction in cel 127 to calculate Account Rep /14/2011 59 employees based on the crtes 445 Terrique Create a DCOUNT function in cell 128 to count the number of employees that meet the criteria entered in range A25:F26. Account Rep 41,52s 10/15/2011 56,725 18/2010 545,000 8 of 12 E View All C Reset Submit

Answer 1

apply the formula in the cell I28

=DCOUNT(A1:F21,,A25:F26)

The output will be received as given below.

have to specify the database, field (optional) and the condition

=DCOUNT(database, ,,condition)

Bookl Microsoft Excel Home| Insert Page Layout Formulas Data Review View @-厅ㄨ cut Σ AutoSum İA'a" =9-1ずWrap Text Genera a Copy Fill Paste format Painter Blu ロ 上 A = = : Merge & Center-s % , aa Condition 1 asoana.stels insert Delete. Format Sort & Find & 2 Clear FilterSelect Editing Clipboard Alignment Number Cells DCOUNTA1:F21, A25:F26) Account Rep Account Rep 128 05-06-09 03-09-10 7/19/2009 2645Doering 1268 ForganAanta 4658 Franklin Atanta 1370 Garbett 2848 Gomex 3996 Hartvi 46701 Keone 3799 43,750 45,250 47,240 47,835 46,725 45,000 45,125 65,500 49,750 41,000 45,100 39,750 41.525 49,750 43.750 count Rep! Account Rep 9/18/2009 10/15/2011 10-02-10 Atlanta 12 Rep Chicago Chic Account R Manager 13 ep01-04-10 2698 LenzAtlanta Account Rep 4 2611 Nitz 1256 Peterson 2009 Scholfield Atlanta 4428 Selinger 1/17/2006 4/15/2007 8/15/2012 04-11-11 Chic Atlanta 16 17 Account R Account Rep 7/142011 Account Rep 08-11-11 TerriquezChicago Chicago ount Rep07-01-05 11-01-09 21 1281 Unice Account Rep Criteria Range 25 26 27 Employee ID Location Title Hire Date Salary Average oston Account Rep # of Employees 30 4 Sheeti Sheet2 Sheet3