Exam 2: Solving Problems with Statistical Analysis Tools

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

The values TRUE and FALSE are referred to as ____.

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

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 critical argument is essentially a test that the data must meet in order for it to be counted in the grouping. _________________________

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

The ____ symbol inserts a percentage sign and automatically multiplies the value inserted by 100 for display.

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 ____________________ Paste option button pastes a connection to the original cell, including the applied formatting.

Result Seek uses an iterative approach to finding the right input that achieves the desired result, or goal, in the dependent cell.

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

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

The Paste option button called ____ pastes the data and formulas from the original cell(s), and maintains the column width of the original cell(s).

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

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

When working with the RAND and RANDBETWEEN functions, every time you enter another value in a cell anywhere on the worksheet, the random values ____.

The Paste option called Paste Special pastes a connection to the original cells, including the applied formatting. _________________________

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

You can recalculate a worksheet at any time by pressing the ____ function key.

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