Test Excel
Quiz Summary
0 of 10 questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Current
- Review / Skip
- Correct
- Incorrect
- Question 1 of 10
1. Question
In tabelul de mai jos ce valoare afiseaza functia =VLOOKUP(“Vlad”,A2:C8,3,FALSE)
CorrectIncorrect - Question 2 of 10
2. Question
In tabelul de mai jos pentru a afla judetul pentru “Ionela” care formula este corecta:
CorrectIncorrect - Question 3 of 10
3. Question
In tabelul de mai jos pentru a afla totalul vanzarilor pentru judetul Brasov care formula este corecta:
CorrectIncorrect - Question 4 of 10
4. Question
Care dintre formulele de mai jos extrage textul “rtk” din sirul text scris in A1:
CorrectIncorrect - Question 5 of 10
5. Question
Pentru a acorda un bonus de 10% din vanzari doar pentru persoanele din Brasov cu vanzarile >=2000 ce formula introducem in celula D2:
CorrectIncorrect - Question 6 of 10
6. Question
Pentru a realiza un subtotal pentru vanzarile din fiecare judet inainte de aplicare tabelul trebuie sortat dupa:
CorrectIncorrect - Question 7 of 10
7. Question
In tabelul pivot din imagine avem afisat:
CorrectIncorrect - Question 8 of 10
8. Question
Unde este inserat un table pivot:
CorrectIncorrect - Question 9 of 10
9. Question
In ce situatie nu se poate sterge o foaie de lucru:
CorrectIncorrect - Question 10 of 10
10. Question
Care este sintaxa corecta a functiei COUNTIF:
CorrectIncorrect
