This assessment is used to gauge which course is most suitable for you.
Which of the following calculations would you use to find the total of cells B10:B14.
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?
Which of the following is not an Auto Fill option in Excel?
Which of the following methods would you use to insert a new blank worksheet?
Which of the following features will allow you to print column or row titles on every page of your printed output?
Which of these error prompts is not a standard calculation return in Excel?
Which of the following techniques can be used to create a new chart from selected data?
The following VLOOKUP function will return a value from which column of the table array being searched? VLOOKUP(A10,B1:D20,4,False)
Which of the following Data Filter criteria would show orders placed on, or after 1st. July 2017?
Which of the following Logical functions would show 'Over Budget' if the value in cell B10 exceeds €50,000?
Data in a Pivot Table report will update automatically when values on the Excel datasheet are altered.
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?
The Name Manager in Excel 2010s used to store and manage what?
When creating a global Macro that can be applied to multiple Excel files, you should store the macro where?
Data Validation can be applied to Excel cell ranges to restrict data entry to a specific list of values?
Colour Scales is an option of which features in Excel?
Which of the following What-if Analysis tools in Excel is used to store multiple values in a range of cells?
To prevent unwanted changes to cell ranges in Excel which protection option would you apply?
Which of the following options will allow you to save a snapshot of the current layout of all open and arranged workbook windows?
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.