Mastering Excel Data Management

What is the shortcut key to sort data in ascending order in Excel?

• Alt + A + S + A

• Ctrl + S

• Shift + A + S

• Alt + S + A

How can you sort data by multiple columns in Excel?

• Select data, go to Data tab, click Sort, add levels for multiple columns, and click OK.

• Use the Find feature to locate specific data and sort it manually.

• Right-click on the data, select Filter, and choose a sorting option.

• Select data, go to Home tab, click Format, and choose a color scheme.

What is the purpose of the Filter feature in Excel?

• To create a chart from the data.

• To sort the data in ascending order.

• To calculate the sum of a dataset.

• To display only the rows that meet specific criteria in a dataset.

How do you apply a filter to a specific range of data in Excel?

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

• Select the entire sheet, go to 'Home' tab, click 'Sort'.

• Highlight the range, right-click, and choose 'Delete'.

• Click on 'View' tab, then select 'Freeze Panes' for the range.

Which function would you use to find the average of a range of cells in Excel?

• SUM

• AVERAGE

• COUNT

• MAX

What is the difference between the COUNT and COUNTA functions in Excel?

• COUNT counts only numeric cells; COUNTA counts all non-empty cells.

• COUNT counts unique values; COUNTA counts duplicates.

• COUNT counts text cells; COUNTA counts only empty cells.

• COUNT counts all cells; COUNTA counts only numeric cells.

How can you create a Pivot Table in Excel?

• Select data, go to 'Data' > 'Sort', and apply filters.

• Click on 'File' > 'New' > 'Pivot Table', and save the document.

• Select data, go to 'Insert' > 'PivotTable', choose location, and arrange fields.

• Highlight data, right-click, and choose 'Create Chart' to visualize.

What is the purpose of a Pivot Table in data analysis?

• To create visual charts from data

• To store data in a database

• To perform complex mathematical calculations

• The purpose of a Pivot Table is to summarize and analyze data effectively.

How do you apply conditional formatting to highlight cells greater than a certain value?

• Right-click cells > Format Cells > Number > Set value > OK.

• Select cells > Home > Data > Sort > Ascending > Apply > OK.

• Select cells > Home > Conditional Formatting > Clear Rules > Apply > OK.

• Select cells > Home > Conditional Formatting > New Rule > Format cells that are greater than > Enter value > Set format > OK.

What is the function of Data Validation in Excel?

• To automatically generate formulas in Excel.

• To create charts and graphs from data.

• To format cells with colors and borders.

• To restrict and control the type of data entered in Excel cells.