Mastering Excel Basics

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

• COUNT

• SUM

• MAX

• AVERAGE

How can you sort data in Excel by multiple columns?

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

• Use the 'Insert' tab to create a chart and sort data visually.

• Right-click on the data, select 'Delete', and then re-enter sorted data manually.

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

What is the purpose of the VLOOKUP function?

• To calculate the sum of a range of cells.

• To look up and retrieve data from a specific column in a table based on a matching value in the first column.

• To create a chart from a data set.

• To format cells based on their values.

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

• Select cells > Home > Data > Sort > Ascending

• Select cells > Home > Review > Comments > Add Note

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

• Select cells > Home > Format > Cell Styles > Highlight

What is a Pivot Table used for in Excel?

• A Pivot Table is used to summarize and analyze data in Excel.

• To write complex formulas and functions in Excel.

• To format cells and change colors in Excel.

• To create charts and graphs in Excel.

Which function would you use to count the number of cells that meet a specific condition?

• SUMIF

• COUNTIFS

• COUNTIF

• AVERAGEIF

How can you quickly filter data in a table?

• Use the filter function in your software to apply conditions to the data.

• Sort the data alphabetically before filtering.

• Delete unnecessary rows to reduce data size.

• Use a pivot table to summarize the data.

How can you create a drop-down list in Excel?

• Select a cell > Data > Data Validation > List > Enter items.

• Go to 'Home' tab and click 'Sort'.

• Use the 'Insert' tab to add a chart.

• Right-click on a cell and select 'Format Cells'.

What does the CONCATENATE function do in Excel?

• It combines multiple text strings into one string.

• It splits a text string into multiple parts.

• It calculates the average of a range of numbers.

• It formats numbers as currency.

What does the IFERROR function do?

• Checks if a value is even or odd

• Returns a custom value if a formula results in an error

• Checks if a cell contains text or numbers

• Finds the first error in a range