Mobile MOUSe online

      
 
Excel Training | Word Training | Access Training | Outlook Training | PowerPoint Training | Visio Training | Project Training | Publisher
  
 

Excel Training Assessment



THIS IS NOT A TEST. Please note that this is for your own benefit, used to determine your approximate skill set with Excel. Please read the questions very carefully and by answering the questions honestly, these questions will help you determine which Excel course is the right one for you to do. Please answer all questions.
Your Name (REQUIRED):
Company:
Contact Number:
Your Email Address (REQUIRED):
QUESTION
ANSWER
Q1. Are you currently using Excel?
Q2. Are you comfortable with Entering and Editing spreadsheet data?
Q3. Can you align data within a column, and rotate text within a cell?
Q4. Do you know what the symbols are to perform multiplication, addition, subtraction and division in Excel?
Q5. Do you know how to determine the average value from a range of cells using a function formula?
Q6. Do you know what all of the following formulas do; MIN, MAX, SUM, COUNT, COUNTA, COUNTIF?
Q7. Do you know how to prevent Excel from dropping the leading zero on say... a mobile number?
Q8. Do you know how to apply different type of number formats to cells such as currency, accounting, general and percentage?
Q9. Have you used AutoFill to duplicate a formula as well as create date patterns?
Q10. Do you know how to Insert new Columns and Rows?
Q11. Are you comfortable with how to calculate a percentage in Excel?
Q12. Do you understand the reasoning behind the $ sign used in many Excel formulas?
Q13. Have you worked with filters in Excel (Drop down arrows on a column heading that allow you to choose specific data to view)?
Q14. Do you know how to insert, duplicate and rename sheets within an Excel workbook?
Q15. Do you know how to insert Page Breaks, set the Print Area and force Headings to repeat on an Excel worksheet?
Q16. Are are comfortable with the theory behind creating a column, line or pie chart?
Q17. Have you created Excel templates (*.xlt not *.xls)
Q18. Have you ever made use of Data Validation to control what is allowed to be entered into a cell?
Q19. Do you know how to adjust Scaling and Trendlines within Charts?
Q20. Do you know how to set freeze panes in Excel?
Q21. Can you protect worksheet cells from editing by other people?
Q22. Are you comfortable with the VLOOKUP, LOOKUP and INDEX MATCH functions?
Q23. Do you know how to define and modify named ranges for use in formulas and navigation?
Q24. Do you know how to create worksheet outlines as well as work with subtotals?
Q25. Do you know how to link worksheets and workbooks (other documents) together so that as data changes in one it changes in another?
Q26. Do you know how to use Formula Auditing to trace precedants and dependants?
Q27. Do you know how to create your own custom toolbars and menus?
Q28. Are you comfortable with the theory behind creating PivotTables?
Q29. Have you worked with (and effectively used) Solver, Goal Seek and Data Tables?
Q30. Have you worked with Scenarios in Excel?
Q31. Do you know how to quickly select all constants within a workbook?
Q32. Can you explain to someone what macros are and how they can be of benefit?
Q33. Can you edit Macros using the VBE window?
Q34. Does the term "Error Trapping" instantly mean something to you?

If you have any questions, queries or comments, please do not hesitate to contact us.

home
 
   
 
 
 

Microsoft Word Training Perth
Excel Training Perth
Access Training Perth
PowerPoint Training Perth
Outlook Training Perth
Project Training Perth
Visio Training Perth
Publisher Training Perth

 
 
 

Onsite training at our clients premises. We come to you !! Our venue is also available.

At your premises, we provide laptops for the course. No strain on your IT resources.

All courses come with a quality manual and downloadable practice files.

Cost-effective price structure. The more students you enrol, the cheaper the course.

Structured (but flexible) nationally accredited curriculum.

Courses are also designed around Microsoft Office User Specialist certification.

Small personalised groups and one-on-one training.

6 months of free post-course support.

We can also design and provide custom, tailor made courses.

Certified, qualified and experienced trainers.

Training some of the biggest companies in Western Australia.


 

 
 
 
 
 
     
training | contact us | clients