Exam 2: Solving Problems with Statistical Analysis Tools

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

In the function RANK.EQ(number,ref,order), the number argument refers to the value to be ranked. _________________________

Once the Goal Seek Status dialog box gives the target value, you can click ____ to update your worksheet with the new values based on Goal Seek.

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

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

The formula =ROUNDUP(3.432,1) rounds the value 3.432 up to the next highest tenth, or 3.5.

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 exactly one committee. The correct formula would be ____.

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

The RANDOM function randomly assigns a number between two specified values. _________________________

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

To specify that a value should be precisely stored to the nearest hundredth, use the ____________________ function.

The ____ symbol(s) insert(s) a comma as a thousands separator or as a scaling operator.

Wildcards work with ____.

The symbols > and >= are examples of ____.

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

Up to four different format codes can be applied to a cell: one for positive numbers, one for negative numbers, one for zero values, and one for ____________________.

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

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

Explain what the following four number formatting codes do when used in Excel: #, 0, ?, and %. Write one sentence about each symbol and give an example of how it can be used.

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