Excel Level III en

This evaluation is used to determine whether you have the requirements for a seminar, or whether you are already working on it.

To be able to send you the test results, we need your e-mail address. This is stored together with your test results on our server in order to be able to submit suitable seminar proposals to you. Your data will not be passed on to third parties.

The basis for data processing is Art. 6 para. 1 lit. f DSGVO. You will find further information in our data protection declaration.

 10%

Frage / Question 1 von 10

Number formats:

In lists, it is sometimes necessary to display the weekday of a date.

Can you show a date as a weekday?

Example: 15.06.2017 -> "Thursday"

 
 
 
 

Frage / Question 1 von 10

Frage / Question 2 von 10

Evaluate Lists:

Can you make this list...

...into such partial results?

 
 
 

Frage / Question 2 von 10

Frage / Question 3 von 10

Lists or tables?

Excel can move lists into tables. These are already formatted, have activated filters and have a name. They look like this:

Are you already working with dynamic tables that are automatically formatted and do you know the requirement that they 'work'?

 
 
 

Frage / Question 3 von 10

Frage / Question 4 von 10

Printing options:

Suppose a list consists of several pages:

Do you make the column headings print out on each page?

 
 
 

Frage / Question 4 von 10

Frage / Question 5 von 10

Structure:

Let's say you have a very wide and / or a very long list

Can you divide columns and cells to show / hide column or cell ranges?

 
 
 

Frage / Question 5 von 10

Frage / Question 6 von 10

Functions:

Which of the following formulas do you enter in field B11 to get the same result?

 
 
 
 
 

Frage / Question 6 von 10

Frage / Question 7 von 10

Pivot tables:

You work with lists and want to evaluate them (totals, number etc.).

Do you already solve this with Pivot Tables?

 
 
 

Frage / Question 7 von 10

Frage / Question 8 von 10

Pivot:

I use pivot tables for simple evaluations and can change them.

 
 
 

Frage / Question 8 von 10

Frage / Question 9 von 10

Pivot:

I can change the layout of a pivot table and hide the subtotals.

 
 
 

Frage / Question 9 von 10

Frage / Question 10 von 10

Pivot:

You know drilldowns to create individual tables from a pivot table.

 
 

Frage / Question 10 von 10