MS EXCEL PRACTICE QUESTIONS

 All Important Questions of Excel-

1. How to cut, copy and paste cell, row and column?
2. How to change font name and font size of any cell?
3. How to change cell shading?
4. How to change font colour of text?
5. How to align text left, Right and Centre of any cell?
6. How to Merge and Centre cell?
7. How to Wrap Text of any cell?
8. How to change Orientation of any cell? (vertical text)
9. How to increase and decrease indent of any cell?
10. How to change number format?
11. How to change currency symbol?
12. How to change cell style? (Accent 1, Accent 3)
13. How to insert new columns in sheet?
14. How to insert new rows in worksheet?
15. How to delete rows from worksheet?
16. How to delete columns from worksheet?
17. How to change row height of any row?
18. How to change column width of any column?
19. How to rename sheet?
20. How to move or copy worksheet?
21. How to use Sum function?
22. How to use Min function?
23. How to use Max function?
24. How to use Average function?
25. How to short sort and filter (A to Z and Z to A) columns?
26. How to replace text in excel?
27. How to insert picture in worksheet?
28. How to insert shapes in worksheet?
29. How to insert Hyperlink in cell? (VVI)
30. How to insert Text Box in worksheet?
31. How to insert Header and Footer in worksheet?
32. How to change Margin (Left, Right, Top and Bottom) of worksheet?
33. How to change orientation of worksheet?
34. How to change page size of worksheet?
35. How to change the view of worksheet as Page Break Preview?
36. How to apply gridline in the worksheet?
37. How to zoom worksheet?
38. How to chart design?
39. How to change Pia chart to Column chart?
40. How to change the chart legend?