
Decode the Data! An Intro to Data Science
Computers
University

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function can you use to calculate the average score in Excel?
=SUM(range)
=MEAN(range)
=AVERAGE(range)
=MEDIAN(range)
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What Excel feature helps to isolate rows that match specific conditions?
Sorting
Filtering
Conditional Formatting
Charts
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which chart is best for showing the relationship between two numerical variables?
Pie Chart
Bar Chart
Scatter Plot
Line Chart
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula would label a score above 60 as a pass?
=IF(Score>60, "Pass", "Fail")
=IF(Score>=60, "Pass", "Fail")
=IF(Score=60, "Fail", "Pass")
=IF(Pass, Score, Fail)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What function would you use to count the number of cells that contain numbers in a range in Excel?
=COUNT(range)
=SUM(range)
=COUNTA(range)
=COUNTIF(range, criteria)
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which formula would return the maximum value from a set of scores?
=AVERAGE(range)
=SUM(range)
=MAX(range)
=MIN(range)
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What Excel tool allows you to create a visual representation of data trends over time?
Pivot Table
Line Chart
Histogram
Data Table
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
9 questions
DSC119_Chap 3: Data Visualization Structure
Quiz
•
University
10 questions
Understanding Data Context and User Requirements
Quiz
•
University
10 questions
TIN HỌC 9
Quiz
•
9th Grade - University
10 questions
Lesson 2 - Passing Data to Subsystems
Quiz
•
University
10 questions
Ulangan Harian Informatika SPUMA (Analisis Data)
Quiz
•
University
10 questions
Data Preprocessing - Paatshala Quiz
Quiz
•
University
10 questions
Microsoft Excel Quiz
Quiz
•
University
10 questions
TES 1 ICT RUMAH PINTAR
Quiz
•
12th Grade - Professi...
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade