Excel Features

What is the purpose of Filtering in Excel?

• To display specific data that meets defined criteria.

• To sort data in ascending order.
• To remove duplicate entries from a dataset.
• To create charts and graphs automatically.

Which feature ensures that only specific types of data can be entered into a cell?

• Data validation
• Data sorting
• Conditional formatting
• Cell formatting

​ (a)   allows users to ​ (b)   only ​ (c)   in a worksheet based on​ (d)   , hiding the rest.

• Filtering
• display
• specific data
• criteria

Data (a)   ensures that only specific types of data can be entered into a cell. Example: In a student grade sheet, a teacher can set data validation to only allow numbers between 0 and 100 in the "Marks" column, preventing incorrect data entry.

The​ (a)   functions ​ (b)   in a ​ (c)   and return ​ (d)   data.

• VLOOKUP
• search for values
• table
• corresponding

What does VLOOKUP do in Excel?

• VLOOKUP formats cells based on their values.
• VLOOKUP calculates the sum of a range of cells.
• VLOOKUP searches for a value in the first column of a table and returns a corresponding value from a specified column.
• VLOOKUP creates charts from data in a table.

The IF function in Excel is used for what purpose?

• The IF function is used to create charts in Excel.
• The IF function is used for data sorting in Excel.
• The IF function is used to format cells in Excel.
• The IF function is used for conditional logic in Excel.

What does Conditional Formatting allow you to do?

• It provides a way to insert images into cells.
• It enables you to sort data alphabetically.
• It allows you to format cells based on specific conditions.
• It allows you to create charts and graphs.

The ​ (a)   function performs a ​ (b)   and ​ (c)   different values based on whether the ​ (d)  

• IF-THEN-ELSE
• logical test
• returns
• condition is TRUE or FALSE.

(a)   (Cond.... Form....) highlights cells based on conditions, improving data visualization. Example: A sales manager wants to highlight sales over $10,000 in green and those below $5,000 in red. Conditional formatting is applied with rules to colour the cells accordingly.