Topic 4-Spreadsheet Applications Flashcards Preview

Digital Technology (GCSE) > Topic 4-Spreadsheet Applications > Flashcards

Flashcards in Topic 4-Spreadsheet Applications Deck (12):
1

Spreadsheet structure

-A spreadsheet contains one or more worksheets
-A worksheet is presented as a gird in the form of rows and columns
-Spreadsheets are designed to allow applications to preform calculations are recalculations automatically
-Cells can store data in a variety of forms,for example text,number,date,formula and so on
-Spreadsheet data can be formed as:general,number,currency,data,time,percentage and so on
-Formatting can also control the appearance of a cell,for example aligning text,changing the font or adding a border or background colour
-Conditional formatting allows cell shading or font colour to be applied to a cell or group of cells if a specified condition is met
-A value inputted to a given cell(s) can be controlled using data validation

2

Templates

-A template refers to a document that has been pre-formatted using a predetermined layout for the user
-It serves as a starting point for a new document
-For example,a budget template will have allocated places for entering data such as income and expenditure for a company budget

3

Importing data

-Data can be imported into a spreadsheet from other software sources,for example a database table
- In some cases,the file being imported may have to be in a certain format,for example CSV (comma-separated value),before the import process can begin

4

Headers and footers

-To improve the presentation of worksheets, headers (placed at the top of the worksheet) and footers (placed at the bottom of the worksheet)
-These can be used to add page numbers, filenames or dates

5

Formulas and functions

-Formulas and functions allow a spreadsheet to preform calculations and automatic re-calculations
-When a formula or function is entered into a cell it can be replicated quickly down a column or across a row using the 'Fill' function

6

Sum(function)

SUM(A1:A10)
I he cells in the range A1 to A10 are added together and the total is displayed

7

Average(function)

AVERAGE(A1:A10)
The cells in the range A1 to A10 are added together snd the average is calculated

8

Max(Function)

MAX(A1:A10)
The highest value in the cell range A1 to A10 is returned

9

MIN(Function)

MIN(A1:A10)
The lowest value in the cell range A1 to A10 is returned

10

See pages 18 and 19 in new ICT book

See pages 18 and 19 in new ICT book

11

Using spreadsheets for data modelling

-Spreadsheets are used in organisations for data modelling
-The model is controlled by a set of rules defined by formulas.By changing the formulas,the rules of the model can be varied
-Being able to answer 'What if' questions,such as 'What if we increase our number of employees by 10 per cent;will it decrease our profits?',allow business to predict future outcomes
-Using a spreadsheet to model data can assist in making better-informed decisions

12

What does data modelling do

Data modelling uses mathematical formulas and calculations on data to help predict outcomes for given situations