Flashcards
Sem título
Flashcards do conjunto (21)
- 1Topic 10 - Spreadsheets MLFTopic 10 - Spreadsheets
MLF - 2What is a spreadsheet?Spreadsheets are for manipulating numbers and doing calculations for modelling real life situations. A spreadsheet application such as Excel can store all its data in a single file (with an .xls extension).
- 3What is a workbook?A workbook is a single file made up of one or more 'worksheets'.
- 4What is a worksheet?A worksheet is a single tab in the spreadsheet workbook.
- 5State the basics of cells□ A cell reference always starts with a letter and ends with a number e.g. A5 or H28
□ Range of cells - set of cells in a row or column
□ Data entered into cells can be of different data types e.g. text, number, currency, date, percentage etc. - 6What can each cell contain?Each cell can contain:
Labels – any text in a cell describing the data in a row or column(titles, headings that identify data)
Data – any values (text or numbers) that are entered for the use of calculation
Formulas and functions – mathematical calculations carried out automatically - 7What is the purpose of formulas and explain the basics about themFormulas perform calculations on cell contents.
□ Must start with an =
□ Formulas appear in the formula bar.
□ The result of a formula is automatically recalculated every time the data on a spreadsheet changes.
E.g. =(B3*C6)+E12 - 8What are the 4 main mathematical operations?Below are the 4 main mathematical operations:
+ Add
- Subtract
* Multiply
/ Divide - 9State the purpose of functions and the basics of them□ Functions are part of spreadsheet software. They are specialized calculations built in to the spreadsheet software.
□ Must also start with an =
□ Function name describes what a function can do like SUM, COUNT, AVERAGE, MIN, MAX, IF e.g. =SUM(D2:F7) - 10State the purpose of cell formatting and the basics of them□ Cells are often formatted to reflect the data that is held in them. Data types include: Currency, number, real, integer (whole number), date, text.
□ The content of a cell can be formatted: Font style, size, colour, border style, alignment, cell colour.
□ Multiple cells can be merged in to one cell. - 11Explain the purpose of graphs and charts and the features of them□ Using charts/graphs allows us to notice patterns & trends more easily.
□ Specific data can be selected on a spreadsheet and a chart/graph of this data can be created:
Bar charts – to compare values.
Pie charts – to show how a total is divided among a number of different categories. Line graph – display trends. - 12What are the benefits of using a spreadsheet?□ Automatic recalculation - Every time the content of a cell is changed, calculations are performed and other cells are updated if necessary.
Accurate calculations - Providing the formulas have been set up correctly, the formulas will always produce a correct calculation
□ Graphs/Charts - Can be drawn using data in selected cells.
□ Replication - Once the first formula is correctly entered, it is possible to drag across to adjacent cells in a row or column so the computer copies the pattern of the calculation. - 13What are the additional benefits of using a database?□ What if calculations
□ Formulas can be reused and stored
□ Calculations involving large numbers are possible - 14What is a relative cell reference?Relative cell references is when a cell is used in a formula and the formula is copied to a new cell reference (address) , the cell references (cell address) changes to take account of the formula’s new position.
- 15Put relative cell references into contextRelative cell references:
□ If a formula is copied by filling down, the cell references are adjusted as you drag the replication pointer down the page. This is because it uses the relative address of the cells based on their position in the worksheet. - 16What is cell referencing?□ When a formula is copied by ‘filling down’ the cell references in cells are adjusted as you drag the pointer down the page.
- 17What is absolute cell referencing?Absolute cell referencing is where a reference to a cell used in a formula where, when the formula is copied to a new cell reference (cell address), the cell reference (cell address) does not change. It is "glued" in place by the $ character.
- 18Put absolute cell reference into context□ Some we need to use part of a formula that does not change. For example is VAT was recorded in B2 as 20% then the B2 part of the formula must not change because the rate will be 20% for everything. All the other cell ranges will change. When the formula is copied down, the relative address changes but the absolute doesn’t.
- 19What is the $ character for in absolute cell referencing?□ These use the $ character in front of the letter and number that are required to stay the same.
- 20What are "What if?" calculations?□ Changing the data in a spreadsheet model allows you to make and test predictions. These are known as what if calculations. They allow you to use a spreadsheet to see what would happen if certain figures changed in a spreadsheet.
- 21Give an example of a "What if?" calculationYou may explore what would happen to your profit if VAT changed to 30%.
Informações
- Descrição
- FlashCards sobre Sem título, criado por N H em 04-03-2015.
- Criado por
- N H
- Visualizações
- 1
- Avaliação