USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which is NOT a requirement for data grouping?
|
|
A label in the first row
|
|
|
Similar facts in each column
|
|
|
No blank rows or columns in the selected range
|
|
|
A total in the last row
|
Explanation:
Detailed explanation-1: -Which of the following is NOT a GROUP BY function? Answer: C. NVL is a general function used to provide alternate value to the NULL values. The functions MAX, MIN and AVG can be used as GROUP BY functions.
Detailed explanation-2: -The COUNT() function returns the number of rows in a database table.
Detailed explanation-3: -SQL COUNT() function counts the total number of rows present in the database.
Detailed explanation-4: -We can use the command FIRST() to extract the first entry of a particular column and LAST() to extract the last entry of a particular column in a Table.
There is 1 question to complete.