FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following error messages would appear if the cell reference is not valid?

A	#REF!
B	Railroad Tracks Error, #####
C	#NAME?
D	#CELL?

Explanation:

Detailed explanation-1: -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-2: -#REF! Cell referenced if not valid. This will happen if a cell that was specifically referenced in a formula is deleted.

Detailed explanation-3: -This means that you do not have access to the Excel file locally or lost access to it on a network drive, or you could have referenced a temporary file. Therefore, you may find this invalid references error when you open the pivot table file directly online or via the website.

Detailed explanation-4: -Excel displays the #REF! error when a formula refers to a cell that is not valid.

Detailed explanation-5: -You may see a #DIV/0! error when data is not yet complete. For example, a cell in the worksheet is blank because data has not been entered, or is not yet available. You also may see the divide by zero error with the AVERAGEIF and AVERAGEIFS functions, when the criteria does not match any cells in the range.

There is 1 question to complete.