Problems
the Following Animal File from the Central Zoo Will

question 36

Essay

Problems
The following Animal File from the Central Zoo will be used in several of the following questions. The left-hand column of relative record numbers is there to facilitate answering the questions.
$\begin{array}{lr}&\text { Animal } \quad\quad\quad\quad\quad\quad\quad\quad \text { Animal } \quad\quad\quad\quad\quad \text { Country of } \quad\quad\quad\quad\\&\text { Number } \quad\quad \text { Species }\quad\quad\quad \text { Name }\quad\quad \text { Gender } \quad\text { Birth }\quad\quad\text { Weight }\\\begin{array}{lr}1\\2\\3\\4\\5\\6\\7\\8\\9\\10\end{array}&\begin{array}{|r|l|l|l|l|r|}\hline 13648 & \text { Elephant } & \text { Jumbo } & \text { M }\quad\quad & \text { Uganda } & 6,000 \\\hline 14990 & \text { Kangaroo } & \text { Fred } & \text { M } & \text { Australia } & 200 \\\hline 17543 & \text { Elephant } & \text { Shirley } & \text { F } & \text { Nigeria } & 5,500 \\\hline 20165 & \text { Giraffe } & \text { Necky } & \text { F } & \text { USA } & 500 \\\hline 23743 & \text { Giraffe } & \text { High Top } & \text { F } & \text { USA } & 600 \\\hline 27579 & \text { Panda } & \text { Fluffy } & \text { M } & \text { China } & 250 \\\hline 32565 & \text { Elephant } & \text { Large Louie } & \text { M } & \text { India } & 7,000 \\\hline 34871 & \text { Grizzly Bear } & \text { Doris } & \text { F } & \text { Canada } & 1,500 \\\hline 35993 & \text { Lion } & \text { King } & \text { M } & \text { USA } & 580 \\\hline 38578 & \text { Tiger } & \text { Stripes } & \text { F } & \text { India } & 470\\\hline\end{array}\end{array}$ Animal file
-Assume that the records of the Animal file are physically stored in the order shown.
a. Retrieve all of the records of the file physically sequentially.
b. Retrieve all of the records of the file logically sequentially based on the Animal Name field.
c. Retrieve all of the records of the file logically sequentially based on the Animal Number field.
d. Retrieve all of the records of the file logically sequentially based on the Weight field.
e. Perform a direct retrieval of the records with an Animal Number field value of 34871.
f. Perform a direct retrieval of the records with a Country of Birth field value of USA.

---

Definitions:

Corresponding PivotTable

A feature in spreadsheet software that automatically generates a summarizing table from a selection of data, allowing for dynamic analysis and reporting.

Insert Slicers

A feature in spreadsheet software that allows users to filter data in pivot tables or charts visually, enabling more interactive and easier analysis of large data sets.

Worksheet

In software, a single spreadsheet within a workbook; in education, a sheet of paper with exercises for students.

Filtering PivotChart

The process of adjusting the data displayed in a PivotChart by excluding certain values or criteria to focus on specific data points.