Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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

Database Design Application And Administration

Authors: Michael Mannino, Michael V. Mannino

2nd Edition

0072880678, 9780072880670

Students also viewed these Databases questions