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

Verified
Correct Answer:
Verified
Q14: The _ function provided by Excel averages
Q44: Case-Based Critical Thinking Questions<br>Case 2-1<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg"
Q51: Excel provides several tools for displaying and
Q62: Case-Based Critical Thinking Questions<br>Case 2-2<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg"
Q75: To obtain the value for the lowest
Q81: The syntax of the AVERAGEIF function _
Q87: Identify the letter of the choice that
Q93: When the # symbol acts as a
Q104: The Paste option button option called _
Q112: With a _ function, you include that