Basic Excel Skills 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