Excel Tests original version
Get your own personalized Online Excel Training Course to help you learn Excel effectively with your own tutor, personalized study plan and timetable.
If you want to learn Excel at your own pace and focus on what you need to know for your own particular job, try our personalized online Excel Course, available on your laptop, tablet or phone 24/7.
Unlike most online Excel courses, our Online Excel course includes all levels of Excel in one package.
 Beginners Excel
 Intermediate Excel
 Advanced Microsoft Excel
 Pivot tables
After you join, your tutor will get you to do a quick online assessment which will allow us to gauge your current skill levels.
From this, your job position and your daily usage of Excel, we will create a personalized program for you to follow –indicating which Excel techniques and functions to concentrate on together with a timetable to follow. Your tutor will be available for you for questions, help and discipline until you reach your Excel Goals.
In our online Excel course you can take an assessment at the end of each module to achieve up to 4 levels of certification.
Our online Excel course online covers Excel 2007,2010 & 2013.
This online Excel training course is available for individuals or group staff training where usage can be tracked by an administrator.
Cost: $157. Click Here to Learn More
Each Excel test is comprised of about 1020 questions, covering beginners, intermediate and advanced Excel Levels.
–
Each Excel test will be timed. At the end of each Excel Test, you will get your score and feedback will be given to you for each question, emphasizing your areas of weakness.
Excel Tests Advice.
Should you need any advice or help, maybe about the Excel test results, or advice on what level of Excel you would need for a certain job or what Excel functions and techniques would be necessary for a specific job, please feel free to contact us.
Beginners Excel Test.
Quiz Summary
0 of 13 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 13 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
 Not categorized 0%
 Control your worksheet 0%
 Formatting 0%
 Formulas 0%
 Functions 0%
 Functions 0%
 linking 0%
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 12
 13
 Current
 Review
 Answered
 Correct
 Incorrect

Question 1 of 13
1. Question
When I type a number into a cell, it's coming up as a date.What should I do?
CorrectIncorrect 
Question 2 of 13
2. Question
What is wrong with this Formula:
A5+B7\C8E400CorrectIncorrect 
Question 3 of 13
3. Question
How will Excel evaluate this Formula:
=B1+C2 * D3
CorrectIncorrect 
Question 4 of 13
4. Question
How can you configure the worksheet to show the formulas instead of the results.
CorrectIncorrect 
Question 5 of 13
5. Question
I want to find the average sales for Monday based on the data below. Which formula or function is correct ?
CorrectIncorrect 
Question 6 of 13
6. Question
What is the fill handle and how do you use it?
CorrectIncorrect 
Question 7 of 13
7. Question
CorrectIncorrect 
Question 8 of 13
8. Question
I want to find the largest number in a range of numbers. Which Function should I Use?
CorrectIncorrect 
Question 9 of 13
9. Question
I have come across this Function =INT(A2) and I don't understand what it does.What is the quickest way to find out?
CorrectIncorrect 
Question 10 of 13
10. Question
I have a value in cell A1 in Sheet1 worksheet and I have a value in cell A1 in sheet2 worksheet.
I want to create a formula in worksheet Sheet3 which will add them together.Which is the correct formula.
CorrectIncorrect 
Question 11 of 13
11. Question
I want to freeze row 3 of my worksheet.How will I do it?
CorrectIncorrect 
Question 12 of 13
12. Question
I want to filter the data below to see a list of orders where the revenue figure was greater than $15000.
What should I do?CorrectIncorrect 
Question 13 of 13
13. Question
As per spreadsheet image, we want to create a formula in cell J4 which will work out the commission due to Lorraine. The Commission rate is in Cell F1. We will want to copy down these formulas. From the list below which is the most effective formula.
CorrectIncorrect
Intermediate Excel Test:
Quiz Summary
0 of 11 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 11 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
 Not categorized 0%
 linking 0%
 1
 2
 3
 4
 5
 6
 7
 8
 9
 10
 11
 Current
 Review
 Answered
 Correct
 Incorrect

Question 1 of 11
1. Question
As per spreadsheet image, we want to create a formula in cell J4 which will work out the commission due to Lorraine. The Commission rate is in Cell F1. We will want to copy down these formulas. From the list below which is the most effective formula.
CorrectIncorrect 
Question 2 of 11
2. Question
As per spreadsheet image, we want to create an IF Function in cell I2 and copy ,which will output True if the commission is greater than or equal to 350 or leave the cells empty if not.
Pick the IF Function below which does this.CorrectIncorrect 
Question 3 of 11
3. Question
We want to create a VLOOKUP Function in cell D12, which will return the Wednesday sales figures for whatever sales person is entered into cell C12.
Which of the VLOOKUP Functions below is the best.CorrectIncorrect 
Question 4 of 11
4. Question
We need to create a SUMIF Function in cell G4,which will give us the total minutes played for whatever band is typed into Cell F4.
Which of the SUMIF Functions below is correct and the most effective.CorrectIncorrect 
Question 5 of 11
5. Question
I need to create a formula in D2 downwards which will only show loans from identifiers in column A beginning with US. Which of the formulas below do this successfully?
CorrectIncorrect 
Question 6 of 11
6. Question
What number does Excel associate with the date 2 December 2014?
CorrectIncorrect 
Question 7 of 11
7. Question
I have created a dropdown box in sheet1 like the image below.
I want to create the same dropdown list in sheet2, which of the statements below is True?
CorrectIncorrect 
Question 8 of 11
8. Question
Because the cell in C12 is empty, the VLOOKUP Function in D12 is showing the #N/A Error message. How can we hide this error message. Which of the following will do this effectively?
CorrectIncorrect 
Question 9 of 11
9. Question
I want to create a macro of a logo which I want to be able to place in different positions in various worksheets of various workbooks.
What much I make sure I do?CorrectIncorrect 
Question 10 of 11
10. Question
I have various conditional formats on my worksheet. I just need to delete one of them. How do I do this?
CorrectIncorrect 
Question 11 of 11
11. Question
I have a value in cell A1 in Sheet1 worksheet and I have a value in cell A1 in sheet2 worksheet.
I want to create a formula in worksheet Sheet3 which will add them together.Which is the correct formula.
CorrectIncorrect
Advanced Excel Test
Quiz Summary
0 of 8 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 8 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
 Not categorized 0%
 1
 2
 3
 4
 5
 6
 7
 8
 Current
 Review
 Answered
 Correct
 Incorrect

Question 1 of 8
1. Question
In the spreadsheet below, I want to create a formula in cell G2 that will bring back the product name of whatever Trace No I put in cell F2.
Which of the formulas below will do this in the most effective manner.CorrectIncorrect 
Question 2 of 8
2. Question
In relation to the question one above, I am not happy using the column number for Products in my formula.
I want to make my formula completely dynamic in case extra columns are added to the list. Which of the formulas below will achieve this?CorrectIncorrect 
Question 3 of 8
3. Question
In cell J2 of the spreadsheet below, we want to create a function which will tell the revenue figure for the product sold (cell I2) by the salesperson in cell H2.
Which of these formulas achieve this.?CorrectIncorrect 
Question 4 of 8
4. Question
Similar to the question above, but this time, we want to count in cell K2 the number of sales a particular salesperson sold of a particular product.
Which of these formulas achieve this?CorrectIncorrect 
Question 5 of 8
5. Question
I want to use a SUMPRODUCT Function in cell J7 to work out the value of my portfolio, as in the spreadsheet below.
Which Function below will do this effectively?CorrectIncorrect 
Question 6 of 8
6. Question
I want Excel to move dynamically from cell A1 down three rows, then to move across four columns and add that value and the value below.
The answer needs to be displayed in cell A7. Which formula below will do this?CorrectIncorrect 
Question 7 of 8
7. Question
In the spreadsheet below, a business owner charges a different price for the apples he sells, depending on the quantity you buy.
He wants to create an nested IF Function in cell B9 to automatically work out the price for any quantity ordered. The ordered amount is put in cell A9. Which of the below IF Function would do this?CorrectIncorrect 
Question 8 of 8
8. Question
In relation to question 7 above, what would the Function be if he wanted to use cell references for the price breaks instead of using 500,1200 and 2000 and cell references for all the different prices.
CorrectIncorrect