Spreadsheet review

What is the term for an individual box in a spreadsheet where you can enter data?

• Row

• Column

• Cell

• Sheet

Answer explanation

The term for an individual box in a spreadsheet where you can enter data is 'Cell'. Rows and columns refer to the horizontal and vertical arrangements of cells, while a sheet is the entire spreadsheet.

Which function calculates the average of a range of numbers?

• SUM

• AVERAGE

• COUNT

• MAX

Answer explanation

The AVERAGE function calculates the mean of a range of numbers by summing them and dividing by the count. SUM adds numbers, COUNT counts them, and MAX finds the highest value, making AVERAGE the correct choice for this question.

True or False: Cell reference B3 refers to the cell in column B, row 3.

• True

• False

Answer explanation

True. In spreadsheet terminology, a cell reference like B3 indicates the cell located in column B and row 3.

True or False: A spreadsheet is organized into rows and columns.

• True

• False

Answer explanation

True. A spreadsheet is indeed organized into rows and columns, allowing for the systematic arrangement of data.

True or False: A spreadsheet is organized into rows and columns.

• True

• False

Answer explanation

True. A spreadsheet is indeed organized into rows and columns, allowing for the systematic arrangement of data.

What is the term for the top row often used to label data categories?

• Title row

• Label row

• Header

• Category row

Answer explanation

The term 'Header' refers to the top row in a table that labels the data categories, making it the correct choice. Other options like 'Title row' and 'Label row' are not standard terms for this purpose.

True or False: The SUM function multiplies a range of numbers.

• True

• False

Answer explanation

The SUM function adds a range of numbers, not multiplies them. Therefore, the statement is False.

What is the term for the process of inputting information into spreadsheet cells?

• Data entry

• Data input

• Data insertion

• Data filling

Answer explanation

The correct term for the process of inputting information into spreadsheet cells is 'Data entry'. This term specifically refers to the act of entering data into a system, making it the most appropriate choice among the options.

What is the function used to add up a range of numbers in a spreadsheet?

• ADD

• SUM

• TOTAL

• PLUS

Answer explanation

The function used to add up a range of numbers in a spreadsheet is 'SUM'. This function efficiently calculates the total of selected cells, making it the correct choice among the options provided.

You can move data from one cell to another by dragging it.

• True

• False