KS3 Spreadsheets

Chart

A Graphic representation of data

Formula

A basic calculation

Cell

A box on a spreadsheet

Shading

A color used to fill the background of a cell

Function

A formula with a word e.g. SUM MIN MAX

Spreadsheet model

A simulation of a real-life situation. For example, plan an event like a school trip or concert.

Column

A vertical line of cells

Workbook

An Excel file that contains individual worksheets. Also called a spreadsheet file.

######

Column is not wide enough

.xls

File extension for a document created in Excel

SUM

Finds the total of a range of cells

Max

Function to find the largest number =MAX

Min

Function to find the lowest number, =MIN(F14:F55)

Row

Horizontal line of cells

Borders

Lines added around cells

Worksheets

Tabs you see at the bottom of your workbook file, labeled Sheet 1, Sheet 2, and so on.

Cell reference

The column and the row number of a cell, e.g. C13; F27;

Fill handle

The small square in the lower right corner, that allows you to copy patterns

+

This symbol is used in a formula to add

/

This symbol is used in a formula to divide

*

This symbol is used in a formula to multiply

-

This symbol is used in a formula to subtract

Merge

To combine multiple cells into one cell.

Range

When 2 or more cells that are selected e.g. B1:B8

Average

the sum of all numbers divided by the amount of numbers. =Average(A15:A37)