Скачать или смотреть Excel Practice Test with Answers

Excel Practice Test with Answers (Part 1)

This practice test has been designed to assess your excel skills. The test is divided into 10 essential components of excel which is critical to know especially if you are working on reports and dashboard on a daily basis.

You may also want to use this guide to enhance your excel knowledge towards on getting Microsoft Excel certification or passing an excel test for your future employment as this covers real-life practical examples.

You only have 60 seconds to answer each question. After the said time, answers will be revealed.

Exercises:
1. Commonly Used Formulas
2. Vlookup and Hlookup
3. Conditional Formatting
4. Text to Columns
5. Concatenate
6. Countif
7. Nested If
8. Sumif
9. Hyperlink
10. Data Validation

Best to watch on your preparation for:
1. Microsoft Office Specialist Excel Certification
a. MOS 77-727
b. MOS 77-420
c. MOS 77-882
d. MOS 77-602
e. MOS 77-728
f. MO 201
g. MOS 77-427
h. MOS 77-428
2. Microsoft Certified Solutions Associate Certification
a. MCSA 70-779 Analyzing and Visualizing Data with Microsoft Excel
3. Business/Data Analyst Certification

“Practice is the hardest part of learning, and training is the essence of transformation.”
― Ann Voskamp, One Thousand Gifts: A Dare to Live Fully Right Where You Are

*************************************************
Want to learn more about Excel?

SUBSCRIBE NOW:
   / @romeocostillas  

YouTube Playlist:
   • Excel Keyboard Shortcut Control Combinatio...  

Or visit me on Facebook at   / excelbyromeocostillas  

See you there!


Romeo Costillas
Microsoft Certified Solutions Associate BI Reporting
Microsoft Office Specialist Master
Microsoft Office Specialist Excel Expert


"To EXCEL in the workplace, one must know how to use excel!"
Romeo

Tagalog Excel | Filipino | Pinoy Excel | Excel Tutorial | Excel Tagalog Tutorial

#excel #microsoftexcel #excelbyromeocostillas #excelonline #exceltraining #excelfreetraining #excelmasterclass #tagalogexcel #excelpinoy