How to Create a Microsoft Excel Test
A Microsoft Excel test is used in various environments, including academic settings, employment situations and in job centers to test candidates' skills and computer knowledge. An effective Microsoft Excel test covers software functions, meanings of symbols and general tasks. Ensure that you cover these three areas to test a candidate's overall skills with the program and write down the correct answer for each of the questions for quick evaluation.
Other People Are Reading
Instructions
-
-
1
Decide whether you want to create a written Microsoft Excel test or a computerized test, where the candidate must perform each question on a computer, while an evaluator supervises the test. If you choose the latter, you must prepare an Excel document for the test based on the questions you create in the following steps. If you choose a written test, simply present the questions on a typed piece of paper.
-
2
Create questions that focus on general functions that Excel provides that other Microsoft programs like Word and PowerPoint does not. If the candidate provides a general definition of the software, it may show the candidate's expertise or general experience with the program.
-
-
3
Create questions that focus on basic Excel tasks, such as changing the width of columns and modifying the cells to suit the content in each. Ask the candidate to explain what steps are involved, such as single-clicking the boundary on the left-hand side, double-clicking on the right-hand side boundary and pressing "Alt" while clicking a single time in the column.
-
4
Formulate questions that focus on shortcuts, such as adding up numbers in a column of cells. Ask the candidate to outline the steps involved in adding up the numbers, such as clicking on the data menu, selecting subtotals and viewing the sum in the formula bar.
-
5
Ask questions about the meanings of symbols and signs present in an Excel worksheet. For instance, ask the candidate what "#####" means and what a red triangular color in a single cell represents. The "#####" means something is incorrect, such as a wrong number or a misspelling, while the red cell corner indicates that content is hidden in the cell. This is used if the information in the cell requires an explanation.
-
6
Create an answer sheet where all of the answers are present. This allows you to evaluate the Microsoft Excel test quickly after the candidate finishes the test.
-
1
