What type of validation error code is returned by MS Excel if a cell formula uses an unrecognized function name, such as =SUUM(A1:A2)? MCQ with Answer and Explanation
What type of validation error code is returned by MS Excel if a cell formula uses an unrecognized function name, such as =SUUM(A1:A2)?
A. #NULL!
B. #NAME?
C. #REF!
D. #VALUE!
Answer: Option B
Solution (By JKSSB Mock Tests)
The #NAME? error occurs when Excel does not recognize text within a formula, which is typically caused by a misspelled function name or a missing quote around a text string.
In MS PowerPoint, what key should you hold down while drawing a geometric shape with the mouse cursor to ensure its aspect ratio stays constrained into a perfect circle or square?
Explanation:
Holding the Shift key down while dragging constrains the aspect ratio of shapes, forcing rectangles to become perfect squares and ovals to become perfect circles.
No comments yet. Be the first to start the discussion!