Question

QUESTION 80

A(n) mixed expense is an expense that is part variable and part fixed. _________________________

True

False

QUESTION 81

All three expense types can be classified as _______.

	a.	mixed, fixed, and CVP
	b.	variable, fixed, and cost-based
	c.	variable, fixed, and mixed
	d.	asset-based, fixed, and mixed

QUESTION 82

Aside from Solver, other Excel _______ provide the ability to perform statistical analyses, generate business reports, and retrieve financial data from the Internet.

	a.	constraint applications
	b.	parameters
	c.	add-ins
	d.	helper applications

QUESTION 83

At the break-even point, revenue equals expenses.

True

False

QUESTION 84

Audra is a manager in the Sales Department for Creative Pastry Gadgets. She needs access to up-to-date financial data and sales reports. Some of this information comes from Excel workbooks, but other information is stored in other software programs. In addition, Creative Pastry Gadgets maintains a database with detailed financial information and sales figures. Audra uses Excel to analyze data from external data sources.

Audra decides to import data so it will be stored in an external data range. She learns that Excel automatically assigns the data range a defined name based on the filename of the _______.

	a.	open source
	b.	data source
	c.	destination file
	d.	file source

QUESTION 85

Before using Scenario Manager, you should assign _______ to all the input and result cells you intend to use in your scenarios.

	a.	cells
	b.	ranks
	c.	ranges
	d.	names

QUESTION 86

By default, the PivotTable report uses the ____ function for numbers in the Values area.

	a.	COUNT
	b.	AVERAGE
	c.	MIN
	d.	SUM

QUESTION 87

CVP analysis is sometimes called breakthrough analysis. _________________________

True

False

QUESTION 88

An error value begins with a(n) _____ followed by an error name that indicates the type of error.

	a.	plus sign
	b.	number sign
	c.	exclamation point
	d.	asterisk

QUESTION 89

In Excel, a table is a range of related data that is managed independently from the data in other ____ in the worksheet.

	a.	footers and grids
	b.	rows and headers
	c.	grids and columns
	d.	rows and columns

QUESTION 90

In Solver, changing cells are sometimes referred to as _______ cells.

	a.	variable
	b.	key
	c.	constraint
	d.	self-adjusting

QUESTION 91

In a(n) _______ trend, the values change by a constant amount.

	a.	orthogonal
	b.	growth
	c.	linear
	d.	periodic

QUESTION 92

In Excel, a collection of similar data can be structured in a(n) ____ of rows and columns.

	a.	list
	b.	range
	c.	index
	d.	glossary

QUESTION 93

_______ displays an object in the destination file, but only stores the location of the source file.

	a.	Linking
	b.	Copy and Paste
	c.	Embedding
	d.	Inserting

QUESTION 94

_____ references make it easier to create formulas that use portions or all of an Excel table because the names of headers are usually simpler to identify than cell addresses.

	a.	Key
	b.	Logical
	c.	Structured
	d.	Indexed

QUESTION 95

You could test two or more conditions and determine whether all conditions are true using the _____ function.

	a.	IF
	b.	OR
	c.	THIS
	d.	AND

QUESTION 96

____ are usually represented by words with colored letters and underlines or images.

	a.	Indices
	b.	Templates
	c.	Hyperlinks
	d.	Icons

QUESTION 97

You can create a(n) ____ reference by deleting the $ from the row reference in the cell reference $B$6.

	a.	indexed
	b.	mixed
	c.	absolute
	d.	relative

QUESTION 98

When you extrapolate a series, the _______ value represents the amount that each value is increased or multiplied as the series is extended.

	a.	Step
	b.	Increase
	c.	Extension
	d.	Advance

QUESTION 99

The _______ function calculates the interest rate charged or received during each payment period.

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

QUESTION 100

The _______ period is a quick method of projecting the value of an investment.

	a.	payback
	b.	cumulative
	c.	investment
	d.	time-value

Answer 1

Answer:

80. The correct answer is True.

A mixed expense is an expense that is part variable and part fixed.

81. The correct answer is C. variable, fixed, and mixed

82. The correct answer is C. add-ins

83. The correct answer is True.

84. The correct answer is B. data source

85. The correct answer is D. names

86. The correct answer is D. SUM

87. The correct answer is False.

88. The correct answer is B. number sign

89. The correct answer is D. rows and columns

90. The correct answer is A. variable

91. The correct answer is C. linear

92. The correct answer is B. range

93. The correct answer is A. Linking

94. The correct answer is C. Structured

95. The correct answer is D. AND

96. The correct answer is C. Hyperlinks

97. The correct answer is B. mixed

98. The correct answer is A. Step

99. The correct answer is A. RATE

100. The correct answer is A. payback

Please rate the answer, it motivates us.