ebook 50 EXCEL RECRUITMENT QUESTIONS WITH STEP BY STEP SOLUTIONS

$ 25.00

Currency Switcher

  • ebook 50 EXCEL RECRUITMENT QUESTIONS WITH STEP BY STEP SOLUTIONS
  • Excel Questions Files
  • Excel Solution Files
Category:

Description

Sample chapter and questions


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

 

Payment & Delivery

Payment

We accept payment by credit card (Visa, MasterCard, American Express, Discover) and PayPal.

Delivery

Once your payment is accepted the ebook is ready to download.

My Account

An account is created automatically on placing the first order and username is generated from the customer’s email address. Username and password are emailed to the customer’s email address.

Reviews

There are no reviews yet.

Be the first to review “ebook 50 EXCEL RECRUITMENT QUESTIONS WITH STEP BY STEP SOLUTIONS”

Your email address will not be published. Required fields are marked *