GMetrix Exam GMetrix Excel: Formulas and Functions 2 — Questions and Answers
Question 1: Which function returns the position of a value within a range?
- SEARCH
- MATCH (Correct answer)
- INDEX
- FIND
Correct answer: MATCH
MATCH returns the relative position of a lookup value within a range.
Question 2: What does the formula =INDEX(A1:A10, 3) return?
- The value in cell A3 (Correct answer)
- The value at row 3 column 3
- The 3rd match in A1:A10
- An error
Correct answer: The value in cell A3
INDEX returns the value at the specified row position within the given range, so row 3 of A1:A10 is A3.
Question 3: Which function counts cells that contain numbers?
- COUNTA
- COUNTIF
- COUNT (Correct answer)
- COUNTBLANK
Correct answer: COUNT
COUNT counts only cells that contain numeric values, while COUNTA counts all non-empty cells.
Question 4: What is the result of =MOD(17, 5)?
- 3
- 2 (Correct answer)
- 4
- 5
Correct answer: 2
MOD returns the remainder after division, and 17 divided by 5 is 3 remainder 2.
Question 5: Which function rounds a number DOWN to the nearest integer?
- ROUND
- INT (Correct answer)
- FLOOR
- TRUNC
Correct answer: INT
INT always rounds a number down to the nearest integer, even for negative numbers.
Question 6: What does =CONCATENATE("Hello", " ", "World") return?
- HelloWorld
- Hello World (Correct answer)
- Hello World
- HELLO WORLD
Correct answer: Hello World
CONCATENATE joins all text arguments in order, including the space character in the middle.
Question 7: Which function extracts a substring from the middle of a text string?
- LEFT
- RIGHT
- MID (Correct answer)
- TRIM
Correct answer: MID
MID extracts characters starting at a specified position for a given number of characters.
GMetrix Exam GMetrix Excel: Formulas and Functions 2
Which function returns the position of a value within a range?