Excel & Data Capturing: Get Hired for Admin and Data Jobs
-
Chapter 1: Data Jobs and the Spreadsheet Basics You Need5 Topics|1 Quiz
-
Chapter 2: Data Capturing — Fast and Accurate5 Topics|1 Quiz
-
Chapter 3: Cleaning Messy Data5 Topics|1 Quiz
-
Chapter 4: Counting and Adding Up With Conditions5 Topics|1 Quiz
-
Chapter 5: Lookups — VLOOKUP and XLOOKUP5 Topics|1 Quiz
-
Chapter 6: Pivot Tables, Charts and Reports5 Topics|1 Quiz
-
Chapter 7: Protect the Data, Get Hired and Earn5 Topics|1 Quiz
Quizzes
Participants 1
Well done for reaching the Chapter 1 quiz! It has 5 short questions about what you have just learnt.
-
You need 60% (3 out of 5) to pass.
-
You can retake it as many times as you need — there is no penalty.
-
If you are unsure, go back to the lessons first — the answers are all there.
Quiz Summary
0 of 5 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 5 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%
-
Not quite there yet — and that is okay. You need 60% to pass. Go back to the chapter lessons to refresh your memory if you like, then try again. There is no limit on attempts.
-
Well done — you passed! Use the button below to continue to the next chapter.
- 1
- 2
- 3
- 4
- 5
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 5
1. Question
Which skills do data capturer job adverts commonly ask for?
CorrectIncorrect -
Question 2 of 5
2. Question
What does the range B2:B10 mean?
CorrectIncorrect -
Question 3 of 5
3. Question
A VAT rate is in cell F1. Which reference stays fixed when you copy a formula down?
CorrectIncorrect -
Question 4 of 5
4. Question
Which of these is a golden rule for a clean table?
CorrectIncorrect -
Question 5 of 5
5. Question
Why should you format a phone number column as text before typing?
CorrectIncorrect
Responses