Here is the content of a worksheet. K Zoom hours per day for each student n...

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

The argument in place of X is 1 The formula becomes as follows VLOOKUP B... View the full answer