null
US
Sign In
Sign Up for Free
Sign Up
We have detected that Javascript is not enabled in your browser. The dynamic nature of our site means that Javascript must be enabled to function properly. Please read our
terms and conditions
for more information.
Next up
Copy and Edit
You need to log in to complete this action!
Register for Free
2005412
Topic 10:Spreadsheets
Description
Mind Map on Topic 10:Spreadsheets, created by tia fenn on 11/02/2015.
No tags specified
gcse
Mind Map by
tia fenn
, updated more than 1 year ago
More
Less
Created by
tia fenn
about 9 years ago
12
0
1
Resource summary
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.
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
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
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)
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
Cells are often formatted to reflect the data that is held I them. Data types include:
currency, number,
Show full summary
Hide full summary
Want to create your own
Mind Maps
for
free
with GoConqr?
Learn more
.
Similar
Cognitive Psychology - Loftus and Palmer (1974)
Robyn Chamberlain
Italian: Basics
Selam H
Resumo para o exame nacional - Fernando Pessoa Ortónimo, Alberto Caeiro , Ricardo Reis e Álvaro Campos
miminoma
Themes in Lord of the Flies
lowri_luxton
Physics P2
Phoebe Drew
Rights and Responsibilities Flashcards - Edexcel GCSE Religious Studies Unit 8
nicolalennon12
Japanese Hiragana
pangcaberte
Using GoConqr to study Maths
Sarah Egan
Get your grammar right!
Sarah Holmes
2PR101 1.test - 7. část
Nikola Truong
1PR101 2.test - Část 20.
Nikola Truong
Browse Library