24.
A sociologist wants to know what percent of a town’s population earns
between $50,000 and $100,000 annually. He obtains an Excel sheet with
income information for the town’s population from the U.S Census Bureau.
If he uses the Custom Filter function, which of the following values and
Boolean operators must he enter and select respectively to obtain the
required information?
25.
The results for a class of 10 after an examination are as follows: 56, 59, 64,
76, 78, 49, 62, 79, 86, 94. A teacher creates a list of students and their
marks using spreadsheet software. To find the number of students who
scored between 65 and 75, he selects the Custom Filter function and enters
“Greater Than” 65 or “Lesser Than” 75 as his criteria. How many students
will be selected?
26.
The results for a class of 10 after an examination are as follows: 56, 59, 64,
76, 78, 49, 62, 79, 86, 94. A teacher creates a list of students and their
marks using spreadsheet software. To find the number of students who
scored between 65 and 75, he selects the Custom Filter function and enters
“Greater Than” 65 and “Lesser Than” 75 as his criteria. How many students
will be selected?
27.
A shopkeeper wants to create a sublist of customers spending less than
$50 and customers spending more than $100 per purchase, out of a list of
all customer-purchase amounts. Which of the following combinations of
values and Boolean operators must be chosen?
28.
If you wanted customers who earned an annual income of less than $25,000
to appear in red, what spreadsheet feature would you use?
29.
Which of the following can be achieved using the conditional formatting
function of Excel?
30.
_____ is an Excel function which allows you to view the entire list while
having certain information called to your attention.
31.
To highlight information that meets some criterion that you set, you could
use _____ formatting.
32.
_____ highlights the information in a cell that meets some criteria you
specify.
33.
A list contains the names of members of a library, and the date of their
joining. Which of the following can be achieved using conditional
formatting?
34.
Which of the following enables you to group and summarize information?
35.
If you had a listing of customer information and you need to quickly group
and summarize this information, which spreadsheet feature would you use?
36.
Which of the following spreadsheet features allows you to quickly create a
two-dimensional table with totals for groups of information?
37.
Which spreadsheet feature would allow one to find the total number of
customers in a certain region from a list containing details of all the
customers of a company?
38.
When creating a ____, you create dimensions of information by specifying
how information is to be summarized by dimension.
39.
What is the difference between a Filter and a pivot table?
40.
In the skeletal structure of a pivot table, the _____ is the list of fields in the
original table that you can work with.
41.
In the skeletal structure of a pivot table, the _____ area is where you will
drop a field of information to create pages or layers.
42.
Which of the following elements of the skeletal structure of a pivot table
provides a three-dimensional aspect to the pivot table?
43.
When you drop information into the “Values” area in the lower-right corner
of the skeletal structure of a pivot table, the default aggregation of
summarization is ____.
44.
A list containing customer and customer purchase information has the
following columns: customer name, location (of the customer, i.e., North,
South, East, and West), customer income, customer age, and mode of
payment during last purchase (cash or card). A pivot table to find the
number of customers in each location and containing age, income, and
purchase information of customers needs to be created. Where must the
“location” field be dropped in the pivot table skeletal structure to create
such a table?