Flashcards
IT Topic 10
Cards in this deck (11)
- 1Workbook- A spreadsheet application that can store all its data in one single fileData entered into cells can be different data types
- 2Worksheet- A single tab in a spreadsheet workbookFormulas must start with a =
- 3Labels- Any text in a cell describing the data in a row or columnFormulas perform calculations on other cells
- 4Data- Any values that are entered for the use of calculationsFormulas appear in the formula bar
- 5Formulas and functions- Mathematical calculations carried out automaticallyMain operators-
+ add
- subtract
*multiply
/ divide - 6A cell reference always starts with a letter and ends with a numberA range of cells is a set of cells in a row or column
- 7Functions must start with a =Functions are built into the spreadsheet software
- 8The content of a cell can be formattedMultiple cells can be merged into one cell
- 9You can replicate cellsSpecific data can be selected and a graph can be made out of it
- 10Automatic recalculation when the content of a cell is changed the calculation is re performedAccurate calculations-
Formulas always produce the correct answer - 11Replication- You can drag a formula and replicate it into cellsWhat if?
These are used to produce text if a scenario is true or false. It is compared to preset answers
Information
- Description
- Flashcards on IT Topic 10, created by Sophie Aldous on 05/03/2015.
- Created by
- Sophie Aldous
- Views
- 0
- Rating