How do I prepare a Microsoft Excel test?

You will need to know the basic Excel Functions like – SUM, AVERAGE, MIN and Max. Also you will need to be competent in Formatting , such as Borders & shading, Word wrap, alignment and number formatting, especially currency formatting. Also know how to delete formats properly.

How do I practice my Excel skills?

5 Tips for Learning Excel
  1. Practice Simple Math Problems in Excel. When it comes to Excel, it’s easiest to start with basic math. …
  2. Learn How to Create Tables. …
  3. Learn How to Create Charts. …
  4. Take Excel Training Courses. …
  5. Earn a Microsoft Office Specialist Certification.

What is usually on an Excel test?

The types of tasks included in the basic Excel test might include: Using basic functions such as SUM, AVERAGE, MIN and COUNT. Formatting cells – especially currency formatting, and also borders, shading, alignment, number formatting and wrapping text.

Where I can practice Excel for free?

GCF LearnFree.org. One of the most comprehensive free resources out there, GFCLearnFree.org offers access to a staggering 29 tutorials and five extras. You can learn Excel basics from creating and saving workbooks to conditional formatting and more.