Excel

Pre-training Evaluation

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

  • Completion of this assessment is compulsory
  • Please provide your Organisation's name, your name, and email address
  • 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
  • Please refrain from using Google to complete the assessment, as it is only used to determine the best course for you
  • 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





Student information


Organisation
🏢

Name
🧑🏻

Email
📧

Assessment


Question 1

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





Question 2

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?





Question 3

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






Question 4

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






Question 5

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






Question 6

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






Question 7

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






Question 8

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






Question 9

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






Question 10

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






Question 11

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





Question 12

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?






Question 13

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






Question 14

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






Question 15

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





Question 16

Colour Scales is an option of which features in Excel?






Question 17

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







Question 18

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







Question 19

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







Question 20

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








By utilising Nexus Human assessments you agree to be contact by Nexus Human regarding IT Training.