FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

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?
A
Group by
B
At each change in
C
Us Function
D
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.