Exam 2: Solving Problems with Statistical Analysis Tools

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

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. -At the end of the project, Nevia is very pleased with the results and is giving a demo of Goal Seek to a few of her co-workers. To open Goal Seek, her first step is to click the ____ tab on the ribbon.

The ____________________ function counts the number of items in a range that meet specified criteria.

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

The ____ symbol(s) indicate(s) repetition of the following character enough times to fill the column to its complete width.

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

The formula =RANDBETWEEN(1,3) randomly returns a(n) ____.

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

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

The median is the arithmetic average of a set of numbers.

The ____ is the arithmetic average of a set of numbers.

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

In the function RANK.EQ(number,ref,[order]), the ____________________ argument is the range of values the number is being compared with.

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

To obtain the value for the lowest or highest Friction Coefficient values, the MIN and MAX functions would suffice. _________________________

The statistical function MODE returns the most frequently occurring value in a range of data.

With the COUNTIF function, the first time it encounters the comma delimiter, it assumes that what follows is ____.

A format code can include up to four parts, each separated by a semicolon, and does NOT include ____.

The Format Cells dialog box, which can be opened from the ____ group Dialog Box Launcher on the HOME tab, provides many options for changing the display of cell values.

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. -If the Human Resources director wanted a list of people who do have 100% attendance, the correct formula would be ____.