Deck 2: Solving Problems with Statistical Analysis Tools

Question 1

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

Answer 1

False

Question 2

The SMALL function determines the nth smallest value in a range.

Answer 2

True

Question 3

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

Answer 3

True

Question 4

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.

Question 5

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

Question 6

Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision, which is six digits, to whatever format is displayed in that cell.

Question 7

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

Question 8

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.

Question 9

With the LARGE function, the argument called analysis describes the range of cells being evaluated.

Question 10

Relational operators are used to compare data.

Question 11

The syntax of the RANK.EQ function is as follows: RANK(number,sort,order).

Question 12

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.

Question 13

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

Question 14

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

Question 15

A way to analyze the differences between two sets of data is to look at the percent difference of a value in one data set compared with that value in the second data set.

Question 16

The Format Painter can be used to copy a format into multiple noncontiguous cells.

Question 17

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

Question 18

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

Question 19

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

Question 20

The Paste Special dialog box offers Operation options, which allow you to paste values using only three arithmetic operations: Add, Subtract, and Multiply.

Question 21

The BIG function determines the nth largest value in a range. _________________________

Question 22

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

Question 23

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

Question 24

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

Question 25

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

Question 26

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

A) mean
B) median
C) mode
D) standard deviation

Question 27

The critical argument is essentially a test that the data must meet in order for it to be counted in the grouping. _________________________

Question 28

The ____ is the arithmetic value that occurs most frequently in a data set.

A) mean
B) median
C) mode
D) standard deviation

Question 29

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

Question 30

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

A) mean
B) median
C) mode
D) standard deviation

Question 31

The COUNTIF function accommodates a(n) single contiguous range argument. _________________________

Question 32

Wingdings are symbols that you can use as part of the criteria to search for text strings; each symbol can be substituted for a character or set of characters. _________________________

Question 33

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

Question 34

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

Question 35

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

Question 36

Excel uses the Goal Find tool to try various input values in order to calculate the required input to achieve your desired outcome. _________________________

Question 37

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

Question 38

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

Question 39

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

A) functions
B) charts
C) rules
D) arguments

Question 40

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

A) mean
B) median
C) mode
D) standard deviation

Question 41

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

A) Keep Source Formatting
B) No Borders
C) Document Theme
D) Destination Formatting

Question 42

With a ____ function, you include that function inside another formula or function as one of its arguments.

A) nested
B) parent
C) child
D) linked

Question 43

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

A) Picture
B) As Picture
C) Paste Picture
D) Paste Graphic

Question 44

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

A) freezing
B) sticking
C) keeping
D) locking

Question 45

The Paste option called ____ pastes the formulas and formatting from the original range of cells, but reverses the orientation so that the rows of the original cell range become the columns in the pasted range, and the original columns become rows.

A) Transpose
B) Switch
C) Wildcard
D) Turn

Question 46

Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision (____ digits) to whatever format is displayed in that cell, including the number of decimal places.

A) 5
B) 9
C) 15
D) 21

Question 47

A list of values can contain ____.

A) constants and cell references
B) a range of cells along a column or row
C) a two-dimensional block of cells
D) all of the above

Question 48

A(n) ____ distribution exhibits an equal number of occurrences of data values both below and above the arithmetic mean.

A) normal
B) skewed
C) simulated
D) angular

Question 49

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

A) 26%
B) 25%
C) 25.8%
D) 25.83%

Question 50

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

A) the Format Painter
B) the Format Copier
C) Paint
D) Special Format

Question 51

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.

A) FORMAT
B) HOME
C) INSERT
D) DATA

Question 52

The MODE.SNGL, MEDIAN, and STDEV.S functions work in a similar way, containing only one type of argument, which is ____.

A) sort order
B) a list of values
C) a range of values for comparison
D) ranking parameters

Question 53

The ____ of a normal distribution are the same value.

A) mean, median, and mode
B) mean and median
C) mean, median, mode, and standard deviation
D) median and mode

Question 54

The Paste Special dialog box offers the ____ option, which enables you to copy and paste a cell range that contains one or more blank cells where the blank cells are not pasted over any existing values in the range into which they are pasted.

A) Copy Blanks
B) Blank Over
C) Comments
D) Skip Blanks

Question 55

The ROUND argument num_digits is the specified number of ____.

A) decimal places
B) digits
C) integers
D) operators

Question 56

Consider the following five values: 1, 1, 6, 7, and 10. The arithmetic mean of these values is ____.

A) 1
B) 3.94
C) 5
D) 6

Question 57

If you wrote the formula =TRUNC(-4.382,1), the resulting value would be ____.

A) -4
B) -4.3
C) -4.38
D) -4.382

Question 58

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

A) AVERAGE
B) NORMAL
C) DOWN
D) ROUND

Question 59

If you wrote the formula =ODD(1.23), the resulting value would be ____.

A) 1
B) 2
C) 3
D) 4

Question 60

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

A) Column Stay
B) Width Only
C) Keep Source Column Widths
D) Keep Column Size

Question 61

The ____ symbol acts as a digit placeholder that displays significant digits.

A) #
B) 0
C) ?
D) %

Question 62

In the SMALL function, the first argument, array, is ____.

A) a formula
B) the desired ranking
C) a range of cells
D) a time period

Question 63

The ____ symbol acts as a digit placeholder that displays both significant and insignificant zeros.

A) #
B) 0
C) ?
D) %

Question 64

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

A) Wingdings
B) Wildwheels
C) Open Text symbols
D) Wildcards

Question 65

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

A) ,
B) *
C) ""
D) @

Question 66

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

A) asterisk (*)
B) question mark (?)
C) forward slash (/)
D) backward slash (\)

Question 67

The syntax of the COUNTIF function is ____.

A) =COUNTIF(range,array)
B) =COUNTIF(ref,range)
C) =COUNTIF(array,k)
D) =COUNTIF(range,criteria)

Question 68

The ____ symbol acts as a digit placeholder that does not display insignificant digits, but does hold a place so that decimal points will align.

A) #
B) 0
C) ?
D) %

Question 69

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

A) negative number format
B) positive number format
C) zero value format
D) placeholder format

Question 70

The values TRUE and FALSE are referred to as ____.

A) operational imperatives
B) Boolean values
C) base values
D) syntax neutral

Question 71

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.

A) average difference
B) standard deviation difference
C) percent difference
D) none of the above

Question 72

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.

A) Cells
B) Data
C) Number
D) Data

Question 73

In the LARGE function, the second argument, k, is the desired ranking, where 1 is ____.

A) the largest value
B) the smallest value
C) required
D) not allowed

Question 74

Wildcards work with ____.

A) numbers
B) dates
C) text
D) all of the above

Question 75

The ____ wildcard specifies that a single character can be substituted.

A) asterisk (*)
B) question mark (?)
C) forward slash (/)
D) backward slash (\)

Question 76

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

A) a date
B) a number
C) additional ranges
D) the criteria

Question 77

The ____ function allows you to sort a list and then count the number of entries either above or below the value in question.

A) RANK.EQ
B) POSITION
C) FIND
D) COUNT

Question 78

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

A) #
B) 0
C) ?
D) %

Question 79

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.

A) split
B) delete
C) crack
D) separate

Question 80

The symbols > and >= are examples of ____.

A) relational operators
B) relational values
C) arrays
D) reference operators