Lesson_Pricing as the name. Select the range A13.E17, and then create a named range using Trans_Fees as the name. Select the range A20:G24, and then create a named range using Uniform_Fees as the name Select the range H6:37, and then create a named range using Entry Fee as the name On the StudentData worksheet, in cell E5, add a COUNTIF function to count the Teacher field in the Student_Data table that meets the filter criteria in cell E4. Copy the formula through cell 15. In cell K5, add a DCOUNTA function to count the StudentiD field in the Student_Data table that meets the filter criteria in the range D1K2 In cell K8, add a VLOOKUP function nested in an IFERROR function to retrieve the price per hour, located in column 3 in the Lesson Pricing named range, for each student on the basis of the student's skill level located in the Skill level field. The value should be looking for an exact match. To prevent an error from being displayed when the skill level is not known, use the FERROR function to leave the cell blank entData LessonData Datainputs Report re to search Lesson_Pricing as the name. Select the range A13.E17, and then create a named range using Trans_Fees as the name. Select the range A20:G24, and then create a named range using Uniform_Fees as the name Select the range H6:37, and then create a named range using Entry Fee as the name On the StudentData worksheet, in cell E5, add a COUNTIF function to count the Teacher field in the Student_Data table that meets the filter criteria in cell E4. Copy the formula through cell 15. In cell K5, add a DCOUNTA function to count the StudentiD field in the Student_Data table that meets the filter criteria in the range D1K2 In cell K8, add a VLOOKUP function nested in an IFERROR function to retrieve the price per hour, located in column 3 in the Lesson Pricing named range, for each student on the basis of the student's skill level located in the Skill level field. The value should be looking for an exact match. To prevent an error from being displayed when the skill level is not known, use the FERROR function to leave the cell blank entData LessonData Datainputs Report re to search