Deck 2: Solving Problems with Statistical Analysis Tools

Question 1

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

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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.

Answer 3

False

Question 4

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

Question 5

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

Question 6

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

Question 7

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

Question 8

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

Question 9

Relational operators are used to compare data.

Question 10

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 11

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 12

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

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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 19

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 20

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

Question 21

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

Question 22

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

Question 23

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

Question 24

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 25

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 26

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 27

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 28

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

Question 29

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 30

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

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

Question 31

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

Question 32

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

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

Question 33

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 34

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

Question 35

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

Question 36

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 37

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

Question 38

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

Question 39

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

Question 40

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

Question 41

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 42

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 43

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 44

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 45

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 46

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

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

Question 47

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 48

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 49

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 50

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

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 54

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 55

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 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 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 59

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 60

The ROUND argument num_digits is the specified number of ____.

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

Question 61

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

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

Question 62

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 63

The values TRUE and FALSE are referred to as ____.

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

Question 64

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 65

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

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

Question 66

The symbols > and >= are examples of ____.

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

Question 67

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 68

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

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

Question 69

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

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

Question 70

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 71

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 72

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

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

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

Question 75

The syntax of the COUNTIF function is ____.

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

Question 76

Wildcards work with ____.

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

Question 77

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 78

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

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

Question 79

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 80

____ 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