GY 5 Revision

What is a spreadsheet?

• A drawing tool

• A type of software that stores and calculates data

• A type of game

• A programming language

What can spreadsheets do?

• Send emails

• Play music

• Work out sums and draw charts

• Edit photos

What are values in a spreadsheet?

• Pictures

• Headings

• Numbers used in calculations

• Links to websites

What are labels in a spreadsheet?

• Labels are formulas used for calculations.
• Labels are the colors used to format cells.
• Labels are the actual data values in cells.
• Labels in a spreadsheet are headers that identify the contents of rows and columns.

What is a cell in a spreadsheet?

• A cell is a basic unit in a spreadsheet where data is entered.
• A cell is a graphical representation of data in a spreadsheet.
• A cell is a type of formula used in spreadsheets.
• A cell is a feature that automatically saves the spreadsheet.

How is a cell reference written?

• A cell reference is written as a number followed by a letter.
• A cell reference is written as a single letter.
• A cell reference is written as a combination of a column letter and a row number.
• A cell reference is written as a combination of two letters.

Rows in a spreadsheet are identified by?

• Numbers
• Dates
• Colors
• Letters

What does the AutoSum function do?

• The AutoSum function filters data based on criteria.
• The AutoSum function creates a chart from selected data.
• The AutoSum function calculates the sum of a range of cells.
• The AutoSum function formats cells for better visibility.

What is the name of this icon?

• Borders

• 
  Sort

• AutoSum

• Merge & Center

What is the name of this icon?

• Merge & Center

• Sort

• Borders

• AutoSum