USING MICROSOFT EXCEL
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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-2: -A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula.
Detailed explanation-3: -If a cell contains text data, Excel displays a series of pound signs (#) when the cell is too narrow to display the entire text. If you add another row to your worksheet, Excel automatically adjusts the references in affected formulas to reflect the change.
Detailed explanation-4: -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.