USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
To operate data in Excel, several formulas (functions) are provided that can be used to speed up processing time. The function used to determine the amount of numeric data in a range is____
|
|
SUM
|
|
|
MIN
|
|
|
MAX
|
|
|
AVERAGE
|
|
|
COUNT
|
Explanation:
Detailed explanation-1: -MAX: This function determines the highest cell value included in the argument. MIN: This function determines the lowest cell value included in the argument.
Detailed explanation-2: -In Excel, we have a similar built-in function known as the POWER function, which is used to calculate the power of a given number or base. To use this function, we can use the keyword =POWER( in a cell and provide two arguments, one as the number and another as power.
There is 1 question to complete.