DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What happens when you hide a column in Microsoft Excel?
|
|
Formulas referencing cells in the column stop working
|
|
|
The data in the column in deleted
|
|
|
The column doesn’t appear, but the data is still there
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -This means that if there are rows/columns that are not visible to either the left or top of your spreadsheet, these cells will remain unviewable once Freeze Panes has been activated. This essentially prevents you from accessing (unhiding) them.
Detailed explanation-2: -Select “Visibility, ” and then select “Hide & Unhide” and “Unhide Columns” to make all missing columns visible.
Detailed explanation-3: -Using the Format Option Click on the small triangle at the top left of the worksheet area. This will select all the cells in the worksheet. Right-click anywhere in the worksheet area. Click on Unhide.
There is 1 question to complete.