Please answer the questions honestly and to the best of your ability. If you have no idea what the answer is, choose the "not sure" answer. Please do not leave the answer blank or "wild guess" any of the questions. Remember, the purpose of this assessment is to obtain accurate information on your skill level, and provide personally tailored training based on your scores.
2
3
6
5
You have an error with numbers and text
The cell is not formatted
There is not enough room in the cell to accommodate the data
You have an error within the formula
A column
A Row
A Spreadsheet
A number of cells
To view the top row at all times
To view specific criteria in your spreadsheet
To help with formulas
In order to freeze the columns
The same formula but different cell reference
Anchors the cell reference
Anchors one cell
A function
+
=
Sum
##
One cell reference remains anchored when dragged down for copying
The cell reference changes as it is being dragged down for copying
A filter
A function
Counts Text
Counts numbers
Counts anything
Counts blanks rows
File, Options, Formulas
File, advanced
File add-ins
File,options customise ribbon
Format
File
Edit
Copy
+
/
*
#
A formula which can be copied to adjacent cells
A function
A Condition
It adds both outside cells references and anything inbetween
Counts the no of cells in a range that contains numbers
CountIf counts the no of cells in a given range that meets a condition
Counts the blank rows
Counts rows which contain numbers and blanks
It is put on to eliminate mistakes
It is a function
A formula
A condition
Edit, add developer tab
File, Options customise ribbon
File Advanced
Edit, insert
A Format of colour etc applied to cells to make them stand out
A list in which you can choose from various options
A pattern which you need to set-up and drag to cells
A built in pattern
£12,032
£12,033
£1232.0
£12,031
A worksheet is a workbook within a workbook
A worksheet is a sheet within a workbook
A worksheet has to be inserted into a workbook
A worksheet is part of the cells in a workbook
It is a specific order of calculations Excel follows
Percentage
Date
Conditional Format
It returns the largest value in a set
If a condition is met it returns a true/false value
Returns the largest number in a set of values
Returns the absolute value of a number
Wait!
Here's an interesting quiz for you.