Data Foundations | Test Your Knowledge – Final Quiz
In this final quiz, you’ll consolidate the knowledge you’ve gained from the Data Fundamentals course.
Quiz Summary
0 of 21 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 21 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
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 21
1. Question
- What are the 4 factors that contribute to the data analytics environment today? (select all that apply)
CorrectIncorrect -
Question 2 of 21
2. Question
What is categorical data?
CorrectIncorrect -
Question 3 of 21
3. Question
What is numerical data?
CorrectIncorrect -
Question 4 of 21
4. Question
In Excel, by default, numbers are aligned to the right. What does this signify?
CorrectIncorrect -
Question 5 of 21
5. Question
How do you paste vertical cells horizontally (and vice versa)?
CorrectIncorrect -
Question 6 of 21
6. Question
For the following dataset, what is the mean? (Rounded up)
10 12 15 15 15 15 17 19 19 22 23 25 27 28
CorrectIncorrect -
Question 7 of 21
7. Question
For the following dataset, what is the mode?
10 12 15 15 15 15 17 19 19 22 23 25 27 28 CorrectIncorrect -
Question 8 of 21
8. Question
For the following dataset, what is the median?
10 12 15 15 15 15 17 19 19 22 23 25 27 28 CorrectIncorrect -
Question 9 of 21
9. Question
For the following dataset, what is the range?
10 12 15 15 15 15 17 19 19 22 23 25 27 28 CorrectIncorrect -
Question 10 of 21
10. Question
What function would you use to: Count the number of filled cells?
CorrectIncorrect -
Question 11 of 21
11. Question
What function would you use to: Count the number of blank cells?
CorrectIncorrect -
Question 12 of 21
12. Question
What function would you use to: Count the number of cells that meet multiple conditions?
CorrectIncorrect -
Question 13 of 21
13. Question
What function would you use to: Calculate the the highest cell value in a selection?
CorrectIncorrect -
Question 14 of 21
14. Question
What function would you use to: Calculate the lowest cell value from a selection?
CorrectIncorrect -
Question 15 of 21
15. Question
What function would you use to: Sum the values in a selected cells where a criteria is met?
CorrectIncorrect -
Question 16 of 21
16. Question
Which of the following IS NOT a preattentive feature?
CorrectIncorrect -
Question 17 of 21
17. Question
Overuse of preattentive features can result in?
CorrectIncorrect -
Question 18 of 21
18. Question
Colour should be used in Visualisations to (select all that apply)
CorrectIncorrect -
Question 19 of 21
19. Question
Why should you (generally) avoid 3D charts?
CorrectIncorrect -
Question 20 of 21
20. Question
When using a Pivot Table, what happens to the table of data you are ‘Pivoting’?
CorrectIncorrect -
Question 21 of 21
21. Question
Sort the below to create a Pivot Table displaying Sales per Salesperson by Month, filtered on Product Category
Sort elements
- product_category
- Sale_Date
- salesperson
- sales_amount
-
Filter
-
Rows
-
Columns
-
Value
CorrectIncorrect