# 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