Flashcards
Topic 10 Spreadsheets
Flashcards do conjunto (12)
- 1What is a workbookA workbook is made up of one or more worksheets, which is a single tab in the spreadsheet workbook
- 2What is a LABELAny text in a cell describing the data in a row or column
- 3What is DATA in a spreadsheetAny values that are enetered for the use of calculation
- 4What is a FORMULA/FUNCTIONA mathematical calculation carried out automatically
- 5What does a formula consist of?-Must start with an =
+ ADD
- SUBTRACT
* MULTIPLY
/ DIVIDE - 6What does a funcltion consist of?-Must start with an =
-Are specialised calculations built in the spreadsheet software
-SUM, COUNT, AVERAGE, MIN, MAX, IF - 7What is formatting?Celles are often formatted to reflect the data that is held in them. Data types include: Currency, number, real, integer, date, text
- 8What is replicating cells?When you postition the mouse pointer in the bottom right hand corner of a cell, drag down/across the spreadsheet. If there is a formila in the cell, the spreadsheet tries to adjust it as it goes down the page to fit in the new position and cells being referred to
- 9What are the three types of chart and their purposeBar chart- to compare values
Pie chart- to show how a total is divided among a number of different categories
Line graph- display trends - 10What is relative cell referencing, and absolute cell referencing?Relative: when a cell is used in a formula amd the formula is copied to a new cell reference, the cell reference changes to take account the formula's new position
Absolute: the cell reference does not change and is glued in place by the $ character - 11What is a "What if" calaculationChanging the data in a spreadsheet model allows you to make and test predictions. These are known as what if calculations.
- 12What are the benefits of using a spreadsheetAutomtic recalculations
Accurate calculations
Graphs/charts
Replication
What if calculations
Formulas can be reused and stored
Informações
- Descrição
- FlashCards sobre Topic 10 Spreadsheets, criado por Alyssa Whatley em 08-03-2015.
- Criado por
- Alyssa Whatley
- Visualizações
- 0
- Avaliação