USING MICROSOFT EXCEL
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: -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: -The ampersand (&) calculation operator lets you join text items without having to use a function. For example, =A1 & B1 returns the same value as =CONCATENATE(A1, B1).
There is 1 question to complete.