USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
viewed value
|
|
|
inspected value
|
|
|
displayed value
|
|
|
None of the above
|
Detailed explanation-1: -Display hidden cell values On the Format menu, click Cells, and then click the Number tab. Under Category, click General (or any appropriate date, time, or number format other than Custom), and then click OK.
Detailed explanation-2: -If Microsoft Excel displays ##### in a cell after you apply number formatting to it, the cell probably isn’t wide enough to display the data. To expand the column width, double-click the right boundary of the column that contains the cells with the ##### error.
Detailed explanation-3: -The formula bar in Excel is located next to the name box and above the worksheet area. It displays the data stored in the active cell. The formula bar is used to view, enter, and edit values and formulas in cells.
Detailed explanation-4: -The contents of the cell is displayed in the title, label, or text box that you selected.