DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
An Excel Feature allowing you to hide/show and subtotal different sections of data
|
|
Outline
|
|
|
Outside
|
|
|
Ousted
|
|
|
Cluster
|
Explanation:
Detailed explanation-1: -Hide columns Select one or more columns, and then press Ctrl to select additional columns that aren’t adjacent. Right-click the selected columns, and then select Hide.
Detailed explanation-2: -Groups and outlines allow you to quickly hide and unhide rows or columns in an Excel spreadsheet. The Groups feature creates row and column groupings in the Headings section of the worksheet. Each group can be expanded or collapsed with the click of a button.
Detailed explanation-3: -Hide an outline Go to File > Options > Advanced, and then under the Display options for this worksheet section, uncheck the Show outline symbols if an outline is applied check box.
There is 1 question to complete.