In MS Word, what does the 'Thesaurus' feature do? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
In Excel, which function is used to find the smallest value in a range?
Correct Answer: Option B
Explanation:
MIN returns the smallest numeric value. SMALL returns the nth smallest, MINA includes logical values, MINIFS based on criteria.
MIN returns the smallest numeric value. SMALL returns the nth smallest, MINA includes logical values, MINIFS based on criteria.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
In Excel, the 'IF' function falls under which category?
Correct Answer: Option D
Explanation:
IF is a logical function.
IF is a logical function.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
In Excel, which function calculates the total of a range but ignores error values?
Correct Answer: Option C
Explanation:
The AGGREGATE function can perform various operations (like SUM) while ignoring error values, hidden rows, etc. SUM will return an error if any cell in the range has an error. SUMIF and SUMPRODUCT also do not ignore errors.
The AGGREGATE function can perform various operations (like SUM) while ignoring error values, hidden rows, etc. SUM will return an error if any cell in the range has an error. SUMIF and SUMPRODUCT also do not ignore errors.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!