DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which function can NOT be applied as a subtotal?
|
|
Average
|
|
|
Sum
|
|
|
Concatenate
|
|
|
Count
|
Explanation:
Detailed explanation-1: -Answer: (d) Percentage which function cannot be performed through subtotal in a Spreadsheet.
Detailed explanation-2: -d. Percentage function cannot be performed through Subtotal in a Spreadsheet.
Detailed explanation-3: -Subtotals are calculated with a summary function, such as Sum or Average, by using the SUBTOTAL function. You can display more than one type of summary function for each column.
Detailed explanation-4: -If the Subtotals command is grayed out, that’s because subtotals can’t be added to tables. But there’s a quick way around this. Convert your table to a range of data. Then you can add subtotals.
There is 1 question to complete.