Deck 13: Decision Analysis With Spreadsheet Software

Question 1

Which spreadsheet feature allows you to hide rows in a list?

A)Conditional formatting
B)AutoFilter
C)Pivot table
D)Data analysis

Answer 1

B
Explanation: The AutoFilter function allows one to display only selected rows on a list while hiding the other rows.

Question 2

A list definition table:

A)filters a list and allows you to hide all the rows in a list except those that match criteria you specify.
B)creates sublists using exact match criteria.
C)highlights the information in a cell that meets some criteria you specify.
D)describes a list by column.

Answer 2

D
Explanation: A list definition table is a description of a list by column.

Question 3

Which of the following is true of lists?

A)A list can only contain numerical information (except for labels).
B)A list does not usually contain a label for the first column.
C)A list does not require a blank line above it if it starts from the first row.
D)A list must not have a blank row unless it contains verbal information.

Answer 3

C
Explanation: A list must be bordered on all four sides by blank rows and blank columns,though it may not have a blank line above it if it starts in the first row.

Question 4

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?

A)Goal Seeking
B)Filter
C)Sorting
D)Pivot Table

Question 5

In a list made using spreadsheet software,which of the following would be a label?

A)An entry made in the third row of the first column.
B)An entry made in the third row of the third column.
C)An entry made in the first row of the third column.
D)An entry made in the last row of the first column.

Question 6

What is the intersection of a row and column in a spreadsheet called?

A)Group
B)Block
C)Cell
D)Object

Question 7

Which of the following is a characteristic that a list must possess?

A)Each row must have only one type of information.
B)The first column in the list must contain the labels or column headings.
C)The list must not contain any blank columns.
D)The list must be bordered on all four sides by blank rows and blank columns.

Question 8

A _____ is a description of a list by column.

A)list definition table
B)pivot table
C)feature key
D)column definition

Question 9

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?

A)Dr.Ridley Donovan
B)46
C)24 August,1956
D)Psychology

Question 10

Regardless of how one uses the Filter function,Excel _____ rows that one does not want to see.

A)deletes
B)eliminates from the sublist
C)does not include in the new table
D)hides

Question 11

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?

A)Basic Filter
B)Custom Filter
C)Pivot table
D)Goal Seek

Question 12

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?

A)Basic Filter
B)Custom Filter
C)Goal Seek
D)Conditional formatting

Question 13

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?

A)7714,Wendy Dickens,12/01/27,#17 Downing Street,Sacramento,CA.
B)01/27/12,04/13/09,10/30/11,09/12/10.
C)Helena Melton,Stefanie Czajkowski,Liz Thomas,Kristen Amato.
D)7714,8012,0212,1678.

Question 14

Should a spreadsheet list contain any blank rows?

A)Yes,between groups of records.
B)Yes,blank rows should contain borders.
C)No,blank rows should only surround the list.
D)No,blank rows should be isolated to the definitions.

Question 15

Which of the following spreadsheet features allows you to show only rows from a list that meets a specific condition?

A)Filter
B)AutoMatch
C)Goal Seek
D)Group

Question 16

Which spreadsheet term defines a collection of information arranged in columns and rows?

A)Catalog
B)Inventory
C)List
D)Directory

Question 17

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?

A)37
B)2
C)4
D)5

Question 18

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:

A)click on the list box arrow next to "Age" and select 3.
B)click on Clear Filter from "Age."
C)select "Number Filters",click on "Greater Than" from the list of Boolean operations,and select 3.
D)select "Number Filters",click on "Greater Than" from the list of Boolean operations,and select 2.

Question 19

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?

A)Only hide all rows with a team size below 13.
B)Highlight all cells with a team size greater than 13.
C)Show only production departments with 3 people.
D)Show all management departments with 7 or more people.

Question 20

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 21

Which of the following can be achieved using the conditional formatting function of Excel?

A)Show only numbers in between 70 and 80 from a list of numbers from 1 to 100.
B)Remove all rows not corresponding to specified criteria from a list.
C)Calculate an unknown value from an objective specified in a worksheet.
D)Differentiate even numbers from a list of even and odd numbers.

Question 22

If you wanted customers who earned an annual income of less than $25,000 to appear in red,what spreadsheet feature would you use?

A)Data ordering
B)Goal Seeking
C)Data validation
D)Conditional formatting

Question 23

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?

A)5
B)3
C)10
D)0

Question 24

In the skeletal structure of a pivot table,the _____ is the list of fields in the original table that you can work with.

A)Filter Field Area
B)Column and Row Field List
C)PivotTable Field List
D)PivotTable Labels Area

Question 25

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?

A)"Greater Than" $50,000 or "Lesser Than" $100,000
B)"Lesser Than" $50,000 or "Greater Than" $100,000
C)"Greater Than" $50,000 and "Lesser Than" $100,000
D)"Lesser Than" $50,000 and "Greater Than" $100,000

Question 26

When creating a ____,you create dimensions of information by specifying how information is to be summarized by dimension.

A)list definition table
B)pivot table
C)worksheet
D)sublist

Question 27

If you had a listing of customer information and you need to quickly group and summarize this information,which spreadsheet feature would you use?

A)Goal Seeking
B)Data analysis
C)Data summary
D)Pivot table

Question 28

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?

A)"Greater Than" $50 or "Lesser Than" $100
B)"Lesser Than" $50 or "Greater Than" $100
C)"Greater Than" $50 and "Lesser Than" $100
D)"Lesser Than" $50 and "Greater Than" $100

Question 29

To highlight information that meets some criterion that you set,you could use _____ formatting.

A)auto
B)restrictive
C)conditional
D)limited

Question 30

_____ is an Excel function which allows you to view the entire list while having certain information called to your attention.

A)Basic Filter
B)Custom Filter
C)Conditional formatting
D)Goal Seek

Question 31

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?

A)Goal Seeking
B)Data analysis
C)Conditional formatting
D)Pivot table

Question 32

Which of the following spreadsheet features allows you to quickly create a two-dimensional table with totals for groups of information?

A)Goal Seeking
B)Pivot table
C)Forms
D)Groups

Question 33

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?

A)Click on the "Lesser Than" list of Boolean operations and type the number 55.
B)Click on the "Greater Than" list of Boolean operations and type the number 30.
C)Click on the "Lesser Than" list of Boolean operations and type the number 30.
D)Click on the "Greater Than" list of Boolean operations and type the number 55.

Question 34

_____ allows you to hide all the rows in a list except those that match criteria,besides "is equal to," you specify.

A)Goal Seek
B)Basic Filter
C)Custom Filter
D)Conditional formatting

Question 35

What is the difference between a Filter and a pivot table?

A)A Filter requires that rows are sorted by a column or group before they are analyzed;a pivot table does not.
B)A Filter can analyze dissimilar information;a pivot table cannot.
C)A pivot table provides summary results on groups of information;a Filter shows only rows in some group.
D)A pivot table provides more detailed information than a Filter.

Question 36

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?

A)5
B)3
C)10
D)0

Question 37

Which of the following enables you to group and summarize information?

A)Pivot table
B)Conditional formatting
C)Basic Filter
D)Custom Filter

Question 38

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?

A)Hide all names who have been members for more than five years.
B)Create a sublist of members whose names began with an "A."
C)Highlight cells of members who became members in a particular month.
D)Hide rows containing joining details of members who joined after a specified date.

Question 39

The _____ function allows you to use criteria such as greater than,less than,and so on,to create a sublist of required elements.

A)basic Filter
B)Custom Filter
C)Goal Seek
D)conditional formatting

Question 40

_____ highlights the information in a cell that meets some criteria you specify.

A)Basic Filter
B)Custom Filter
C)Goal Seek
D)Conditional formatting

Question 41

A list contains information displayed only in columns whereas a pivot table has information in both rows and columns.

Question 42

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?

A)$5,000
B)K14
C)K10
D)$5,000*K13

Question 43

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?

A)In the "For set" field.
B)In the "To value" field.
C)In the "Time" field.
D)In the "By changing cell" field.

Question 44

Which of the following elements of the skeletal structure of a pivot table provides a three-dimensional aspect to the pivot table?

A)PivotTable Field List
B)"Report Filter" area
C)"Row Labels" area
D)"Column Labels" area

Question 45

A column in a list can display many different types of information.

Question 46

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?

A)$20+$5+$15
B)$50+$20
C)$15+$20
D)$200

Question 47

Which of the following represents the steps for selecting the Goal Seek tool?

A)On the menu bar,click on Value Field Settings,click on Count,and select Goal Seek.
B)On the menu bar,click on Insert,and select Goal Seek.
C)On the menu bar,click on Data,then click on What-if Analysis,and select Goal Seek.
D)On the menu bar,click on Home,click on Conditional Formatting,and select Goal Seek.

Question 48

A cell is the intersection of a column and a row.

Question 49

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?

A)Report Field
B)Column Labels
C)Row Labels
D)"Values" area

Question 50

_____ is an Excel function that works backward from an objective to compute an unknown value.

A)Pivot table
B)Basic Filter
C)Custom Filter
D)Goal Seek

Question 51

Which of the following is an action which needs to be performed before using the Goal Seek tool?

A)Creation of a worksheet that includes an objective based on some unknown value in a cell.
B)Creation of dimensions of information by specifying how information is to be summarized by dimension.
C)Definitions of the dimensions of a list by dragging and dropping information labels or column headings into the row and column areas of a pivot table.
D)Entering specific criteria by which a sublist can be created containing only desired information.

Question 52

Microsoft Word is spreadsheet software that allows you to analyze any kind of information.

Question 53

In the skeletal structure of a pivot table,the _____ area is where you will drop a field of information to create pages or layers.

A)PivotTable Field List
B)Report Filter
C)Column Labels
D)Row Labels

Question 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 "By changing cell" in the Goal Seek Dialog box?

A)$5,000
B)K14
C)K10
D)$5,000*K13

Question 55

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?

A)Customer id
B)Customer income
C)Total annual expenditure
D)Annual expenditure on food

Question 56

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?

A)Adding the age field to "Column Labels"
B)Adding the age field to the "Values" field
C)Adding customer income field to "Report Filter"
D)Adding customer id to the "Values" field

Question 57

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?

A)$5,000
B)K14
C)K10
D)K13

Question 58

The first row in a list usually contains labels or row headings.

Question 59

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?

A)Report Field
B)Column Labels
C)Row Labels
D)"Values" area

Question 60

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 ____.

A)summation
B)division
C)count
D)average

Question 61

The Filter function filters a list and allows you to hide all the rows in a list except those that match criteria you specify.

Question 62

A pivot table enables you to group and summarize information.

Question 63

Conditional formatting from a list can be removed only from selected cells.

Question 64

Conditional formatting highlights the information in a cell that does not meet the criteria you specified.

Question 65

Entries in a list meeting some specific criteria can be identified using the Filter function or the conditional formatting function in Excel.

Question 66

If you cannot create a list,then you probably cannot create a list definition table.

Question 67

The Custom Filter function can create a sublist of people aged 45 and above from a list of people of varying ages.

Question 68

A list is bordered on all sides by blank rows and columns;this space identifies the end of the list.

Question 69

Conditional formatting only works for textual data.

Question 70

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.

Question 71

A list often contains blank rows to separate groups from other groups.

Question 72

Basic Filter allows you to choose to view only the information that you want;all other information can be hidden.

Question 73

A list definition table is a list of columns in a workbook with their descriptions.

Question 74

The Custom Filter function allows you to hide all the rows in a list except those that fit into a range of numbers.

Question 75

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.

Question 76

The basic Filter function can only be used to sort numeric data.

Question 77

If you wanted to see a list of every student who scored greater than 85 percent on a test,you would use the Custom AutoFilter function.

Question 78

If you wanted to see a list that displays all customers that have spent less than $20,or more than $100,in the past six months,you would use the Custom AutoFilter function.

Question 79

When using the basic Filter,you are limited to working with just one column or category of information.

Question 80

A list often contains blank columns to separate categories from other categories.