Excel kviz

Which Excel feature is used to create the second list from the first list above?

• a.

  Filtering

• b.

  Sorting

• c.

  Functions

• d.

  Forms

• e.

  Listing

If you click OK, What will be the new order?

• a.

  Tarik

  Faruk

  Haris

  Dino

• b.

  Dino

  Haris

  Faruk

  Tarik

• c.

  Tarik

  Haris

  Faruk

  Dino

• d.

  Dino

  Faruk

  Haris

  Tarik

• e.

  Dino

  Faruk

  Tarik

  Haris

How do you open the dialog box above?

• Insert Tab - Sort button

• View Tab - Sort button

• Data Tab - Filter button

• Data Tab - Sort button

How can I see the students whose average is greater than 3.0 on the table above?

• Click the arrow next to Average, choose the filter option, use the dialog box.

• Click the arrow next to Average, choose the custom option, use the dialog box.

• Click the arrow next to Average, write >3

• It is imposible

• Click the arrow next to Average, write <3

Which is not a chart type in excel?

• Column

• Pie

• Scatter

• Shape

• Bar

Where is the chart option?

• In Chart Tab

• In Data Tab

• In Insert Tab

• In Home Tab

• In View Tab

According to the table, I want to see students' averages on a chart. What must I do?

• Select the range (A3:D6) in table, open chart wizard, chose a char type and go on.

• Click on any cell in the table, open chart wizard, chose a char type and go on

• Select the range (A3:A6) and (D3:D6) in the table, open chart wizard, choose a chart type and go on.

• Click on any cell in the table, click on chart tool on the Home Ribbon, it will be displayed immediately.

• I select two names when I draw the chart

• Names fonts are too big to fit in the chart area.

• Each name has two values.

• This chart is not correct.

• None of them.

What is the keyboard shortcut (button or buttons to be pressed) for creating a Chart from the selected cells ?

• F11

• F2

• F1

• F5

• F4

What kind of chart shown on the figure above?

• Bar

• Column

• Line

• Pie

• Scatter