NEW
Font size
WorksheetsData Analytics
Total questions: 10
Worksheet time: 3mins
How many steps involved in data analysis process?
5 Steps
4 Steps
6 Steps
7 Steps
What step do the data analyst spend most of their time during data analysis process?
Step 1: Define the question
Step 2: Collect the data
Step 3: Clean the data
Step 4: Analyze the data
Listed are types big data analytics EXCEPT
Abstractive Analytics
Descriptive Analytics
Prescriptive Analytics
Predictive Analytics
Listed are functions for cleaning data in Excel EXCEPT
Concatenate
Trim
Replace
Remove
What are the characteristics of Big Data?
High Volume Low Variety
High Veracity High Value
Low Value Low Authenticity
High Authenticity Low Veracity
What is the function in Excel to counts the number of cells that are not empty in a range?
Count
CountA
CountBlank
CountIf
Function SumIF() is to sum the values in a range that meet criteria.
True
False
Which of the followings is unstructured data?
Excel Spreadsheet
CSV file format
Web API file
YouTube Video
Embrace Failures is one of the step in data analytics process.
True
False
Usage data is one of data collection tools
True
False
