What happens if you rename the source file of a worksheet that is used in an external reference?
A) The link will automatically update
B) A prompt to manually update the link appears
C) The linked data will appear in red text
D) The workbook will not open
Correct Answer:
Verified
Q20: Which of the following functions cannot be
Q21: What is indicated by red arrows when
Q22: What error will cause #NUM! to appear?
A)Invalid
Q23: What is the proper format of an
Q24: What happens when data that is externally
Q26: Which function is best used to return
Q27: Which of the following would cause the
Q28: Which of the following is not a
Q29: Which of the following is not a
Q30: What happens if a user violates 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