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