Presentation/web Authoring/spreadsheets

Front 1

Creating Pages

Back 1

Each complete screen is a page or slide. New slides can be created at any point.

Front 2

Master Slide

Back 2

a slide containing the default presentation details for each slide.

Front 3

House Styles

Back 3

Used to describe a set of rules that organisations may adopt to create and maintain a visual consistency.

Front 4

Slide Sorter/Slide View

Back 4

a common tool which provides an overview of the slides in the presentation

Front 5

Slide Transitions

Back 5

A visual effect used when changing from one slide to another.

Front 6

Outline View

Back 6

create slides by entering the text for the slides first

Front 7

Structure

Back 7

how the contents is displayed on the slide. Usually there are default structures/layouts

Front 8

Animation

Back 8

effects that can be applied to objects or headings to make them enter or exit the slide is a certain way e.g wedge, wipe, fly-in etc.

Front 9

House Sytle

Back 9

technique used to improve consistency of presentation (CSS)

Front 10

Action Buttons

Back 10

can be programmed to carry out specific operations e.g home button goes to first slide

Front 11

Hyperlinks

Back 11

when selected, in text or objects, the presentation software will try and load data from a URL.

Front 12

Presentation Software

Back 12

type of application software used to present information in the form of a sequence of slides

Front 13

Web Authoring

Back 13

type of application software used to present information for online media in the form of web pages in HTML

Front 14

Site Mapping

Back 14

a graphic overview that shows the links between pages and can be used to manage hoe the site is navigated

Front 15

Hyperlink

Back 15

an element in an electronic document that links to another place in the another or the same document. It is identified by using an anchor. Hyperlinks can be created through text, images or hotspots.

Front 16

Hotspot

Back 16

a number of areas within an image can be allocated each a different URL

Front 17

Cascading Style Sheets

Back 17

a separate file that can be shared across multiple web pages to help provide a consistent look across a website

Front 18

Spreadsheet Software

Back 18

type of application software used for data handling, especially numerical and statistical

Front 19

What-If Analysis

Back 19

used to see the effect of changing some parameters on related parameters

Front 20

Goal Seeking

Back 20

a technique used to automatically change the values in a formula until a desired result is achieved.

Front 21

Forecasting

Back 21

a technique used to calculate or predict a future value based on existing values

Front 22

Look Up Tables

Back 22

a table placed on a spreadsheet that spreadsheet software can retrieve data from. It can be inserted into the same spreadsheet or another one.

Front 23

Charting

Back 23

used to transform data into graphics

Front 24

TODAY and NOW Functions

Back 24

TODAY returns the current date

NOW returns the current date and time

Front 25

AND and OR Functions

Back 25

allows you to test logical conditions and return a result of true or false depending on which conditions are met.

Front 26

IF Function

Back 26

returns one value if a condition you specify is TRUE and another if it is FALSE

Front 27

Nested IF Functions

Back 27

a technique used to test a conditional formula within more than two possible outcomes (an IF inside an IF)

Front 28

COUNT Function

Back 28

counts the number of cells that contain numbers within a range

Front 29

COUNTIF Function

Back 29

counts the number of cells within a range that meet the given criteria

Front 30

Macros

Back 30

a sequence of instructions that can be used to automate complex or repetitive tasks.

Front 31

Creation and Use of Macros

Back 31

can be created by using a macro record or by programming them using a scripting language.

When required, they can be run using a menu or by accessing a keyboard shortcut.