Use the following table to determine the outputs of the VLOOKUP functions in parts (a) through (e). (Remember that the first column is where you look to determine the row, and assume the table has been named.) 0 | $ 0.05 | $ 0.07 | $ 0.08 7 | $ 0.10 | $ 0.11 | $ 0.12 12 | $ 0.12 | NA | $ 0.15 14 | $ 0.15 | $ 0.18 | NA 21 | $ 0.19 | $ 0.20 | $ 0.21 (a) = VLOOKUP(2,table,3) Select the correct choice below and, if necessary, fill in the answer box to complete your choice. A. $ (Type an integer or a decimal.) B. 14 C. 7 D. 21 E. 0 F. 12 G. NA
Added by Isabella L.
Close
Step 1
In this case, the function is VLOOKUP(2, table, 3). This means we are looking for the value '2' in the first column of the table. However, there is no '2' in the first column. The way VLOOKUP works is that if it doesn't find the exact match, it will go to the Show more…
Show all steps
Your feedback will help us improve your experience
Derek Follett and 97 other Algebra educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Jason J.
Determine whether or not the given table could possibly be a table of values of a function. Give reasons for your answer. $$\begin{array}{|l|c|c|c|c|c|} \hline \text { Input } & -5 & 1 & 3 & -5 & 7 \\ \hline \text { Output } & 0 & 2 & 4 & 6 & 8 \\ \hline \end{array}$$
Functions and Graphs
Functions
Evaluate each expression using the values given in the table: a. (f o g)(1) b. (f o g)(2) c. (g o f)(2) d. (g o f)(3) e. (g o g)(1) f. (f o f)(3)
Kumareshwaran R.
Recommended Textbooks
Elementary and Intermediate Algebra
Algebra and Trigonometry
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD