Spreadsheet - Basic Function

What is a cell in a spreadsheet?

• A group of columns

• A single box where a row and a column meet

• A page in the spreadsheet

• A type of formula

What is a row in a spreadsheet?

• A vertical line of cells

• A horizontal line of cells

• A single cell

• A type of data

What is a column in a spreadsheet?

• A box

• A horizontal line of cells

• A vertical line of cells

• A formula

What does “active cell” mean?

• The cell that is currently highlighted and ready for data entry

• A cell with a formula

• A merged cell

• A cell in column A

What happens when you merge cells in a spreadsheet?

• The cells are deleted

• You get multiple active cells

• The selected cells become one larger cell

• It creates a new column

Which formula is used to add values in spreadsheet?

• =MAX()

• =AVERAGE()

• =ADD()

• =SUM()

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

• Finds the biggest number from A1 to A5

• Adds the values in A1 to A5

• Calculates the average of values from A1 to A5

• Counts the cells

Which function returns the lowest number in a range?

• =MAX()

• =MIN()

• =LOW()

• =AVERAGE()

Which of the following is a correct arithmetic operation in spreadsheet?

• =A1 plus A2

• =A1 - A2

• A1 + A2 =

• =ADD(A1,A2)

Which symbol is used for multiplication in spreadsheets?

• x

• *

• ×

• #