One way to check worksheet formulas for errors is to display the formulas on the worksheet rather then the formula results.
Correct Answer:
Verified
Q12: The IFERROR function is used to look
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
Q18: If there are invalid cell references in
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
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