DATA ANALYTICS
Quiz by Sonia Lakra
Feel free to use or edit a copy
includes Teacher and Student dashboards
Measure skillsfrom any curriculum
Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
- edit the questions
- save a copy for later
- start a class game
- automatically assign follow-up activities based on students’ scores
- assign as homework
- share a link with colleagues
- print as a bubble sheet
- Q1
Which function isused to calculate the average of a range of cells in Excel?
None
AVERAGE
MEAN
AVG
10s - Q2
What function is used to count the number of cells with numeric values within a range in Excel?
COUNT
SUM
COUNTA
NUMCOUNT
30s - Q3
In Excel, what is the keyboard shortcut to paste only values from the clipboard?
Ctrl + C
Ctrl + Alt +V
Ctrl + Shift+ V
Ctrl + V
30s - Q4
What does the CONCATENATE function in Excel do?
Combines two or more text strings into one
Searches fora specific character in a cell
Converts text to uppercase
Counts the number of characters in a cell
30s - Q5
What is the primary goal of prescriptive analytics?
Predicting future outcomes
Describing past events
Recommending actions for optimal outcomes
Providing insights into data patterns
10s - Q6
Which type of analytics focuses on understanding the reasons behind historical data patterns?
DescriptiveAnalytics
Predictive analytics
PrescriptiveAnalytics
DiagnosticAnalytics
10s - Q7
What is the process of transforming raw data into a structured format for analysis called?
Data Mining
DataVisualization
Data Wrangling
Data Exploration
30s - Q8
What is the main goal of exploratory data analysis (EDA) in data science?
Building predictive models
Data pre-processing
Data visualization
Extracting insights from data
30s - Q9
What type ofdata visualization is used to display the distribution and relationshipsbetween multiple variables?
Histogram
Heatmap
Scatter Plot
Box Plot
10s - Q10
In machinelearning, what is the process of teaching a model with labelled data to makepredictions on new, unseen data called?
SupervisedLearning
Semi-Supervised Learning
UnsupervisedLearning
Reinforcement Learning
10s