A list maintained by doctors at a hospital contains the following patient information columns: registration number,name,age,height,weight,and date of admission.What information can be obtained by using the basic Filter function of Excel?
A)The number of patients admitted after a certain date.
B)The heights of patients with weights below 125 pounds.
C)The names of patients who were underweight (below 100 pounds)at the time of data collection.
D)The number of people admitted on a particular date.

Question

Quizplus · Accepted Answer

The basic Filter function filters a list and allows you to hide all the rows in a list except those that match criteria you specify.A list can be filtered using criteria in multiple columns,according to the required output.

A List Maintained by Doctors at a Hospital Contains the Following