Excel Functions Quiz

Which function would you use to sum a range of cells?

• AVERAGE()

• SUM()

• COUNT()

• MAX()

What is the purpose of the FILTER function?

• To sort data alphabetically.

• To extract specific data based on criteria.

• To calculate the average of a range.

• To create charts.

Which function would you use for getting the Max number in data cell?

• AVERAGE()

• SUM()

• COUNT()

• MAX()

The first step in creating a chart is:

• Selecting a chart type.

• Selecting the data range.

• Formatting the chart.

• Entering the data.

Once the chart is created, you cannot modify its appearance. Is it true or false?

After selecting the data, you should go to the ______ tab to access chart creation tools.

What are the types of functions give at least 4