What is the purpose of the IF function in Microsoft Excel?

Computer Mcqs for PPSC, FPSC, NTS, and Pakistan government job tests. Select an option below, then read the explanation.

PPSCFPSCNTSPakistan govt jobs
Subject
Computer Mcqscomputer-mcqs
Published
1 Jan 2023
Last updated
28 May 2026

Browse all Computer Mcqs

Choose the correct answer

Explanation

Option A is correct because the IF function tests a condition and returns one value if the condition is true and another if it is false. Options B, C, and D describe other Excel functions such as SUM, AVERAGE, and COUNT, respectively.

SolveExam — free MCQs and past papers for Pakistan government job tests. Content is for educational practice only.