Question 1

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 given figure shows the Inspector ID in the format of a string. In option C, we are counting all the Inspector IDs that have the value "3" in the third-to-last position in the text value, regardless of the number of preceding characters. In our given figure, we can see that the Inspector IDs A313, B313, C321 have the value "3" in the third-to-last position. Therefore, option C is the correct choice. Option A is incorrect as it counts all Inspector IDs that contain the text value "1" anywhere in the value, which is not mentioned in the figure. Option B is incorrect as it counts all Inspector IDs that end with the text value "3", which does not include Inspector ID C321. Option D is incorrect as it counts all Inspector IDs with a single character followed by the characters "313", which includes H7 that has two characters before "313".

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

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 5

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 6

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 7

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

Question 8

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 9

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 10

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 11

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 12

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

The function ROUND(23.75%,2) rounds the percentage 23.75% to two decimal places, resulting in 24%.

Question 13

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 14

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

Accepted Answer

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

Question 15

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 16

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 17

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 18

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 19

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 20

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

Quiz 2: Solving Problems with Statistical Analysis Tools

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