Question 1

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#1
A)Counts all Inspector IDs that contain the text value "1" anywhere in the value (A313, C321, B313, and so on)
B)Counts all Inspector IDs that end with the text value "3"
C)Counts all Inspector IDs that have the value "3" in the third-to-last position in the text value, regardless of the number of preceding characters
D)Counts all Inspector IDs with a single character followed by the characters "313"; notice that cell H7 is not counted because it contains two characters preceding the characters "313"

Accepted Answer

The answer of MATCHING
  
Using the above figure, identify...

Question 2

The ____________________ Paste option button pastes a connection to the original cell, including the applied formatting.

Accepted Answer

The answer of The ____________________ Paste option button pastes a...

Question 3

The relational operator >= stands for ____________________ than or equal to.

Accepted Answer

The answer of The relational operator >= stands for ____________________...

Question 4

Identify the letter of the choice that best matches the function.
-24%
A)=ROUND(25.449,0)
B)=ROUND(SUM(10.33,10.44),0)
C)=ROUND(25.33%,2)
D)=INT(-4.3)
E)=ROUND(103234,-2)
F)=ROUND(23.75%,2)
G)=ROUNDDOWN(9.99,0)
H)=EVEN(2.23)

Accepted Answer

ROUND(23.75%,2) correctly represents 24% when expressed as a decimal (0.24) and rounded to two decimal places.

Question 5

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 answer of To calculate a(n) ____________________ between two data...

Question 6

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#3
A)Counts all Inspector IDs that contain the text value "1" anywhere in the value (A313, C321, B313, and so on)
B)Counts all Inspector IDs that end with the text value "3"
C)Counts all Inspector IDs that have the value "3" in the third-to-last position in the text value, regardless of the number of preceding characters
D)Counts all Inspector IDs with a single character followed by the characters "313"; notice that cell H7 is not counted because it contains two characters preceding the characters "313"

Accepted Answer

The answer of MATCHING
  
Using the above figure, identify...

Question 7

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

Accepted Answer

The answer of Up to four different format codes can...

Question 8

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

Accepted Answer

The answer of The ____________________ function counts the number of...

Question 9

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

Accepted Answer

The answer of To split an Excel window vertically, click...

Question 10

Performing a(n) ____________________ analysis means, simply, to determine the outcome of changing one or more input values and to evaluate the recalculated results.

Accepted Answer

The answer of Performing a(n) ____________________ analysis means, simply, to...

Question 11

Wildcards do not work with values that are numbers or dates, only ____________________.

Accepted Answer

The answer of Wildcards do not work with values that...

Question 12

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#4
A)Counts all Inspector IDs that contain the text value "1" anywhere in the value (A313, C321, B313, and so on)
B)Counts all Inspector IDs that end with the text value "3"
C)Counts all Inspector IDs that have the value "3" in the third-to-last position in the text value, regardless of the number of preceding characters
D)Counts all Inspector IDs with a single character followed by the characters "313"; notice that cell H7 is not counted because it contains two characters preceding the characters "313"

Accepted Answer

The value "3" appears in the third-to-last position of all the Inspector IDs in the given figure, regardless of the number of characters preceding it. Therefore, option C is the correct choice. Options A and D are not correct because they do not apply to all of the Inspector IDs in the figure, and option B is not correct because not all Inspector IDs end with the value "3".

Question 13

MATCHING
  
Using the above figure, identify the letter of the choice that best matches the figure.
-#2
A)Counts all Inspector IDs that contain the text value "1" anywhere in the value (A313, C321, B313, and so on)
B)Counts all Inspector IDs that end with the text value "3"
C)Counts all Inspector IDs that have the value "3" in the third-to-last position in the text value, regardless of the number of preceding characters
D)Counts all Inspector IDs with a single character followed by the characters "313"; notice that cell H7 is not counted because it contains two characters preceding the characters "313"

Accepted Answer

Counts all Inspector IDs that contain the text value "1" anywhere in the value (A313, C321, B313, and so on)

Question 14

Excel provides several tools for displaying and scrolling columns and/or rows so that certain areas can be fixed, or ____________________, and the remainder of the worksheet can be scrolled easily.

Accepted Answer

The answer of Excel provides several tools for displaying and...

Question 15

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

Accepted Answer

The answer of When you ____________________ a function, you include...

Question 16

The ______________________________ Paste option button pastes values from the original cell(s) and formatting.

Accepted Answer

The answer of The ______________________________ Paste option button pastes values...

Question 17

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.

Accepted Answer

The answer of To split the screen both vertically and...

Question 18

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

Accepted Answer

The answer of The MODE.SNGL, MEDIAN, and STDEV.S functions work...

Question 19

When the # symbol acts as a placeholder for a digit, it is considered to be a(n) ____________________ code.

Accepted Answer

The answer of When the # symbol acts as a...

Question 20

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

Accepted Answer

The answer of In the function RANK.EQ(number,ref,[order]), the ____________________ argument...

Quiz 2: Solving Problems with Statistical Analysis Tools

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#1