Question: I need help with these steps. Please be clear in letting me know if I need to highlight the row, or label or both. Also,

I need help with these steps. Please be clear in letting

I need help with these steps. Please be clear in letting me know if I need to highlight the row, or label or both. Also, do I put the function in cell J1 or J2?

Insert a lookup function that looks up the room number, compares it to the lookup table in the Room Capacity worksheet, and returns the room capacity. Make sure the function copies down the entire column.

Lookup_vector is below.

Room	Capacity
ED 301	30
SCI 115	50
SCI 117	42
SCI 119	28
SCI 210	32
SCI 214	28
SCI 215	24
SCI 216	24

File Home Insert Draw Page Layout Formulas Data Review View D EE show Queries Connections A From Access EE From Table From Web Properties From Other Existing New Refresh From Text Recent Sources Edit Links Sources Connections Query Get External Data Get & Transform Connections capaci Days start Tim End Tima Room nstructor 2 Sherbotie, Geraldine Mary MWF 8:00 AM 8:50 AM SCI 115 Wagner, Vivian J 1:00 PM 1:50 PM SCI 119 MWF Wagner, Vivian J 2:00 PM 2:50 PM SCI 119 MWF 9:00 AM 9:50 AM SCI 216 5 Bockelman Travis K MwF 6 Bockelman, Travis K 12:00 PM 12:50 PM SCI 216 MwF 8:00 AM 8:50 AM SCI 119 Lawrence, Margarent 7 MwF Matthews, Cascandra D. 10:00 AM 10:50 AM SCI 119 Mw Klopping, Ingrid M. 1:00 PM 2:50 PM SCI 115 Mw 0 Klopping, Ingrid M. 4:00 PM 5:50 PM SCI 115 M 3:00 PM 5:50 PM sci 214 1 Reynolds, Stephanie Beth 2 Blaszcak, Adam G 6:00 PM 8:30 PM SCI 215 M 3 Bockelman Travis K 1:00 PM 3:00 PM SCI 215 7:00 AM 9:50 AM SCI 210 4 Fredrickson, Cynthia Marie W 5 Fredrickson, Cynthia Marie W 10:00 AM 12:50 PM SCI 210 W 5:00 PM 7:50 PM SCI 210 6 Pinkard, Alesha M. F 7 Reynolds, Stephanie Beth 10:00 AM 12:50 PM SCI 210 F 1:00 PM 3:50 PM SCI 210 8 Reynolds, Stephanie Beth

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I need help making the graph. Please make the graph by hand on a piece of paper and label it. All information needed is provided below. Thank you so much!! Laboratory 00 Intro Gl'E' Suppose an...

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

Thoughts on what an outstanding HR manager would do to prevent this problem from happening in the first place and what intervention they should use at this point in these situations to improve and...

can someone help me with this please let me know if you need more info Required information [The following information applies to the questions displayed below.) This Applying Excel worksheet...

CHAPTER 7 Coaching for Per fo rm ance Once you have begun to delegate, you need to be able to work with your direct reports so that they are successful in their assignments. This managerial skill is...

Theme one is about the greatest skill a leader can possess that is the art of communication. This week's theme is to discuss the importance of communication which at its heart is the art of...

Chapter 9 Performance Management Skills A leader becomes complete only after giving something back. LAURENCE S. LYONS LEARNING OBJECTIVES By the end of this chapter, you will be able to do the...

slide_right THIS WAS ALL THE INFORMATION FOR MY FUNCTION THE EXAMPLE of one function def calculate_inx(ROWS: int, COLS: int) -> int: """ Returns the index in the string representation of the game...

Classic 2.0 Brittany Marshall Sunday, February 14, 2016 This report is provided by: Laureate Education, Inc. 650 S. Exeter St. Baltimore, MD 21202 Telephone (U.S. calls): 1.800.925.3368 Telephone...

1) Critically evaluate how has the enterprise value of the Cape Union Mart moved over the past 5 years and from this assessment, what has been the significant driver. Based on your analysis, advise...

a) Solve the given differential equation by undetermined coefficients. y" -y' = -3 b) Solve the following differential equation by variation of parameters. y" 4y' + 4y = (x + 1)e2*

1. Calculate and record depreciation for the year just ended April 30, 2015, for both the building and equipment. 2. Prepare the property, plant and equipment section of the balance sheet at April...

The present value of $ 5 , 0 0 0 that is to be received 4 years from today, assuming a discount rate of 8 % , equals 5 , 0 0 0 6 , 1 2 7 3 , 6 7 5 2 , 4 5 8

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

What are the implications of rapidly rising health care prices and spending for ( a ) the growth of real-wage rates, ( b ) government budgets, and ( c ) off shoring of U.S. jobs? Explain.

KEY QUESTION What are the twin problems of the health care industry as viewed by society? How are they related?

LAST WORD What groups benefit and what groups lose from the U.S. sugar subsidy program?