NEW
Font size
WorksheetsSpreadsheet - Basic Function
Total questions: 10
Worksheet time: 5mins
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
*
×
#
