DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following is NOT an option in the Subtotal dialog box?
|
|
Group by
|
|
|
At each change in
|
|
|
Us Function
|
|
|
Add subtotal
|
Explanation:
Detailed explanation-1: -The correct answer is Alignment.
Detailed explanation-2: -Answer. Answer: The Subtotal dialog allows end-users to automatically group related data in a worksheet and add summary rows to each group using the SUBTOTAL function.
Detailed explanation-3: -Ans.: The subtotals dialog box has the following tabs: 1st Group. 2nd Group. 3rd Group.
There is 1 question to complete.