Question 1

What feature in Excel allows you to arrange data in a specific order?

Accepted Answer

Sorting

Answer

Formatting

Answer

Filtering

Answer

Charting

Question 2

Which Excel feature helps you to display only the data that meets certain criteria?

Accepted Answer

Filtering

Answer

Sorting

Answer

Charting

Answer

Calculating

Question 3

What type of visual representation can you create in Excel to show data trends over time?

Accepted Answer

Chart

Answer

Table

Answer

Formula

Answer

Filter

Question 4

What Excel tool would you use to combine data from multiple cells into one cell?

Accepted Answer

Concatenate

Answer

Filter

Answer

Chart

Answer

Sort

Question 5

Which function in Excel would you use to find the average of a set of numbers?

Accepted Answer

AVERAGE

Answer

MAX

Answer

COUNT

Answer

SUM

Question 6

When you apply a filter in Excel, what happens to the data that does not meet the filter criteria?

Accepted Answer

It gets hidden temporarily

Answer

It is deleted

Answer

It changes color

Answer

It is sorted

Question 7

What type of chart would be best to compare parts of a whole in Excel?

Accepted Answer

Pie chart

Answer

Line chart

Answer

Bar chart

Answer

Scatter plot

Question 8

In Excel, which feature allows you to display trends and changes across different categories over time?

Accepted Answer

Line chart

Answer

Bar chart

Answer

Pie chart

Answer

Histogram

Question 9

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

Accepted Answer

COUNT

Answer

SUM

Answer

AVERAGE

Answer

COUNTA

Question 10

What is the purpose of filtering data in Excel?

Accepted Answer

To display only certain information based on criteria

Answer

To delete data permanently

Answer

To create a new workbook

Answer

To change the color of cells

Question 11

In Excel, which function would you use to arrange numbers from smallest to largest?

Accepted Answer

Sort Ascending

Answer

Create Chart

Answer

Sort Descending

Answer

Filter Data

Related quizzes

Related quizzes