Correct Answer:
A. To perform a logical test and return a value based on the result
The IF function in Excel is designed to perform a logical test and return a value based on the result. It allows you to specify a condition; if the condition is true, it returns one value, and if false, it returns another.
- Option B, 'To add up a range of cells,' describes the SUM function.
- Option C, 'To find the average of a range of cells,' describes the AVERAGE function.
- Option D, 'To count the number of cells in a range,' describes the COUNT or COUNTA function.
The IF function is fundamental for creating dynamic and conditional spreadsheets.