Question 1

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

Accepted Answer

The answer of The ____ symbol acts as a digit...

Question 2

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

Accepted Answer

The first argument of the SMALL function must be the range of cells containing the values for which you want to retrieve the nth smallest value.

Question 3

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

Accepted Answer

The (0) symbol acts as a digit placeholder that displays both significant and insignificant zeros. The (#) symbol is a digit placeholder that displays only significant digits. The (?) symbol is not a valid digit placeholder symbol, and the (%) symbol is used to display percentages.

Question 4

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

Accepted Answer

The term "wildcards" refers to symbols that can be used in a search to represent one or more characters. For example, the * can represent any number of characters, while the ? can represent a single character. Using wildcards can make searching for text strings more flexible and efficient.

Question 5

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

Accepted Answer

The comma symbol (,) is commonly used as a thousands separator in numbers to make them easier to read. It can also be used as a scaling operator in some programs.

Question 6

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

Accepted Answer

The asterisk (*) is known as the wildcard character that represents any number of characters, including none. It can be used to match zero or more characters in a filename or path.

Question 7

The syntax of the COUNTIF function is ____.

Accepted Answer

The correct syntax for the COUNTIF function is =COUNTIF(range, criteria), where range is the range of cells to be evaluated and criteria is the condition or criteria in the form of a number, expression, cell reference, or text string that determines which cells to count. Therefore, choice D is the best option as it matches the correct syntax of the COUNTIF function.

Question 8

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

Accepted Answer

The answer of The ____ symbol acts as a digit...

Question 9

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

Accepted Answer

The format code can include up to four parts: positive number format, negative number format, zero value format, and placeholder format. However, the question explicitly states that the format code does NOT include placeholder format.

Question 10

The values TRUE and FALSE are referred to as ____.

Accepted Answer

The values TRUE and FALSE are known as Boolean values, named after George Boole who created the Boolean algebra. They represent truth and falsehood in logic and are fundamental in programming. Choice A, C, and D are not accurate descriptions of TRUE and FALSE.

Question 11

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.

Accepted Answer

The calculation described in the question is the formula for percent difference. Therefore, the correct choice is C. Choice A is incorrect because it refers to the average of differences between data sets, which is not being calculated. Choice B is incorrect because it refers to a measure of dispersion, which is also not being calculated. Lastly, Choice D is incorrect because one of the choices must be correct.

Question 12

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.

Accepted Answer

The Format Cells dialog box provides options for changing the display of numeric values, such as decimal places, currency symbols, and thousands separators. Therefore, the best choice is C, which is the Number group. A, B, and D do not lead to the Format Cells dialog box.

Question 13

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

Accepted Answer

The second argument in the LARGE function, k, represents the desired ranking, where 1 corresponds to the largest value. Therefore, the correct choice is A, as this statement is true.

Question 14

Wildcards work with ____.

Accepted Answer

Wildcards are used with text to search for characters or patterns within a string of text. They are not used with numbers or dates.

Question 15

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

Accepted Answer

The question mark ('?') is the wildcard that specifies a single character can be substituted, while an asterisk is used to represent any number or character sequence, and forward slash and backward slash are not wildcards.

Question 16

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

Accepted Answer

The comma after the range argument in the COUNTIF function is used to separate the criteria argument from the range argument. Therefore, what follows the comma is the criteria argument, not a date, number or additional ranges.

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

The (%) symbol is the best choice because it inserts a percentage sign and automatically multiplies the value by 100 for display. This is the standard symbol used in Excel for displaying percentages.

Question 19

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.

Accepted Answer

The term "split" accurately describes the process of creating separate panes on the screen, which can be scrolled independently of each other. The other options do not accurately describe this technique.

Question 20

The symbols > and >= are examples of ____.

Accepted Answer

The symbols > and >= are known as relational operators in programming. They are used to compare two values and return a boolean value (true or false) based on the comparison result.

Quiz 2: Solving Problems with Statistical Analysis Tools