DATABASE FUNDAMENTALS
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: -Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.
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.