Pre-Course evaluation:

New Horizons Ireland are working with your organisation to deliver training. In order to accurately provide you with the correct level of training, we first ask that all participants complete the following assessment in the most honest way possible.

This assessment is used to gauge which course is most suitable for you.

Completion of this assessment is compulsory
Only complete the assessment ONCE, your 1st result will be the only result recorded
There is no minimum score requirement as entry into the course
Close all instances of Microsoft Excel while completing the assessment
please do not refer to Microsoft Excel application during the assessment
The assessment should take between 10 - 20 minutes to complete

Organisation:
Name:
Email:

Q1. Which of the following calculations would you use to find the total of cells B10:B14.

SUM(B10+B11+B12+B13+B14)
SUM(B10,B14)
SUM(B10:B14)
Don't know

Q2. To have a formula add together the content of two cells and then multiply by the content of a third cell, which of the following formulas would give the desired result?

A1+B1*C1
A1+(B1*C1)
(A1+B1)*C1
Don't know

Q3. Which of the following is not an Auto Fill option in Excel?

Copy Cells
Fill Series
Fill Duplicate Values
Fill Without Formatting
Don't know

Q4. Which of the following methods would you use to insert a new blank worksheet?

Right click on an existing sheet tab and choose Insert
On the Insert tab on the ribbon click Insert Worksheet
Press the F11 function key on the keyboard
Don't know

Q5. Which of the following features will allow you to print column or row titles on every page of your printed output?

Print Titles
Print Area
Row and Column Headings
Don't know

Q6. Which of these error prompts is not a standard calculation return in Excel?

#REF!
#INVALID!
DIV/0!
Don't know

Q7. Which of the following techniques can be used to create a new chart from selected data?

Right click on selected data and choose Insert Chart
On the Insert tab on the ribbon select the chart type from the Charts group
Press the F12 function key on the keyboard
Don't know

Q8. The following VLOOKUP function will return a value from which column of the table array being searched? VLOOKUP(A10,B1:D20,4,False)

First column
Fourth column
Tenth column
Don't know

Q9. Which of the following Data Filter criteria would show orders placed on, or after 1st. July 2017?

Greater than 01-07-2017
>01-07-2017
>=01-07-2017
Don't know

Q10. Which of the following Logical functions would show 'Over Budget' if the value in cell B10 exceeds €50,000?

IF(B10 > 50000,"Over Budget","")
IF(B10 > 50000,B10 < 50000,"Over Budget","")
IF(B10 < 50000,"Over Budget","")
Don't know

Q11. Data in a Pivot Table report will update automatically when values on the Excel datasheet are altered.

True or
False
Don't know

Q12. Values summarised in a Pivot Table report automatically use SUM, AVERAGE, or similar functions. How would you show values as a percentage of column or row totals?

Filter the results in the Pivot Table report and apply percentage formatting to results
On the Home tab on the ribbon click the Percentage tool
Click on Values label and choose Value Field Settings, change Show Values As settings
Don't know

Q13. The Name Manager in Excel 2010s used to store and manage what?

Sheet tab names
Functions and formulas
Cell and range names
Don't know

Q14. When creating a global Macro that can be applied to multiple Excel files, you should store the macro where?

New Workbook
Personal Macro Workbook
Current Workbook
Don't know

Q15. Data Validation can be applied to Excel cell ranges to restrict data entry to a specific list of values?

True or
False
Don't know

Q16. Colour Scales is an option of which features in Excel?

Consolidation
Scenarios Manager
Conditional Formatting
Don't know

Q17. Which of the following What-if Analysis tools in Excel is used to store multiple values in a range of cells?

Solver
Goal Seek
Scenario Manager
Data Table
Don't know

Q18. To prevent unwanted changes to cell ranges in Excel which protection option would you apply?

Protect Workbook
Protect and Share Workbook
Protect Sheet
Share Workbook
Don't know

Q19. Which of the following options will allow you to save a snapshot of the current layout of all open and arranged workbook windows?

Save as Template
Save as Macro-enabled Workbook
Save Workspace
Save as CSV
Don't know

Q20. To graphically display cells that provide data to a formula which of the following features would you use?

Trace Error
Trace Dependents
Trace Precedents
Show Formulas
Don't know

Are there any other classes you would be interested in attending?

By utilising New Horizons Ireland assessments you agree to be contact by New Horizons Ireland regarding IT Training.

Course training dates and time information will be provided to you by your organisation.

If you have any queries, please contact at New Horizons:

info@nhireland.ie

Phone: 01 8898700