Opis
Microsoft Excel is one of the most popular software used in almost every organization. Many employers test candidate’s command in Excel before offering them a job. This helps ensure that job applicants are skilled in Excel.
If you are not sure what to expect during your Excel test, this ebook is for you.
In this ebook, you will find 50 common interview questions with step by step solutions.
It can also be used by interviewers who want to check the Excel skills of candidates in the interview.
Table of contents
Question 1. Basic Calculations 4
Question 2. Basic Calculations 5
Question 3. Using Cell References 7
Question 4. Inserting Charts 8
Question 5. Using Cell References 10
Question 6. Sorting Data 11
Question 7. Sorting Data 12
Question 8. Subtotal 14
Question 9. Go To Special 16
Question 10. Using Cell References & Basic Calculations Using Dates 19
Question 11. Conditional Formatting 20
Question 12. Conditional Formatting 23
Question 13. Using Formulas to Modify Text 26
Question 14. Using Formulas to Modify Text 30
Question 15. Filtering 35
Question 16. SUBTOTAL 37
Question 17. Logical Functions 39
Question 18. Logical Functions 41
Question 19. Logical Functions 43
Question 20. Logical Functions 45
Question 21. Logical Functions 46
Question 22. Logical Functions 47
Question 23. Logical Functions 48
Question 24. Logical Functions 50
Question 25. Counting Cells Meeting the Criteria 51
Question 26. PivotTable 53
Question 27. PivotTable 55
Question 28. Building a PivotChart 57
Question 29. Modifying a PivotChart 59
Question 30. PivotTable 61
Question 31. PivotTable 64
Question 32. Sorting a PivotTable 68
Question 33. Data Validation 69
Question 34. VLOOKUP 71
Question 35. VLOOKUP 74
Question 36. VLOOKUP 76
Question 37. Duplicate Values 78
Question 38. Comparing Lists 80
Question 39. IFERROR 82
Question 40. Summarizing Data Meeting One or More Criteria 83
Question 41. Combo Chart 87
Question 42. Worksheet’s View 89
Question 43. Recording a Macro 90
Question 44. Errors Correction – Data Entry 95
Question 45. Errors Correction 96
Question 46. Errors Correction – Circular References 97
Question 47. Errors Correction 98
Question 48. Errors Correction 99
Question 49. Errors Correction 100
Question 50. Errors Correction 101
ebook details
Format: pdf, Excel zipped files (zip)
Pages: 102
Size:
- ebook 3250kb
- Excel Questions 4276kb
- Excel Solutions 408kb
Language: English
Płatność i dostawa
Płatność
Akceptujemy płatności elektroniczne w systemach imoje oraz PayPal: kartami płatniczymi, szybkimi przelewami online oraz BLIKIEM
Dostawa
Bezpłatna dostawa elektroniczna. Zaraz po opłaceniu zamówienia na Państwa adres mailowy podany w zamówieniu wysyłana jest automatycznie wiadomość z linkami do pobrania plików.
Pliki można pobrać także w każdej chwili logując się na swoje konto.
Moje konto
Konto klienta tworzone jest automatycznie podczas składania zamówienia, nie ma potrzeby wcześniejszego zakładania konta. Dane do logowania otrzymacie Państwo zaraz po złożeniu zamówienia na podany w zamówieniu adres e-mail.
Opinie
Na razie nie ma opinii o produkcie.