Unit 1 Basic spreadsheet terminology, concepts, and functions.

What is a spreadsheet used for?

• Playing music

• Organizing and analyzing data

• Editing videos

• Sending emails

What is a cell in a spreadsheet?

• The toolbar section

• A complete table

• The intersection of a row and a column

• A type of formula

Which of the following is a spreadsheet file called?

• Worksheet

• Workbook

• Database

• Document

Which of the following is an example of a formula?

• Text

• 100

• =A1+B1

• A comment

What does the `=SUM(A1:A5)` function do?

• Divides all numbers

• Counts the cells

• Adds the numbers in cells A1 to A5

• Multiplies A1 by A5

In Excel, which symbol is used to start a formula?

• #

• @

• ,

• =

What does the `=IF(A1>50,"Pass","Fail")` formula do?

• Sorts the data

• Validates the input

• Checks a condition

• Merges cells

What does the SUM function do?

• Counts the number of numeric entries

• Adds numeric values in selected cells

• Multiplies numeric values

• Returns the largest value in a range

Which reference does NOT change when copied to another cell

• A1

• \$A\$1

• =\A\1

• "A+1"

Which of the following is a relative cell reference?

• A1

• $A$1

• A$1

• $A1