USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
file
|
|
|
formulas
|
|
|
insert
|
|
|
data
|
Detailed explanation-1: -On the Tools menu, click Options. If you use Microsoft Office Excel 2007, click the Microsoft Office Button, click Excel Options, and then click Formulas. On the Error Checking tab or in the Error Checking rules area, ensure that the Formulas referring to empty cells check box is selected. Click OK.
Detailed explanation-2: -The #REF! error shows when a formula refers to a cell that’s not valid. This happens most often when cells that were referenced by formulas get deleted, or pasted over.
Detailed explanation-3: -There are a few ways to return a blank value in Excel. The most common way is to use the empty string “". Another way is to use a space character. To do this, type a space before the equal sign when you enter the formula.