Which of the following statements about advanced Excel features is/are correct?
I. The "IF" function allows logical comparisons between values.
II. Conditional formatting can change cell appearance based on criteria.
III. Macros are used to automate repetitive tasks in Excel.

Correct option is B

All three statements are correct.
· The "IF" function allows logical comparisons between values, which is a fundamental feature of Excel.
· Conditional formatting enables users to change the appearance of cells based on specific criteria, helping in visual data analysis.
· Macros are a key feature used to automate repetitive tasks, streamlining workflow in Excel.
Important Key Points:
1. IF function: The "IF" function performs a logical test that results in one of two outcomes based on whether the condition is true or false. This makes it essential for comparison operations in Excel.
2. Conditional Formatting: This feature allows the formatting of cells to be automatically adjusted based on the values they contain, making it easier to highlight data trends and outliers.
3. Macros: Macros are a set of instructions that can be recorded in Excel to automate repetitive tasks, such as formatting cells or performing calculations, saving time and improving accuracy.