Exam 2: Solving Problems with Statistical Analysis Tools

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

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

To determine if a value is greater than or equal to another value, you can use syntax operators. _________________________

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

To split the screen both vertically and horizontally so there are five rows at the top and three columns on the left, place the cursor in the ____________________ column displayed on the screen in the sixth row of the worksheet.

The median 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. _________________________

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#1

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

Goal Seek continues to enter values until it reaches ____.

The simplest method to copy information is to first select the information you want to copy, and then use the Copy button and the Paste button in the Clipboard group on the ____ tab.

The ____________________ Paste option button pastes only the formulas from the original (copied) cell(s).

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

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

Identify the letter of the choice that best matches the function. --5

The ____ function allows you to sort a list and then count the number of entries either above or below the value in question.

Identify the letter of the choice that best matches the function. -103,200

Identify the letter of the choice that best matches the function. -24%

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

Identify the letter of the choice that best matches the function. -9

Wildcards work with ____.