Each of the following statements is TRUE about working with multiple workbooks EXCEPT:
A) Working with multiple workbooks is very similar to working with multiple worksheets.
B) Excel 2013 opens each workbook in the same window.
C) Data can be referenced between workbooks using 3-D ranges and formulas, so when the source workbook is updated, the changes flow through to the summary workbook.
D) Users can choose whether or not to link workbooks to make the updating automatic or not.
Correct Answer:
Verified
Q32: All of the following statements are TRUE
Q33: A 3-D range can be defined by
Q34: All of the following statements are TRUE
Q35: All of the following statements are TRUE
Q36: Excel addresses linked workbooks by using _
Q38: References that address data across multiple worksheets
Q39: The _ error will appear if VLOOKUP
Q40: Ungrouping worksheets is accomplished by either right-clicking
Q41: When data is consolidated and links to
Q42: While VLOOKUP can reference linked table data
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