Data Final Exam Review

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

Front

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

Back

=

Front

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

Back

A cell

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)

Front

What is the main purpose of data validation in spreadsheets?

Back

To ensure data meets specific rules and requirements

Front

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

Back

Solid State Drives (SSDs)

Front

What's the difference between SUM and AVERAGE functions?

Back

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

Front

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

Back

Locks the cell reference when copying formulas

Front

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

Back

Right-click and select "Insert comment"

Front

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

Back

Use the Share button and give edit access