Google Sheets Quiz

What is the function of the 'Merge' tool in Google Sheets?

• It joins two or more cells into one.

• It adds up the total of a set of numbers.

• It finds the mean of a set of numbers.

• It formats the text in a cell.

What does the 'SUM' function do in a spreadsheet?

• It multiplies all numbers in a set.

• It adds up the total of a set of numbers.

• It divides the total by the number of entries.

• It subtracts the smallest number from the largest.

What is the purpose of the 'AVERAGE' function in Google Sheets?

• It finds the median of a set of numbers.

• It finds the mean of a set of numbers.

• It finds the mode of a set of numbers.

• It finds the range of a set of numbers.

What is the function of the 'Fill Cursor' in Google Sheets?

• It moves columns and rows.

• It automatically enters information/copies data/formulas

• It deletes information.

• It highlights text.

What is a spreadsheet?

• A document with text only

• A type of graph

• An electronic document with data in columns and rows

• A type of database

How are columns identified in a spreadsheet?

• By numbers

• By colors

• By letters

• By symbols

What is the intersection of a row and a column called?

• A cell

• A graph

• A label

• A function

What is an active cell?

• A cell with a formula

• A cell that has been selected

• A cell with a number

• A cell with a label

What is a cell reference?

• The color of a cell

• The size of a cell

• The name of a cell based on its column and row

• The formula in a cell

What is a function in a spreadsheet?

• A type of graph

• A pre-written formula

• A cell reference

• A label