Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Here is the content of a worksheet. K Zoom hours per day for each student n Tue 2 3 Student Mon Tue Wed Thu
Here is the content of a worksheet. K Zoom hours per day for each student n Tue 2 3 Student Mon Tue Wed Thu Fri Sat Sun Wed 3 4 May 5 Peter 6 Amy 5 6.5 8.5 4 2 Thu 4 4.5 7.5 4.5 2 Fri 5 4 8.5 7.5 Sot John 8 6 5.5 3.5 Sun 8 9 Who? 10 Day? Peter Wed 1 Hours = 4.5 A cell formula has been written in cell B11. It shows the number of hours a student spends on Zoom for a particular day. The student name is entered in cell B9 and the day in cell B10. The formula is shown below. =VLOOKUP (89, A4:H7,VLOOKUP (B10, J1:K7,2, FALSE) FALSE) You need to fill in the blank in position X in the formula so that it can return the number of hours for the student on the day correctly. You need to write the answer clearly in the box below. Do not write any spaces in the answers. For example, if you need to write an expression such as A + B, you will write A+B without any spaces in between. 004
Step by Step Solution
★★★★★
3.49 Rating (162 Votes )
There are 3 Steps involved in it
Step: 1
The argument in place of X is 1 The formula becomes as follows VLOOKUP B...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