Excel Level II 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

How can I back up the quick start bar so I can import it back at any time if I get a new profile?

 
 
 
 
 
 

Frage / Question 1 von 10

Frage / Question 2 von 10

Data visualization:

Can you leave cells as in this picture, depending on the input, automatically turn red when they are negative and otherwise blue?

 
 
 

Frage / Question 2 von 10

Frage / Question 3 von 10

Can you sort a list at the same time for several columns? Example: First by country, then by region, then by city ...

Before:

After:

 
 

Frage / Question 3 von 10

Frage / Question 4 von 10

Can you insert pictures into a list and have them sorted together?

 
 
 

Frage / Question 4 von 10

Frage / Question 5 von 10

= VLOOKUP (! B2; Master Data $ A $ 2: $ M $ 1000; 2, FALSE)

I know the VLOOKUP () function and know when I use "wrong" as the 4th parameter.

 

 
 
 
 
 
 

Frage / Question 5 von 10

Frage / Question 6 von 10

Topic Data visualization / diagrams:

Can you display the title of the diagram und change the font size afterwards?

 
 
 

Frage / Question 6 von 10

Frage / Question 7 von 10

Look at the following formula:

I know the IF() function and can work safely with it. The result of the above function in C1 is ...

 
 
 
 
 

Frage / Question 7 von 10

Frage / Question 8 von 10

Excel automatically recognizes lists. I know what I need to keep in mind for this to work and know the rules to filter or evaluate a list.

 
 

Frage / Question 8 von 10

Frage / Question 9 von 10

What comes out as a result?

= IF (5> 100; "5 is smaller"; if (10 <100; "10 is less than"; "no idea")

 
 
 
 

Frage / Question 9 von 10

Frage / Question 10 von 10

I can use the key combination

CTRL + ...

... to go to the end of a list.

 
 
 
 

Frage / Question 10 von 10