easyFPSCNTSCSSPPSCMS Office & Productivity
Answer explanation
Explanation included
Practice quiz ready
Related MS Office & Productivity MCQs
View all1The .xls extension is used for _________________________ files?2How to use drop cap in MS word?3In Microsoft Word the Superscript, subscript, outline, emboss, engrave are known as________?4The term chart wizard data in MS is refer to_________?5In a computer, element which is not a part of chart is ___________ ?6In a computer spreadsheet, value of formula (7-3)x(1+6)/4 is __________ ?
Answer and explanation
Correct Answer: A: To perform a logical test and return a value based on the result
Explanation: The correct answer is A: To perform a logical test and return a value based on the result. The IF function evaluates a condition and returns one value if TRUE and another if FALSE. Nested IF functions allow for multiple conditional tests in complex scenarios.