2005412
Topic 10:Spreadsheets
- A spreadsheet application
such as excel can store all its
data in a single file.This is
called a workbook.
- A workbook is made up of one or more worksheets, A
worksheet is a single tab in the spreadsheet
workbook.
- A workbook is made up of one or more worksheets, A
worksheet is a single tab in the spreadsheet
workbook.
- Cells
- A cell reference always starts
with a letter and ends with a
number e.g. A5 or H28
- A range of cells is a set of
cells in a row or column
- Data entered into cells can be different
data types e.g. text, number, currency,
date, percentage etc.
- Each cell can contain:
- Labels- any text in a cell
describing the data in a row
or column
- Data- any values that are
entered for the use of
calculation
- Formulas and
functions-
mathematical
calculations carried
out automatically
- Labels- any text in a cell
describing the data in a row
or column
- A cell reference always starts
with a letter and ends with a
number e.g. A5 or H28
- Formulas
- Must start with an =
- formulas perform
calculation son the cell
contents
- formulas appear in the formula bar
- The result of a formula is automatically
recalculated every time the data on a
spreadsheet changes
- 4 main mathematical
operations
- + add
- - substract
- * multiply
- / divide
- + add
- Must start with an =
- Funtions
- Must also start with an =
- Functions are part of spreadsheet
software. They are specialised
calculations built in to the
spreadsheet software
- Function name describes what
a function can do SUM, COUNT,
AVERAGE, MIN, MAX, IF.
- =SUM(D2:F7)
- =SUM(D2:F7)
- Must also start with an =
- formatting
- The content of a cell can be formatted
- Font style, size, colour, border style,
aligment, cell colour.
- multiple cells can be merged into one cell
- Font style, size, colour, border style,
aligment, cell colour.
- Cells are often formatted to reflect the
data that is held I them. Data types
include:
- currency, number,
- currency, number,
- The content of a cell can be formatted
Want to create your own Mind Maps for free with GoConqr? Learn more.