Exam 2: Solving Problems with Statistical Analysis Tools

The standard deviation tells you how closely together values are distributed.

The ADDIF function adds all the values in a range that meet specified criteria. _________________________

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

The Step button in Goal Seek ____.

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

You can recalculate a worksheet at any time by pressing the F9 function key or by selecting the Refresh button found in the Calculation group on the FORMULAS tab on the ribbon. _________________________

If you select the Paste option button called Values, you will paste only the values; the formulas and any formatting from the original cell(s) are not pasted.

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.

Wildcards do not work with values that are numbers or dates, only ____________________.

The ROUND argument num_digits is a single value that can be a constant, a cell reference where the cell contains a numerical value, or another formula that results in a single number value.

In the SUMIF function, the criteria argument identifies the cell range where the criteria are located. _________________________

Case 2-2 Nevia is using Goal Seek for the first time. She is determining what to put in each text box inside the Goal Seek dialog box shown in the above figure. -If you were to help Nevia, you would tell her that the space labeled #1 in the above figure ____.

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

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.

If you wrote the formula =ROUNDDOWN (25.83%,2), the resulting value would be ____.

Case 2-1 Julia is learning how to use relational operators with the COUNTIF function. Her boss handed her the chart in the above figure and asked her to solve some everyday business problems. -If the Human Resources director wanted a list of people who do have 100% attendance, the correct formula would be ____.

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

A technique you can use to see different parts of the screen at the same time is to ____ the window by dragging either the horizontal split box or the vertical split box to create separate, scrollable panes.

The values TRUE and FALSE are referred to as Boolean values.

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