Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

10 11 12 13 14 15 16 In cell E5, add a VLOOKUP function to look up the student's uniform size in the Student_Data table

image text in transcribed
10 11 12 13 14 15 16 In cell E5, add a VLOOKUP function to look up the student's uniform size in the Student_Data table for the student listed in cell B2. The function should be looking for an exact match. In cell E7, add a HLOOKUP function to retrieve the student's registration fee in the Entry_Fee named range for the regisu'ation type in cell E3. The function should be looking for an exact match. In cell 113, add a COUNTIF function to count the number of uniforms in the Uniform_Size column of the Student Data table that meet the filter criteria in cell H12. In cell 114, add a MATCH function nested in an INDEX function to retrieve the uniform fee located in the Uniform_Fee table on the DataInputs worksheet that meets the lter criteria in cells H12 and 113. To prevent an error from displaying when no uniforms of the size located in H12 are needed, nest the INDEX and MATCH functions inside an IFERROR function to leave the cell blank. (Hint: Set the match tpe to 1.) In cell B12, add a VLOOKUP function to retrieve the student's first name in the Student_Data table that meets the filter criteria in cell A12. The value should be looking for an exact match. In cell C12, add a VLOOKUP function to retrieve the student's last name in the Student_Data table that meets the filter criteria in cell A12. The value should be lookin- for an exact match. In cell D12, add a VLOOKUP function to retrieve whether or not the student has a permission slip on file in the Student_Data table that meets the filter criteria in cell A12. The value should be looking for an exact match. In cell E12, add a VLOOKUP function nested in an IF function to retrieve the student's uniform size. To prevent zeros from being displayed when the uniform size is not known, nest the VLOOKUP function in an IF function to leave the cell blank. The value should be looking for an exact match. In cell F12, add an AND function nested in an IF function to determine whether the student has a permission slip and a uniform. If the student has a permission slip and the uniform size is not blank, then display Yes in the field; otherwise, display No. Highlight B12:F12 and then copy the formula through cell range B38:F38. In cell F39, add a COUNTIF function to determine how many students are currently traveling to the competition as indicated by Yes in cell range F12:F38. In cell E8, add a MATCH function nested in an INDEX function to retrieve the transportation fee located in the Trans_Fee table on the DataInputs worksheet that meets the filter criteria in cell E4 and F39

Step by Step Solution

There are 3 Steps involved in it

Step: 1

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

Core Concepts Of Accounting

Authors: Leslie Breitner, Robert Anthony

11th Edition

0133125947, 9780133125948

More Books

Students also viewed these Accounting questions