Home »
MCQs »
Google Sheets MCQs
Which function is used to find the most common value(s)?
24. Which function is used to find the most common value(s)?
- SNGL()
- MULT()
- Both A and B
- None of the above
Answer: C) Both A and B
Explanation:
Both MODE.SNGL() and MODE.MULT() functions are used to find the most common value(s).
=MODE.SNGL(value1, [value2, ...])
=MODE.MULT(value1, [value2, ...])