Excel Ch.2

Goal Seek allows you to vary ____ input(s).

a single

Goal Seek continues to enter values until it reaches ____.

a. 0.001 of the goal c. either a or b b. 100 iterations

The ROUND argument, num_digits, is the specified number of ____.

decimal places

You can recalculate a worksheet at any time by pressing the ____ function key.

f9

Use ____ to copy a format from one cell to another cell or group of contiguous cells.

format painter

The technique used to fix certain rows while you scroll to other rows in a worksheet is called ____ panes.

freezing

Microsoft Excel allows you to use ____, such as LARGE, SMALL, and RANK.EQ, that help you to structure and analyze data in meaningful ways.

functions

in the Goal Seek dialog box you use the Set cell box to specify the cell ____.

in which the output value will appear

The ____ symbol(s) specify that text enclosed in between these marks should be inserted as shown.

""

The symbol ____ acts as a digit placeholder that displays significant digits.

#

The syntax of the AVERAGEIF function ____ is very similar to the SUMIF function.

(range, criteria, average_range)

The ____ symbol inserts a comma as a thousands separator or as a scaling operator.

,

If you wrote the formula, =TRUNC(-4.382,1), the resulting value would be ____.

-4.3

Consider the following five values: 1, 1, 6, 7, and 10. The arithmetic mean of these values is ____.

5

The syntax of the COUNTIF function is as follows: ____.

=COUNTIF(range, criteria)

The Paste options button option called ____ pastes the formulas and formatting from the original cell(s), but not the format of the cell borders.

No Boarders

The ____ function returns a random value between 0 and 1.

Rand()

The ____ function algorithm rounds down all values of less than half the range, and rounds up values from half the range and above.

Round

____ is a measure of how widely the data values are dispersed from the arithmetic mean.

Standard Deviation

The Paste option called ____ pastes the formulas and formatting from the original range of cells, but reverses the orientation, so that the rows of the original cell range become the columns in the pasted range, and the original columns become rows.

Transpose

The Paste options button called ____ pastes the column width of the original cell(s).

Keep Source Column Widths

The values TRUE and FALSE are referred to as ____.

Boolean values

A list of values can contain ____.

a. constants and cell references c. b. a range of cells along a column or row d. a. operational imperatives b. Boolean values The symbols > and >= are examples of ____. a. relational operators b. relational values c. base values d. syntax neutral c. arrays d. reference operators data and formulas from the original cell(s), and maintains the Keep Source Column Widths Keep Column Size a two-dimensional block of cells all of the above

Goal Seek uses ____ approach to finding the right input that achieves the desired result, or goal, in the dependent cell.

an irative

The wildcard ____ specifies that any number of characters can be substituted.

asterisk (*)

When using Goal Seek, you can specify the outcome you want and which input value you want to vary, and Excel ____.

automatically calculates the solution

the Goal Seek dialog box, the cell containing the data to vary to reach the desired output is labeled ____.

by changing the cell

____ is the arithmetic average of a set of numbers.

mean

____is the arithmetic value that occurs in the middle of a data set when organized from lowest to highest, where half the values are less than and half the values are greater than the median value.

median

____ is the arithmetic value that occurs most frequently in a data set.

mode

With a ____ function, you include that function inside another formula or function as one of its arguments.

nested

The ____ function provided by Excel averages a series of values if they meet specific criteria.

none of the above

A(n) ____ distribution exhibits an equal number of occurrences of data values both below and above the arithmetic mean.

normal

To calculate a(n) ____ between two data sets, you subtract the old value from the new value and then divide the difference by the old value.

percent difference

The symbols > and >= are examples of ____.

relational operators

____ is an analytical method that creates artificially generated data to imitate real data.

simulation

Performing a ____ analysis means, simply, to determine the outcome of changing one or more input values and to evaluate the recalculated results.

what-if

____ are symbols that you can use as part of the criteria to search for text strings in which the symbol can be substituted for another character or set of characters.

wildcards