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 See moretraining based on your scores.
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
Rate this question:
A column
A Row
A Spreadsheet
A number of cells
Rate this question:
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
Rate this question:
The same formula but different cell reference
Anchors the cell reference
Anchors one cell
A function
Rate this question:
+
=
Sum
##
Rate this question:
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
Rate this question:
Counts Text
Counts numbers
Counts anything
Counts blanks rows
Rate this question:
File, Options, Formulas
File, advanced
File add-ins
File,options customise ribbon
Rate this question:
Format
File
Edit
Copy
Rate this question:
+
/
*
#
Rate this question:
A formula which can be copied to adjacent cells
A function
A Condition
It adds both outside cells references and anything inbetween
Rate this question:
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
Rate this question:
It is put on to eliminate mistakes
It is a function
A formula
A condition
Rate this question:
Edit, add developer tab
File, Options customise ribbon
File Advanced
Edit, insert
Rate this question:
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
Rate this question:
£12,032
£12,033
£1232.0
£12,031
Rate this question:
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
Rate this question:
It is a specific order of calculations Excel follows
Percentage
Date
Conditional Format
Rate this question:
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
Rate this question:
Quiz Review Timeline (Updated): Mar 19, 2023 +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
Wait!
Here's an interesting quiz for you.