DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you want to use Auto Outline, your data must have summary or subtotal rows or columns.
|
|
True
|
|
|
False
|
|
|
X
|
|
|
X
|
Explanation:
Detailed explanation-1: -Excel’s Auto Outline feature quickly hides detail noise so you can view just a summary of your data. Excel offers a simple outlining feature that’s helpful, but often overlooked by users. Auto Outline hides details, showing only the header and summarizing rows or columns.
Detailed explanation-2: -If the workbook is set to automatically calculate formulas, the Subtotal command recalculates subtotal and grand total values automatically as you edit the detail data. The Subtotal command also outlines the list so that you can display and hide the detail rows for each subtotal.
There is 1 question to complete.