Mastering Data Management Techniques

What is the main purpose of conditional formatting in a spreadsheet?

• To change the font style of the text.

• To visually highlight data based on certain conditions.

• To delete unnecessary data.

• To create charts from data.

Which of the following is a simple conditional formatting rule?

• Highlight cells with a value greater than 50.

• Change the font size of all text to 12pt.

• Add a border to all cells.

• Convert text to uppercase.

What does "sorting data in ascending order" mean?

• Arranging data from Z to A.

• Arranging data from the largest to the smallest.

• Arranging data from the smallest to the largest.

• Arranging data based on the colour of the cells.

Which of the following is NOT a typical use of conditional formatting?

• Highlighting cells with a specific text.

• Changing the background colour of cells with negative values.

• Sorting data alphabetically.

• Highlighting duplicate values.

How can you apply conditional formatting to a range of cells in a spreadsheet?

• Select the range, go to the 'Data' tab, and choose 'Filter'.

• Select the range, go to the 'Home' tab, and choose 'Conditional Formatting'.

• Select the range, right-click, and choose 'Sort'.

• Select the range, go to the 'Insert' tab, and choose 'Chart'.

What happens when you apply a filter to a dataset in a spreadsheet?

• The dataset is permanently deleted.

• Only the rows that meet the filter criteria are displayed.

• The dataset is automatically sorted in ascending order.

• The dataset is converted into a chart.

Which of the following statements is true about sorting data in a spreadsheet?

• Sorting can only be done on numerical data.

• Sorting changes the original data permanently.

• Sorting can be done on both numerical and text data.

• Sorting requires the use of conditional formatting.

Which of the following is an example of a basic conditional formatting rule?

• Highlight cells with a value less than 10.

• Change the font colour of all text to blue.

• Add a border to all cells.

• Convert numbers to percentages.

What is the result of applying a conditional formatting rule to a cell range?

• The data in the cells is deleted.

• The cells are automatically sorted in descending order.

• The cells are highlighted based on the specified condition.

• The cells are converted into a chart.

How can you sort data by more than one column in a spreadsheet?

• Use the 'Sort' option and add multiple levels.

• Use the 'Filter' option and select multiple columns.

• Use the 'Conditional Formatting' option and apply rules to multiple columns.

• Use the 'Insert' option and create a pivot table.