I am a Microsoft trainer with 22 years teaching experience and still find it surprising how many people don't have basic Excel skills that could save them hours of wasted time.
Think you're pretty good? Our quiz is targeted at basic to intermediate level
See if you can earn a place in the leader board. Don't forget to Share this too
Register if you want to get your results emailed
Thank you.
Anita Lund (Excel Guru)
Excel Essentials Test
Quiz-summary
0 of 10 questions completed
Questions:
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
Information
If you want your results emailing, complete the email box at the end. Good luck!
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 have to finish following quiz, to start this quiz:
Results
0 of 10 questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 points, (0)
Categories
- Not categorized 0%
| Pos. | Name | Entered on | Points | Result |
|---|---|---|---|---|
| Table is loading | ||||
| No data available | ||||
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Answered
- Review
-
Question 1 of 10
1. Question
Which of the following formulas will total the values in cells B2 to B10?
Correct
Incorrect
-
Question 2 of 10
2. Question
TRUE or FALSE – The formula =B2*$B$18 in cell D2 would multiply the contents of cells B2 and B18. When copied down column D, B2 would change to B3, B4, B5 relative to the formulas position whereas B18 would remain constant.
Correct
Incorrect
-
Question 3 of 10
3. Question
Which of the following would be the most efficient way of inserting 2 new rows below Row 3?
Correct
Incorrect
-
Question 4 of 10
4. Question
The formula =NOW() is used to insert only the current date in a cell TRUE or FALSE?
Correct
Incorrect
-
Question 5 of 10
5. Question
Which function would you use to total a range of cells that meet a specific criteria?
Correct
Incorrect
-
Question 6 of 10
6. Question
Which keyboard shortcut would take me back to cell A1?
Correct
Incorrect
-
Question 7 of 10
7. Question
Which of the following would NOT wrap text inside a cell?
Correct
Incorrect
-
Question 8 of 10
8. Question
Which of the following logical operators means less than or equal to?
Correct
Incorrect
-
Question 9 of 10
9. Question
How would you select A2 to A20 and C2 to C20?
Correct
Incorrect
-
Question 10 of 10
10. Question
Which formula would you use to find the highest value in B2:B10?
Correct
Incorrect
Leaderboard: Excel Essentials Test
| Pos. | Name | Entered on | Points | Result |
|---|---|---|---|---|
| Table is loading | ||||
| No data available | ||||
Recent Comments