Worksheets, workbooks, rows, columns, cells and ranges

charcrawford
Mind Map by , created almost 6 years ago

A level ICT (3.1.4 Spreadsheet concepts) Mind Map on Worksheets, workbooks, rows, columns, cells and ranges, created by charcrawford on 11/14/2013.

20
1
0
Tags
charcrawford
Created by charcrawford almost 6 years ago
ICT Revision 2014
11RaceyG
ICT GCSE flashcards
Catherine Archer
Input and Output Devices
Jess Peason
Circulatory System
bridget.watts97
Factores Humanos en la Aviación
Adriana Forero
MICROSOFT WORD 2013 SKILLS FOR WORK
John O'Driscoll
Types and Components of Computer Systems
Jess Peason
Input Devices
Jess Peason
GCSE ICT Revision
Andrea Leyden
OCR gcse computer science
Jodie Awthinre
Worksheets, workbooks, rows, columns, cells and ranges
1 A worksheet is a single sheet (page) of rows and columns in a workbook.
1.1 Data can be entered into one worksheet then referenced by the use of a formula or function. If the data is changed it will update all worksheets.
1.2 Benefits:
1.2.1 If one value is changed, it can be changed on all others.
1.2.2 Different displays can be used with different formats (individually coloured)
1.2.3 Can be hidden from other users. (Confidentiality)
1.2.3.1 Own access rights so authorised people can view, change or amend data.
1.2.4 A master worksheet can be created which pulls values from individual worksheets. -> create summary of key data.
1.2.5 Charts -> summarise data. (Visual representation) -> easier to analyse and compare.
2 A workbook is a collection of worksheets, stored in a single file and given a single name.
2.1 Can contain links
3 Rows
3.1 Range of cells that go across the spreadsheet horizontally.
3.2 Identified by number e.g. row 1, row 5
4 Columns
4.1 Range of cells that goes down the spreadsheet (vertically).
4.2 identifies by letters e.g. column A
5 Cells
5.1 The individual boxes within worksheets.
5.2 Has a unique cell-reference e.g. A1, B2
5.3 Holds text, numbers and formulae.
6 Range
6.1 Group of selected cells adjacent or non-adjacent
6.2 e.g. B6:H6

Media attachments