All of the following statements are TRUE regarding 3-D references EXCEPT:
A) A range of cells is permitted in a 3-D reference.
B) Multiple worksheets are permitted in a 3-D reference.
C) 3-D ranges can reference different cells across multiple worksheets.
D) 3-D ranges cannot be defined in the Name box.
Correct Answer:
Verified
Q30: A worksheet can store _ consolidation(s).
A)one
B)two
C)three
D)unlimited
Q31: An Excel _ is a workbook that
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
Q36: Excel addresses linked workbooks by using _
Q37: Each of the following statements is TRUE
Q38: References that address data across multiple worksheets
Q39: The _ error will appear if VLOOKUP
Q40: Ungrouping worksheets is accomplished by either right-clicking
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