Question
13) What is the role of the row index number in HLOOKUP ? a. the title/header row b. the row you do the lookup in
13) What is the role of the "row index number" in HLOOKUP ?
a. | the title/header row | |
b. | the row you do the lookup in | |
c. | the last row from the bottom | |
d. | the row where your answer is located | |
e. | none of the listed choices |
15) Which cell reference would be used for a consolidation across workbooks?
a. =Sport1!B3
b. none of the listed choices
c. =[WB3.xlsx]$A$2
d. =$B$3
e. =[WB3.xlsx]Sheet1!C3
17) Where would you access the Manage Relationships dialog box to create a data model in Excel?
a. | none of the listed choices | |
b. | Layout on the Design tab | |
c. | Relationships on the Data tab | |
d. | Data Models on the Analyze tab | |
e. | Joins on the Data tab |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started