Multiple Choice
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"
Correct Answer:

Verified
Correct Answer:
Verified
Q81: The syntax of the AVERAGEIF function _
Q82: When working with the RAND and RANDBETWEEN
Q83: If you wrote the formula =ODD(1.23), the
Q84: The _ symbol indicates to skip the
Q85: With the LARGE function, the argument called
Q87: The critical argument is essentially a test
Q88: If you select the Paste option button
Q89: The _ symbol inserts a percentage sign
Q90: Up to four different format codes can
Q91: _ is a measure of how widely