Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Microsoft excel interview questions image text in transcribed
image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Graph Databases

Authors: Ian Robinson, Jim Webber, Emil Eifrem

1st Edition

1449356265, 978-1449356262

More Books

Students also viewed these Databases questions

Question

Approaches to Managing Organizations

Answered: 1 week ago

Question

Communicating Organizational Culture

Answered: 1 week ago