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

In which menu area do you find the commands for setting up the pages for printing by default?

 
 
 
 
 

Frage / Question 1 von 10

Frage / Question 2 von 10

Have you ever computed with Excel or created a formula yourself? For example, can you create a formula that calculates the shares (column D)?

 
 
 
 

Frage / Question 2 von 10

Frage / Question 3 von 10

Editing lists is an everyday work in Excel. A lot of time is spent scrolling to display columns and / or rows outside the screen. Can you fix the heading of a list so that it remains up when scrolling?

 
 
 
 

Frage / Question 3 von 10

Frage / Question 4 von 10

The print command, for example, hides by default in the backstage area (file). Microsoft offers the possibility to create 'its' commands in an individual toolbar called quick access toolbar. Can you customize the quick access Toolbar?

 
 
 

Frage / Question 4 von 10

Frage / Question 5 von 10

Excel formats cells by default after plausibility. You should be aware of the number format in Excel and use it actively. You can use the cell formatting to write a weekday in the date? (From ’06.03.2017’ will be ‘Monday, 6 March 2017’)

 
 
 

Frage / Question 5 von 10

Frage / Question 6 von 10

List processing takes a lot of time with Excel. Many users cannot put a list down on paper that suits your needs. Imagine you have a list that prints some lines on the 2nd page. Do you print the complete list on a page?

 
 
 
 

Frage / Question 6 von 10

Frage / Question 7 von 10

Absolute references (e.g., $ A $ 1) can often be replaced by names. Advantage: Better legibility, documentation and traceability. Do you work with names for cells?

 
 
 

Frage / Question 7 von 10

Frage / Question 8 von 10

Often you copy formulas to other cells. Sometimes you need to know the difference between relative and absolute references.

What is the formula in B4 if you want to calculate the list up to B9 by autofill?

                =A4-

Frage / Question 8 von 10

Frage / Question 9 von 10

If you want to work with more than one table at a time, you can use windowing or you can start a second Excel instance. So you always have the best overview of your data.

Can you arrange several tables next to each other?

 
 
 
 

Frage / Question 9 von 10

Frage / Question 10 von 10

Filtering and sorting are indispensable for list processing. Filter is activated via the menu commands or CTRL + SHIFT + L.

Do you know all the possibilities to filter or sort lists and also know what is not possible?

 
 
 

Frage / Question 10 von 10