Exam 2: Solving Problems with Statistical Analysis Tools

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

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

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

Case-Based Critical Thinking Questions 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. -Julia wants to take a count of all employees who are participating in more than one committee. The data is listed in column F of a worksheet. The correct formula would be ____.

Case-Based Critical Thinking Questions 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. -After showing her boss the data, he asked her to run one more COUNTIF to determine who is on one or more committees. The correct formula would be ____.

To split an Excel window vertically, click the ____________________ after clicking to the right and below the location where you want to divide the window.

Case-Based Critical Thinking Questions 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. -Nevia's boss stops by her desk and asks which of the three numbers in the above figure is considered to be the dependent data, and she correctly answers ____.

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

Microsoft Excel provides a variety of predefined functions, including statistical functions, that you can use to determine such values as the arithmetic mean, median, mode, and standard deviation of a set of data.

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

Excel provides several tools for displaying and scrolling columns and/or rows so that certain areas can be fixed, or ____________________, and the remainder of the worksheet can be scrolled easily.

Describe what the arguments are for this function: =SUMIF(range,criteria,sum_range).

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

The input for Goal Seek can be ____.

A simulation that is based on randomly generating specific values that have an equal chance of appearing, such as numbers on a set of dice, is often referred to as a ____ simulation.

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

The Paste option called ____ pastes the contents of the copied cells(s) as a picture.

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

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

The ____ function randomly assigns a number between two specified values.