Data Final Exam Review

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

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

• #

• $

• =

• @

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

• A grid

• A cell

• A point

• A box

Which formula would correctly find the average of numbers in cells A1 through A10?

• =AVERAGE(A1-A10)

• =AVERAGE(A1:A10)

• =AVERAGE(A1,A10)

• =AVERAGE(A1+A10)

What is the main purpose of data validation in spreadsheets?

• To make the spreadsheet look better

• To ensure data meets specific rules and requirements

• To delete incorrect data automatically

• To share the spreadsheet with others

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

• USB Drives

• External Hard Drives

• Solid State Drives (SSDs)

• Cloud Storage

What's the difference between SUM and AVERAGE functions?

• SUM adds numbers, AVERAGE finds the middle number

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

• SUM only works with whole numbers, AVERAGE works with decimals

• There is no difference

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

• Formats the cell as currency

• Locks the cell reference when copying formulas

• Adds money to the total

• Makes the number positive

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

• Type // before your comment

• Right-click and select "Insert comment"

• Press the Comment button in the toolbar

• Type the comment in the next cell

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

• Email them a copy

• Use the Share button and give edit access

• Print it out and hand it to them

• Take a screenshot and send it