Which specific MS Excel function evaluates whether a condition is satisfied and outputs one value if true, and a different designated value if false? MCQ with Answer and Explanation
Question
Report Error
Discuss this Question (0)
Practice More Microsoft Office Questions
Question #1
Report Error
To create a hanging indent in MS Word, press:
Correct Answer: Option C
Explanation:
Ctrl+T creates/increases hanging indent. Ctrl+Shift+T decreases.
Ctrl+T creates/increases hanging indent. Ctrl+Shift+T decreases.
This question belongs to:
Computer
Microsoft Office
Question #2
Report Error
Which of the following is NOT a valid Excel number format category?
Correct Answer: Option B
Explanation:
Phone Number is not a standard category; you can create a custom format but it's not a built-in category. General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, Custom are categories.
Phone Number is not a standard category; you can create a custom format but it's not a built-in category. General, Number, Currency, Accounting, Date, Time, Percentage, Fraction, Scientific, Text, Special, Custom are categories.
This question belongs to:
Computer
Microsoft Office
Question #3
Report Error
In Excel, the 'Go To Special' dialog can be opened by:
Correct Answer: Option A
Explanation:
F5 opens Go To, then click Special. Alternatively, Home > Find & Select > Go To Special.
F5 opens Go To, then click Special. Alternatively, Home > Find & Select > Go To Special.
This question belongs to:
Computer
Microsoft Office
No comments yet. Be the first to start the discussion!