Excel Features

Front

What is the purpose of Filtering in Excel?

Back

To display specific data that meets defined criteria.

Front

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

Back

Data validation

Front

Data ______________ 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.

Back

validation

Front

What does VLOOKUP do in Excel?

Back

VLOOKUP searches for a value in the first column of a table and returns a corresponding value from a specified column.

Front

The IF function in Excel is used for what purpose?

Back

The IF function is used for conditional logic in Excel.

Front

What does Conditional Formatting allow you to do?

Back

It allows you to format cells based on specific conditions.

Front

_________________(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.

Back

Conditional Formatting

Front

What is the primary use of Pivot Tables?

Back

To summarize and analyse large datasets.

Front

Which tool is commonly used to create an interactive report by combining multiple visual elements?

Back

Dashboard

Front

What do slicers do in Excel?

Back

Provide a visual way to filter Pivot Tables and Charts