QUESTION 60

Case-Based Critical Thinking Questions

Case 5-2

Cali has just discovered the power of using text filters to control which records display in his worksheet, and he has begun to use them often to find precisely the records he needs. The following questions are based on a camp directory table that includes First Name, Last Name, Date of Birth, Camp, and Phone Number.

If Cali wants to find all of his campers named Cathy, Carla, and Carey, what should she do?

	a.	Create a text filter using the Contains operator to display all records that include Ca in the text value.
	b.	Create a text filter using the Begins With operator to display all records that have Car at the beginning of the text value.
	c.	Create a text filter using the Begins With operator to display all records that have Ca at the beginning of the text value.
	d.	Create a text filter using the Contains operator to display all records that have Ca at the beginning of the text value.

QUESTION 61

Case-Based Critical Thinking Questions

Case 5-2

Cali has just discovered the power of using text filters to control which records display in his worksheet, and he has begun to use them often to find precisely the records he needs. The following questions are based on a camp directory table that includes First Name, Last Name, Date of Birth, Camp, and Phone Number.

If Cali wants to find all of his campers whose last names end in son (such as Samson and Colson), what should he do?

	a.	Create a text filter using the Contains operator to display all records that include son in the text value.
	b.	Create a text filter using the Ends With operator to display all records that have son as the last characters in the text value.
	c.	Create a text filter using the Contains operator to display all records that have son as the last characters in the text value.
	d.	Create a text filter using the Ends With operator to display all records that have cson as the last characters in the text value.

QUESTION 62

Case-Based Critical Thinking Questions

Case 6-1

Simon is having trouble using linked workbooks, so he consults his colleague Brooke for help.

Simon tells Brooke that when he attempts to open a workbook, the Edit Links dialog box appears with the message "This workbook contains one or more links that cannot be updated." Brooke suggests several possible causes of this error message. Which of the following is a possible cause?

	a.	the workbook was sent to him without links
	b.	one of the workbook's source files was edited
	c.	one of the workbook's source files was copied to a different folder
	d.	one of the workbook's source files was replaced with an updated file of the same name

QUESTION 63

Case-Based Critical Thinking Questions

Case 6-2

Ryder has discovered the power of creating and viewing multiple workbooks.

When Ryder goes to save the workbooks, what is the required file extension?

	a.	.xlsx
	b.	.wxls
	c.	.xlww
	d.	.xlwx

QUESTION 64

Case-Based Critical Thinking Questions

Case 6-3

Your friend Jared asks you to help him learn more about using hyperlinks in an Excel workbook file.

Jared has heard that ScreenTips can be used in conjunction with hyperlinks. Which of the following statements about ScreenTips is correct?

	a.	The default ScreenTip for a hyperlink is the message "Active Hyperlink."
	b.	You can change the contents of an existing ScreenTip by changing the value in the cell.
	c.	You can specify the contents of a ScreenTip when you create a hyperlink.
	d.	They appear whenever you place the pointer over a cell.

QUESTION 65

Case-Based Critical Thinking Questions

Case 9-1

Charles is having a lot of problems with errors in a very complicated spreadsheet that he inherited from a colleague, and he turns to another co-worker, Seymour, for tips on how to trace errors in the sheet.

If Charles sees which of the following, Seymour explains, there is a mistyped function name in the sheet.

	a.	#FORM?
	b.	#NAME?
	c.	#####
	d.	#FNCT?

QUESTION 66

Case-Based Critical Thinking Questions Case 10-1 You are planning to open a new restaurant and need to determine how many dinners need to be sold to stay above the break-even point. You will investigate Cost Volume Profit (CVP), also known as break-even analysis.

First you must understand break-even analysis. The definition of break-even point is where the total revenue _______ total expenses.

	a.	equals
	b.	exceeds
	c.	is greater than
	d.	is less than

QUESTION 67

Case-Based Critical Thinking Questions Case 10-1 You are planning to open a new restaurant and need to determine how many dinners need to be sold to stay above the break-even point. You will investigate Cost Volume Profit (CVP), also known as break-even analysis.

In building an Income statement worksheet, you will calculate variable and fixed expenses based on number of meals sold. To explore the impact of changing different values in the worksheet, you can use _______.

	a.	Cash Flow analysis
	b.	Solver manager
	c.	What-If analysis
	d.	Income Statement Analysis

QUESTION 68

Cash flow is concerned with the direction of money as it moves in and out of a company.

True

False

1 points

QUESTION 69

Critical Thinking Case-Based Questions

Case 5-3

As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.

Ted wants to be able to analyze date data in his PivotTable by month. What must he do with the date field in his PivotTable?

	a.	He must group the data by the date field.
	b.	He must sort the data by the date field.
	c.	He must aggregate the data by the date field.
	d.	He must cluster the data by the date field.

QUESTION 70

Critical Thinking Case-Based Questions

Case 5-3

As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.

If Ted decides that he wants to work with nonnumeric data in his PivotTable, what function must he use to produce summaries?

	a.	Total
	b.	Aggregate
	c.	Sum
	d.	Count

QUESTION 71

Critical Thinking Case-Based Questions

Case 5-3

As he prepares his assignment for his Marketing class, Ted goes to his friend Carter for help with PivotTables because Carter has had a lot of experience with them in his job.

Ted wants to use his PivotTable to show the total value of the motorcycles for a series of motorcycle dealerships but he wants to filter the display to show only those dealers whose total stock of motorcycle is greater than $1 million. How would he accomplish this?

	a.	He would develop a PivotTable using the value filter.
	b.	He would develop a PivotTable using the category filter.
	c.	He would develop a PivotTable using the aggregate filter.
	d.	He would develop a PivotTable using the report filter.

QUESTION 72

Databases in which tables can be joined through the use of common fields are known as _______ databases.

	a.	linked
	b.	relational
	c.	structured
	d.	trusted

QUESTION 73

Encryption is the process by which a file is encoded so that it cannot be opened without the proper password. _________________________

True

False

QUESTION 74

To calculate a series of values from a starting point without a defined ending point, you have to _______ the values.

	a.	interpolate
	b.	plot
	c.	extrapolate
	d.	assess

QUESTION 75

To calculate the number of montly payments required to pay off a loan or meet an investment goal, use the _______ function.

	a.	PMT
	b.	FV
	c.	NPER
	d.	PPMT

QUESTION 76

To calculate the number of quarterly payments required to pay off a loan, use the _______ function.

	a.	PV
	b.	PMT
	c.	FV
	d.	NPER

QUESTION 77

A(n) _______ is a file that stores a collection of related data.

	a.	database
	b.	register
	c.	table
	d.	index

QUESTION 78

A(n) _______ might ask something like, "What are the names of all the stocks in the portfolio, and what are their corresponding ticker symbols?"

	a.	index
	b.	register
	c.	query
	d.	matrix

QUESTION 79

A(n) _______ worksheet projects the companys expected assets, liabilities, and equity.

	a.	Transactions
	b.	Asset Report
	c.	Income Statement
	d.	Balance Sheet