Topic 10 Spreadsheets

Topic 10 Spreadsheets

1. Keywords and Definitions

   • Cells
     • A cell reference always starts with a letter and ends with a number.
     • A range of cells is a set of cells in a row or column.
   • Labels
     • Any text in a cell describing the data in a row or column.
   • Data
     • Any values (text or numbers) that are entered for the use of calculation.
   • Formulas and functions
     • Mathematical calculations carried out automatically.
     • Formulas and Functions must start with an =.

2. Advantages and Disadvantages

   • A: Automatic recalculation. Accurate calculations.
   • A: Graphs/Charts.
   • A: What if calculations.
   • Replication

3. Examples

   • Cell Reference: A5 or H28
   • Formula: =(B3*C6)+E12
   • Function: =SUM(D2:F7
   • Data types ca often include: Currency, number, real, integer (whole number), date, text.

4. Exam Questions and Answers

   • Explain the use of what if calculation.
     • ‘What if?’ calculations allow you to use the spreadsheet to see what would happen if you changed certain figures in the spreadsheet. They are used to predict outcomes.