Question 13: What displays when the range lookup in a lookup function is False and an exact match is not located in the table array? Answer: A. B. O ""DIVIor C. O HN/A"

Accounting Information Systems
11th Edition
ISBN:9781337552127
Author:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Chapter4: Documenting Information System
Section: Chapter Questions
Problem 15RQ
icon
Related questions
Question
Please Solve In 10mins Both Questions
Question 13: What displays when the range lookup in a lookup function is False and an exact match is not located in the table array?
Answer:
A.
в.
O ""DIVIor
с.
O "WN/A
D.
O A blank space
Transcribed Image Text:Question 13: What displays when the range lookup in a lookup function is False and an exact match is not located in the table array? Answer: A. в. O ""DIVIor с. O "WN/A D. O A blank space
Question 14: What is a valid range lookup entry for a VLOOKUP function?
Answer:
A
O 2
B.
O A5
C.
O 6'84
D.
O False
Transcribed Image Text:Question 14: What is a valid range lookup entry for a VLOOKUP function? Answer: A O 2 B. O A5 C. O 6'84 D. O False
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Present Value
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Accounting Information Systems
Accounting Information Systems
Finance
ISBN:
9781337552127
Author:
Ulric J. Gelinas, Richard B. Dull, Patrick Wheeler, Mary Callahan Hill
Publisher:
Cengage Learning
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning
Essentials of Business Analytics (MindTap Course …
Essentials of Business Analytics (MindTap Course …
Statistics
ISBN:
9781305627734
Author:
Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:
Cengage Learning