Mastering Excel Basics

What is the first step to sort data in Excel?

• Click on the 'File' menu.

• Insert a new row in the spreadsheet.

• Select the range of cells to sort.

• Change the font style of the cells.

How can you sort data in ascending order?

• Sort data by randomly shuffling it.

• Use a calculator to find the average value.

• Group data into categories instead of sorting.

• Use sorting algorithms or built-in functions to arrange data from smallest to largest.

What is the shortcut key to open the Sort dialog box?

• Alt + D + S

• Shift + S

• Ctrl + S

• Alt + F + S

Can you sort data based on multiple columns?

• Sorting by multiple columns is not supported in any software.

• Yes, you can sort data based on multiple columns.

• No, sorting is only possible on a single column.

• You can only sort data if it has fewer than three columns.

What happens to the data when you sort it?

• The order of the data is rearranged based on a specified criterion.

• The data remains unchanged after sorting.

• Sorting the data deletes some of the entries.

• The data is encrypted when sorted.

What is conditional formatting used for in Excel?

• To visually highlight cells based on their values or conditions.

• To create charts and graphs automatically.

• To protect cells from being edited.

• To sort data in ascending or descending order.

How do you apply conditional formatting to a cell?

• Go to 'View' > 'Conditional Formatting' and choose a color

• Select the cell and press 'Ctrl + C' to copy it

• Select the cell, go to 'Home' > 'Conditional Formatting', choose a rule, set formatting, and click 'OK'.

• Right-click the cell and select 'Format Cells'

What type of rules can you create with conditional formatting?

• Rules can only be based on the color of the cells.

• Conditional formatting can only highlight entire rows.

• You can create rules based on cell values, text, dates, duplicates, and custom formulas.

• You can only create rules for numbers.

Can you use conditional formatting to highlight duplicate values?

• Yes, you can use conditional formatting to highlight duplicate values.

• Conditional formatting only works for text values.

• You can only highlight unique values with conditional formatting.

• No, conditional formatting cannot highlight duplicates.

What is the difference between sorting and filtering data?

• Sorting organizes data by order; filtering narrows down data by criteria.

• Sorting removes duplicates; filtering adds new data.

• Sorting changes data values; filtering sorts data by color.

• Sorting is for numerical data; filtering is only for text data.