Mastering Excel Skills

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

• AVERAGE

• MAX

• SUM

• COUNT

How do you create a pie chart in Excel?

• Select data, go to 'File' > 'New Chart', choose pie.

• Select data, go to 'Insert' > 'Pie Chart', choose style.

• Right-click data, choose 'Create Chart', and select pie style.

• Highlight data, click on 'Data' > 'Chart Options', select pie.

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

• Ctrl + S

• Alt + S + A

• Alt + A + S + A

• Shift + A + S

Which formula would you use to count the number of cells that contain numbers?

• MAX(range)

• COUNT(range)

• SUM(range)

• AVERAGE(range)

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

• Select cells > Data > Filter > Set criteria > Apply filter.

• Right-click cells > Format Cells > Choose color > Click OK.

• Select cells > Home > Styles > Cell Styles > Choose a style.

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

What is the purpose of the VLOOKUP function in Excel?

• To calculate the sum of a range of cells.

• To format cells based on their values.

• To create a chart from a data set.

• To search for a value in a table and return a corresponding value from another column.

How do you filter data to show only specific entries in a table?

• Sort the table to rearrange the data.

• Use a query with conditions to filter entries, e.g., SELECT * FROM table WHERE condition.

• Export the table to a different format.

• Use a spreadsheet to manually delete unwanted entries.

What type of chart would you use to compare different categories of data?

• Scatter plot

• Bar chart

• Line chart

• Pie chart

Which function would you use to concatenate two text strings in Excel?

• MERGE

• APPEND

• JOIN

• CONCATENATE or &

How can you sort data by multiple columns in Excel?

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

• Use the 'Insert' tab to create a new column and manually enter sorted values.

• Highlight the data, right-click, and select 'Delete' to remove duplicates.

• Select data range, go to 'Home' tab, click 'Format', and choose 'Sort' option.