Answered step by step
Verified Expert Solution
Link Copied!

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... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Auditing and Assurance Services Understanding the Integrated Audit

Authors: Karen L. Hooks

1st edition

471726346, 978-0471726340

More Books

Students also viewed these Programming questions