SKO - Spring 2 - Spreadsheets

What is a menu bar?

• A vertical bar at the top of the screen containing drop down menu options

• A horizontal bar at the top of the screen containing drop down menu options

• A vertical bar at the side of the screen containing drop down menu options

A tool bar is ...

• A drop down function which allows you to edit a formula

• A drop down function which helps you when you're stuck.

• row(s) of buttons in a program that are clicked to select values or functions in a spreadsheet.

Columns are ...

• A range of cells that go down, vertically (top to bottom) in a spreadsheet

• A range of cells that go across, horizontally (left to right) in a spreadsheet

• A range of cells that may go either vertically or horizontally in a spreadsheet

A row is ...

• A range of cells that go down, vertically (top to bottom) in a spreadsheet

• A range of cells that go diagonally in a spreadsheet

• A range of cells that go across, horizontally (left to right) in a spreadsheet

What is a cell?

• a few squares in the spreadsheet

• a single square in the spreadsheet

• the interaction between a row and column

A cell reference is ...

• The intersection between a row and column in a spreadsheet. It's like the address of the cell

• Simply the row that cell is on only

• Simply the column that cell is on only

A3, B7 and G9 are all examples of ...

• Absolute referencing

• Cell referencing

• Cell formulae

In Spreadsheets a formula or equation which allows you to make calculations always starts with a ...

• +

• /

• =

A label is what spreadsheets call a ...

• A title explaining the value of contents held in the column or row

• The format of the cells in a column or row

• The font used in a cell

Format refers to ...

• The size of the cell only

• The appearance of a document including font, colours, size and rotation and how data is displayed in cells

• The way that formulae appear in cells