In a spreadsheet, what does the dollar sign ($) do when used in a formula?

Locks the cell reference when copying formulas

How do you add comments to a cell in Google Sheets?

Right-click and select "Insert comment"

What's the best way to share a Google Sheet with classmates for a group project?

Use the Share button and give edit access

What does the MIN function do in a spreadsheet?

Finds the smallest number in a range

What happens when you "freeze" a row in a spreadsheet?

It stays visible when you scroll down

How can you quickly fill a series of numbers (1, 2, 3...) in a column?

Type the first two numbers and drag the fill handle

Which of the following is considered personal data that should be protected? The school's address, Today's lunch menu, A student's home address and phone number, The start time of school

A student's home address and phone number

In data collection, what does "data minimization" mean?

Collecting only the data that is necessary

Which is an example of responsible data handling? Options: Sharing all student grades publicly, Using password protection for sensitive information, Collecting data without telling people, Keeping data forever "just in case"

Using password protection for sensitive information

What should you do if you find a spreadsheet containing private student information?

Tell a teacher or administrator immediately

Why is it important to get permission before collecting data about people?

It's polite, It's required by law in many cases, It helps people trust you

When collecting survey data, what's the most ethical approach? Options: Make participation mandatory, Make it anonymous and voluntary, Offer rewards for participating, Share responses publicly

Make it anonymous and voluntary

What's the primary purpose of data validation in forms?

Ensuring users enter valid data

What's the best way to spot errors in a large dataset? Options: Read every number carefully, Print it out, Ask someone else to check it

Use conditional formatting to highlight unusual values

When would you use a scatter plot?

To show how two variables might be related.

You're analyzing data about homework completion rates. You notice that one student has completed 500 assignments this week. This is probably: Accurate data showing a hard-working student, A data quality issue that should be investigated, Normal variation in the data, Not important to check

A data quality issue that should be investigated

Which of these shows the best understanding of data responsibility? Sharing interesting findings about classmates on social media, Keeping all data forever just in case it's needed, Only collecting necessary information and protecting private data, Using data without checking if it's accurate

Only collecting necessary information and protecting private data

A teacher asks you to help analyze test scores. What should you do first?

Check if you have permission to access the data

Your friend wants to create a survey about student mental health. What advice should you give?

Keep it anonymous and get school approval first

What's the best way to present data findings to your class? Options: Include every detail you found, Use clear visuals and focus on key points, Make it as complicated as possible, Only show the raw numbers

Use clear visuals and focus on key points

If you find an error in published data, you should:

Report it to the appropriate person

When working with real-world data, why is it important to check the date it was collected?

Data might be outdated or irrelevant

What's the most important thing to consider when choosing colors for a data visualization?

Consider colorblind accessibility

If you're using data to make a decision, you should:

Consider all relevant data, even if it contradicts your initial thoughts.

Data Final Exam Review Flashcards

Student preview

50 questions

Show all answers

1.

FLASHCARD QUESTION

Front

Which of the following is an example of Big Data? A list of 10 students' favorite movies, Your weekly homework grades, All TikTok video views, likes, and comments from one day, The lunch menu for the school year

Back

All TikTok video views, likes, and comments from one day

2.

FLASHCARD QUESTION

Front

In spreadsheets, what is the correct way to start any formula?

Back

=

3.

FLASHCARD QUESTION

Front

When looking at a Google Sheet, the box where column B and row 3 intersect is called:

Back

A cell

4.

FLASHCARD QUESTION

Front

Which formula would correctly find the average of numbers in cells A1 through A10? Options: =AVERAGE(A1-A10), =AVERAGE(A1:A10), =AVERAGE(A1,A10), =AVERAGE(A1+A10)

Back

=AVERAGE(A1:A10)

5.

FLASHCARD QUESTION

Front

What is the main purpose of data validation in spreadsheets?

Back

To ensure data meets specific rules and requirements

6.

FLASHCARD QUESTION

Front

What is the definition of storage devices using flash memory for faster data access and transfer?

Back

Solid State Drives (SSDs)

7.

FLASHCARD QUESTION

Front

What's the difference between SUM and AVERAGE functions?

Back

SUM adds numbers, AVERAGE divides the total by how many numbers there are.

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

Apple

Others

Already have an account?

Similar Resources on Wayground

46 questions

HGeo Unit 2 Test Review

Flashcard

•

9th Grade - University

47 questions

English-Kazakh Flashcards

Flashcard

•

KG

37 questions

Grade 11 CAT

Flashcard

•

11th Grade

37 questions

Untitled Flashcards

Flashcard

•

9th - 12th Grade

50 questions

English-Hebrew Flashcards

Flashcard

•

12th Grade

49 questions

REVIEWER FOR PREFINALS in MATHEMATICS 8

Flashcard

•

8th Grade

52 questions

Socialization Concepts

Flashcard

•

9th Grade

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

29 questions

Alg. 1 Section 5.1 Coordinate Plane

Quiz

•

9th Grade

$fractions$

22 questions

fractions

Quiz

•

3rd Grade

11 questions

FOREST Effective communication

Lesson

•

KG

20 questions

Main Idea and Details

Quiz

•

5th Grade

20 questions

Context Clues

Quiz

•

6th Grade

Discover more resources for Computers

15 questions

Digital Safety Scenarios

Quiz

•

10th Grade

10 questions

Exploring Cybersecurity Techniques and Threats

Interactive video

•

6th - 10th Grade