Question: Microsoft excel interview questions Task: Please, answer, how to: Answer Q# Topic Question 1. Open a Workbook 2. Insert a Row 3. Change a Font
Task: Please, answer, how to: Answer Q# Topic Question 1. Open a Workbook 2. Insert a Row 3. Change a Font Style 4. Change a Font Size 5. Format Cells as Currency 6. Use SUM Function 7. Copy cells 8. Paste Function 9. Save Workbook 10. Change Text Alignment 11. Selecting Cells 12. Set Borders 13. Rename a Worksheet 14. Insert Sheet Column 15. Use AVERAGE function 16. Change Column Width 17. Insert Chart 18. Change Chart Style 19. Set Wrap Text 20. Insert Worksheet 21. Merge and Center Cells 22. Sort Data 23. Set Margins 24. Change Page Orientation 25. Insert Header or Footer 26. Use Spell Check 27. Print Centered on Page Answer Q# Topic Question 28. Insert Pivot Table 29. Change Print Scaling 30. Print a Worksheet 31. Hide Column 32. Freeze Panes 33. Use CONCATENATE function 34. Use IF function (statement) 35. Select Non-Contiguous Cells 36. Use Paste Special 37. Use Fill Handle 38. Apply Conditional Formatting 39. Use Custom Sort (at Home Tab) 40.Apply Table Style 41. Edit Pivot Table 42. Use Pivot Table Filter 43. Create Pivot Chart 44. Create a Macro 45. Run a Macro 46. Turn on AutoFilter 47. Apply Filter 48. Set Absolute Reference 49. Convert Text to columns 50. Use VLOOKUP function 51. Use COUNTIF function 52. Create a Custom List 53. Select (group) Worksheets 54. Insert Page Break 55. Set Print Area
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
