Question 1

Which of the following is an Excel chart type?

Accepted Answer

Line Chart.

Answer

Form Chart.

Answer

Bread Chart.

Answer

Ring Chart.

Question 2

What does the Bar chart show?

Accepted Answer

It shows change, in data trend over a period of time, so it useful for comparisons between different times.

Answer

It shows match, in data trend over a period of days, so it useful for comparisons between different days.

Answer

It shows types, in data trend over a period of months, so it useful for comparisons between different months.

Answer

It shows values, in data trend over a period of weeks, so it useful for comparisons between different weeks.

Question 3

The "Source data" is one of the chart parts, so what is the source data?

Accepted Answer

It is the range of cells that make up the chart.

Answer

It is the range of columns that make up the chart.

Answer

It is the range of sheets that make up the chart.

Answer

It is the range of rows that make up the chart.

Question 4

How do you change the chart type?

Accepted Answer

1- Select the Design tab.
2- Click the Change Chart Type command. 
3- Select a type and click Ok.

Answer

1- Select the View tab.
2- Click the View Chart Type command. 
3- Select a  type and click Ok.

Answer

1- Select the Home tab.
2- Click the Change Chart Type command. 
3- Select a Chart and click Ok.

Answer

1- Select the Edit tab.
2- Click the Change Chart Type command. 
3- Select change and click Ok.

Question 5

What are the two types​ of Sorting data in Excel?

Accepted Answer

Ascending, and Descending orders.

Answer

Flitering , and Deflitering orders.

Answer

Accessing, and De-accessing orders.

Answer

Alphabet, and De-alphabet orders.

Question 6

What is a chart in Excel?

Accepted Answer

A chart is a tool you can use in Excel to communicate your data graphically.

Answer

A chart is an object you can use in Excel to desgin your data graphically.

Answer

A chart is a menu you can use in Excel to draw your data graphically.

Answer

A chart is an Edit you can use in Excel to edit and draw your data graphically.

Question 7

Why do we create chart in Excel program?

Accepted Answer

Because charts are easy to read and understand data.

Answer

Because charts are already created by Excel program.

Answer

Because charts are better than creating tables.

Answer

Because charts add more graphics to the sheet.

Question 8

What do we call the following chart image?

Accepted Answer

Pie chart

Answer

Bar chart

Answer

Doughnut chart

Answer

Pizza chart

Question 9

What command do we click on to sort or filter data on the Excel program?

Accepted Answer

Click the Sort & Filter command on the Home tab.

Answer

Click the Edit command on the Edit tab.

Answer

Click the Format  command on the Format tab.

Answer

Click the Design command on the Design tab.

Question 10

How do you remove the filtering on Excel spreadsheet?

Accepted Answer

1-  Select one of the drop-down arrows next to a filtered column.
2-  Choose Clear Filter from "Category".

Answer

1-  Select one of the drop-down arrows next to a filtered row.
2-  Click remove Filter.

Answer

1-  Select one of the drop-down arrows next to a filtered chart.
2-  Choose Clear Filter from sheet.

Answer

1-  Select one of the drop-down arrows next to a filtered table.
2-  Click delete Filter From Menu.

Related quizzes

Related quizzes