Answered step by step
Verified Expert Solution
Question
1 Approved Answer
You want to use a function that extracts data from another worksheet based on the school or college name entered in cell B2. The data
You want to use a function that extracts data from another worksheet based on the school or college name entered in cell B2. The data entered in cell B2 must match an existing worksheet name: Art, Business, or Engineering. In cell B3, insert an INDIRECT function that uses data in cell B2 to extract the value in cell H13 from the respective worksheet. After entering the function, check the Engineering worksheet to make sure the value in cell B3 in the Donors worksheet is the same as the value of cell H13 in the Engineering worksheet. In cell B2 in the Donors worksheet, type Art and check the results again. Your next task is to sort and filter data in the Art worksheet. Display the Art worksheet. In cell A17, insert a SORT function with a nested FILTER function. The nested FILTER function uses data in the range A2:H11 where the range H2:H11 is less than the value in cell H15($15,000). The results are then sorted in alphabetical order by last name
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started