If there are invalid cell references in a formula,the error value #REF! will display in the cell.
Correct Answer:
Verified
Q13: Linking to a workbook means that any
Q14: If a number is divided by zero,the
Q15: Data can be consolidated from different workbooks
Q16: The AND function returns a value of
Q17: One way to check worksheet formulas for
Q19: The CONCATENATE function breaks a text string
Q20: Cell and range names can use uppercase
Q21: Which Excel function averages cells in a
Q22: The _ refers to where you will
Q23: Which of the following is not a
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents