Test Instructions

 

Click Here to download basic practice excel file to assess your skills right now.

Click Here to access the supporting files to complete the exercises. 

Click Here to take our online assessment based on multiple choices.

If you have finished all the projects then apply for a case study. Case studies will only be assigned after completion of all projects and the communication should be kept strictly over email.

Also check Excel Interview Questions and make sure you are able to answer all after course completion.

Exercise# 101A (Excel / VBA)

 

Download the instructions from above link to complete Exercise 101A. This is a test on basics formatting of Excel. The supporting excel can be downloaded from the above link. Please complete the task and submit it for evaluation to info@upskilltechnologies.com

Exercise# 101B (Excel / VBA)

 

Download the instructions from above link to complete Exercise 101B. This is a test on Lookups, If Conditions, Nested Ifs, Vlookups, If-Error, Sumif, Sumifs, Countifs and other logical and database functions. The supporting excel file can be downloaded from the above link. Please complete the task and submit it for evaluation to info@upskilltechnologies.com

Exercise# 101C (Excel / VBA)

 

Download the instructions from above link to complete Exercise 101C. This is a test on making a simple report using autosum, vlookup, and basic data modeling. Please complete the task and submit it for evaluation to info@upskilltechnologies.com

Exercise# 101D (Excel / VBA)

 

Download the instructions from above link to complete Exercise 101D. This is a test to test the conditional formatting in excel. Please complete the task. Please download the supporting excel file from the top link. Submit it for evaluation to info@upskilltechnologies.com

Exercise# 101E (VBA Assessment)

 

Download the instructions from above link to complete Exercise 101E. This is a test to test the Loops and text functions in VBA. Please download the supporting excel file from the top link. Submit it for evaluation to info@upskilltechnologies.com

Exercise# 101F (VBA Assessment)

 

Download the instructions from above link to complete Exercise 101F. This is a test on loops and basic coding in VBA. Please download the supporting excel file from the top link. Submit it for evaluation to info@upskilltechnologies.com

Exercise# 101G (VBA Assessment)

 

Download the instructions from above link to complete Exercise 101G. Use looping skills in VBA to crack this. Submit it for evaluation to info@upskilltechnologies.com

Exercise# 101H (Excel / VBA Assessment)

 

Download the instructions from above link to complete Exercise 101H. This assignment is to assess the skills in pivot tables. Please submit the sheet for evaluation to info@upskilltechnologies.com

Exercise# 102A (Ms Access Assessment)

 

Download the instructions from above link to complete Exercise 102A. This assignment is to assess basic skills in Ms-Access. Please submit the database for evaluation to info@upskilltechnologies.com

Exercise# 102B (Ms Access Assessment)

 

Download the instructions from above link to complete Exercise 102B. This assignment is to assess table creation skills in Ms-Access. Please submit the database for evaluation to info@upskilltechnologies.com

Exercise# 101J (Excel Assessment)

 

Download the instructions from above link to complete Exercise 101J. This assignment is to assess the text and date functions in Ms-Excel. Please submit the database for evaluation to info@upskilltechnologies.com

Exercise# 101K (Excel Assessment)

 

Download the instructions from above link to complete Exercise 101K. This assignment is to assess the skills in creating a dynamic form using dependent validation, vlookup in validation and using excel names. Please submit the file for evaluation to info@upskilltechnologies.com

Exercise# 104A (PowerPoint Assessment)

 

Download the instructions from above link to complete Exercise 104A. This assignment is to assess the skills in designing and creating a professional powerpoint deck from an unorganized data set. Please submit the file for evaluation to info@upskilltechnologies.com

Exercise# 102C (Ms Access Assessment)

 

Download the instructions from above link to complete Exercise. This assignment is to assess query writing skills on single table in MS Access. Please submit the database for evaluation to info@upskilltechnologies.com

Exercise# 101L (Excel Assessment)

Download the instructions from above link to complete Exercise. This assignment is to test the skill in using formulas and solving real time problems.. Please submit the database for evaluation to info@upskilltechnologies.com

Exercise# 101M (VBA Assessment)

Download the instructions from above link to complete Exercise. This assignment is to assess vba coding skills to create a colored map based on values supplied. Please submit the database for evaluation to info@upskilltechnologies.com

 

 

Please take the post assessment test here.

Tags: Excel Training  Hyderabad, VBA training hyderabad, Ms Access Training Hyderabad, Financial Modeling training hyderabad, Excel Bangalore, Excel Pune, Excel Chennai, Assessment on Excel / VBA / Access.