45.
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 is created
dividing the customers based on their location. Where must the “mode of
payment” field be dropped if information on mode of payment based on
region is required?
46.
A list consists of the following columns: customer id, customer income, total
annual expenditure, and annual expenditure on food. While creating a pivot
table, which of the following fields would require clicking on “Count” in the
“Values” field setting?
47.
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 is created
dividing the customers based on their location. Which of the following would
result in the creation of a three-dimensional pivot table?
48.
_____ is an Excel function that works backward from an objective to
compute an unknown value.
49.
Which of the following represents the steps for selecting the Goal Seek
tool?
50.
Which of the following is an action which needs to be performed before
using the Goal Seek tool?
51.
A newly formed company producing glass paperweights creates a
worksheet using Excel for finding the number of units it has to sell to post a
profit of $10,000 in the first year. In the Goal Seek tool dialog box, where
must the required profit be entered?
52.
A worksheet, created by a company making toothbrushes, contains the
following information within specified cells (given in brackets): Number of
toothbrushes sold (K10), Sale price * number of toothbrushes sold (K11),
Transportation cost per toothbrush * number of toothbrushes sold (K12),
the fixed cost (K13) involved in manufacturing the toothbrushes, and the
net profit (K14). If the company wants to find the number of toothbrushes
they have to sell to make a profit of $5,000, what must they enter in the “By
changing cell” in the Goal Seek Dialog box?
53.
A worksheet, created by a company making toothbrushes, contains the
following information within specified cells (given in brackets): Number of
toothbrushes sold (K10), Sale price * number of toothbrushes sold (K11),
Transportation cost per toothbrush * number of toothbrushes sold (K12),
the fixed cost (K13) involved in manufacturing the toothbrushes, and the
net profit (K14). If the company wants to find the number of toothbrushes
they have to sell to make a profit of $5,000, what must they enter in the “For
set” field in the Goal Seek Dialog box?
54.
A worksheet, created by a company making toothbrushes, contains the
following information within specified cells (given in brackets): Number of
toothbrushes sold (K10), Sale price * number of toothbrushes sold (K11),
transportation cost per toothbrush * number of toothbrushes sold (K12), the
fixed cost (K13) involved in manufacturing the toothbrushes, and the net
profit (K14). If the company wants to find the number of toothbrushes they
have to sell to make a profit of $5,000, what must they enter in the “To
value” field in the Goal Seek Dialog box?
55.
A biscuit manufacturer sells 10 packets of biscuits for $50. The cost
involved in making 10 packets is $15, the cost of transporting 10 packets to
the customers is $20, and the fixed costs involved amount to $5. If this
information is put into a worksheet, what must one enter in the “To value”
field of the Goal Seek dialog box to find the number of packets that need to
be sold to make a profit of $200?
True / False Questions
56.
A cell is the intersection of a column and a row.
57.
Microsoft Word is spreadsheet software that allows you to analyze any kind
of information.
58.
A column in a list can display many different types of information.
59.
A list contains information displayed only in columns whereas a pivot table
has information in both rows and columns.
60.
The first row in a list usually contains labels or row headings.
61.
A list often contains blank rows to separate groups from other groups.
62.
A list often contains blank columns to separate categories from other
categories.
63.
A list is bordered on all sides by blank rows and columns; this space
identifies the end of the list.
64.
A list definition table is a list of columns in a workbook with their
descriptions.
65.
If you cannot create a list, then you probably cannot create a list definition
66.
The Filter function filters a list and allows you to hide all the rows in a list
except those that match criteria you specify.
67.
If you wanted to see a sublist of every student whose last name begins with
“B” from a list of all students, you could use the basic Filter function.
68.
Basic Filter allows you to choose to view only the information that you want;
all other information can be hidden.
69.
When using the basic Filter, you are limited to working with just one column
or category of information.
70.
The basic Filter function can only be used to sort numeric data.
71.
The basic Filter function allows you to use other criteria such as greater
than, less than, and so on to hide rows not meeting specific criteria.
72.
The Custom Filter function can create a sublist of people aged 45 and
above from a list of people of varying ages.
73.
The Custom Filter function allows you to hide all the rows in a list except
those that fit into a range of numbers.