USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Insert a formula that returns the greatest number from column D.
|
|
=MAX
|
|
|
=MIN
|
|
|
=SUM
|
|
|
=SUMIF
|
Explanation:
Detailed explanation-1: -=DMAX(database, field, criteria) The DMAX function uses the following arguments: Database (required argument) – Database is the range of cells wherein the first row of the database specifies the field names. Field (required argument) – This is the column within the database from which we wish to find the maximum value.
Detailed explanation-2: -How do you use DMAX in Excel? DMAX is a function used in Excel to calculate the maximum value in a given range of cells. To use the DMAX function, you first need to enter the range of cells you want to calculate the maximum value in. Next, enter the formula “=DMAX(range)” and press enter.
There is 1 question to complete.