In Excel, which function calculates the total of a range but ignores error values?
A. SUMIF
B. AGGREGATE
C. SUMPRODUCT
D. SUM
Answer: Option B
Solution (By JKSSB Mock Tests)
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.
Which keyboard shortcut allows an operator to insert an automatic line break inside an individual cell grid without moving the active cursor down into a new cell box in MS Excel?
Explanation:
Pressing Alt + Enter inserts a manual line break (starts a new line of text) inside the current cell, automatically enabling text wrapping.
No comments yet. Be the first to start the discussion!