Basic Excel Skills Test.
0 of 13 Questions completed
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:
0 of 13 Questions answered correctly
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)
Question 1 of 13
When I type a number into a cell, it’s coming up as a date.What should I do?CorrectIncorrect
Question 2 of 13
What is wrong with this Formula:
Question 3 of 13
How will Excel evaluate this Formula:
=B1+C2 * D3CorrectIncorrect
Question 4 of 13
How can you configure the worksheet to show the formulas instead of the results.CorrectIncorrect
Question 5 of 13
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
What is the fill handle and how do you use it?CorrectIncorrect
Question 7 of 13
Question 8 of 13
I want to find the largest number in a range of numbers. Which Function should I Use?CorrectIncorrect
Question 9 of 13
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
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
I want to freeze row 3 of my worksheet.How will I do it?CorrectIncorrect
Question 12 of 13
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
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