Module D Decision Analysis with Spreadsheet Software Answer Key
Multiple Choice Questions
1.
What is the intersection of a row and column in a spreadsheet called?
2.
Which spreadsheet term defines a collection of information arranged in
columns and rows?
3.
Which of the following is a characteristic that a list must possess?
4.
Which of the following is true of lists?
5.
In a list made using spreadsheet software, which of the following would be
a label?
6.
The administration department of a university makes a list of the professors
currently employed by the university (first column), the departments to
which they belong (second column), and their ages (last column). Which of
the following entries would most likely be contained in the fourth row of the
third column?
7.
A company makes a list of its customers using spreadsheet software. It has
four columns containing information on customer id (4-Digit), customer
name, date of most recent purchase, and address respectively. Which of the
following represents information stored in the third column of the list?
8.
Should a spreadsheet list contain any blank rows?
9.
A _____ is a description of a list by column.
10.
A list definition table:
11.
Which of the following spreadsheet features allows you to show only rows
from a list that meets a specific condition?
12.
If you were searching for a particular customer in a list and you knew, for
instance, the state the customer lived in, what spreadsheet feature should
you use?
13.
Using spreadsheet software, a company creates a list of its customers with
the following columns: customer’s date of birth, customer location, and date
of latest purchase. If the company needs to find the exact number of
individuals to whom birthday wishes would need to be sent on a particular
day, which function should it use?
14.
Using spreadsheet software, a manager makes a list of the number of
employees in each department in his company. The team size column has
the following entries in each cell: 3, 3, 7, 13, 22, 15, 26, 4. If the manager
uses a basic Filter, which of the following can he accomplish?
15.
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?
16.
A pediatrician creates a list, using spreadsheet software, of the ages of all
the children who had come to him suffering from acute pneumonia. If the
doctor wants to find the number of children aged 3 who had had
pneumonia, from the list, he must click on a cell in the list, click on Data
(from the menu bar), and click on Filter. Subsequently, he must:
17.
Which spreadsheet feature allows you to hide rows in a list?
18.
Regardless of how one uses the Filter function, Excel _____ rows that one
does not want to see.
19.
A list is created by the sales manager of a firm, listing the number of sales
per week for the current financial quarter. The column for number of sales
per week is as follows: 25, 37, 34, 56, 44, 26, 35, 35, 37. The sales manager
wants to find the number of weeks where sales was above 37. Using Excel,
he clicks on a cell in the list, on Data (from the menu bar), and on Filter.
Subsequently, he clicks on the list box arrow next to the Sales/week column
and selects 37. What will his answer be?
20.
A company uses Excel to maintain a list of its customers. It maintains
details of customer name, id, age, and region of residence (East, West,
North, and South). If a manager wants a list of only those customers living
in the North, which of the following functions of Excel can the manager
use?
21.
_____ allows you to hide all the rows in a list except those that match
criteria, besides “is equal to,” you specify.
22.
The _____ function allows you to use criteria such as greater than, less
than, and so on, to create a sublist of required elements.
23.
A psychologist wants to find the prevalence of stress-related disorders in
patients between the ages of 30 to 55. He creates a list of all of his patients
aged 55 or below who came to him with symptoms of stress. Using Excel
software’s Custom Filter function, he clicks on the “Age” column arrow box,
and selects Number Filters. Which of the following steps must he
subsequently follow to answer his question?