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.
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:
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:
+
/
*
#
Rate this question:
A column
A Row
A Spreadsheet
A number of cells
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:
Format
File
Edit
Copy
Rate this question:
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:
The same formula but different cell reference
Anchors the cell reference
Anchors one cell
A function
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:
File, Options, Formulas
File, advanced
File add-ins
File,options customise ribbon
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:
Edit, add developer tab
File, Options customise ribbon
File Advanced
Edit, insert
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:
2
3
6
5
Rate this question:
£12,032
£12,033
£1232.0
£12,031
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:
Counts Text
Counts numbers
Counts anything
Counts blanks rows
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.
BASIC 6 COMPUTING QUIZ
The BASIC 6 COMPUTING QUIZ assesses foundational knowledge in spreadsheet management, focusing on Excel. It covers key concepts like cells, databases, sheet tabs, and cell naming,...
Questions:
8 |
Attempts:
122 |
Last updated:
Apr 06, 2023
|
Data Analyst Excel Test
Dive into our Data Analyst Excel Test and show off your skills. In this test, you'll face a range of challenges that cover everything essential for a data analyst. We'll...
Questions:
10 |
Attempts:
7778 |
Last updated:
Jul 03, 2024
|
9th Grade Excel Test
This 9th Grade Excel Test assesses key spreadsheet skills. It covers functions like MAX and RANGE, proper data selection for graphs, and understanding of cell alignment. Ideal for...
Questions:
9 |
Attempts:
1993 |
Last updated:
Nov 08, 2024
|
Keystone Bank Pre-Training Assessment
This assessment tests proficiency in Excel functionalities like sorting, using gridlines, worksheet operations, freeze panes, and functions.
Questions:
20 |
Attempts:
143 |
Last updated:
Mar 22, 2023
|
Microsoft Excel Proficiency Trivia Questions
This quiz is created to identify the proficiency of users about Microsoft Excel.
Questions:
122 |
Attempts:
227 |
Last updated:
Sep 13, 2023
|
Test How Much Do You Know About Excel Sheets! Trivia
Explore your knowledge of Excel Sheets with this trivia! Learn to sort columns, freeze panes, create tables, use conditional formatting, and search data efficiently. Perfect for...
Questions:
20 |
Attempts:
482 |
Last updated:
Sep 09, 2024
|
Wait!
Here's an interesting quiz for you.