Untitled

Page 1

Modeling:

is about constructing a model. it is therefore about building representations of entities in the real world.

Modelling

software: is software used for the purpose of constructing a model.

Workbook:

A saved document containing all the spreadsheets inside.

Spreadsheet

A spreadsheet contains cells which can be referenced by their column and row.

Cell

A specific space on a spreadsheet. E.g. A1

Formula

A formula starts with a = then a function. Dependent on a function, it will determine the outcome.

Function

Controls the outcome of a formula. E.g. the SUM outcome will add a cell range. and the countif will count how many specific words/letters/numbers were used in a range.

Macros

A macro will enable specific added fields. For example, a macro will make a button do a specific job.

Range

A specific criteria of cells. For example A1:A3 will select A1, A2 and A3.

Visual Basic

VB is an alternative to Macros which can be easier to use with previous knowledge

A1+A2 = ADDS the 2 cells A1*A2 = MULTIPLIES the 2 cells A1/A2 = DIVIDES the 2 cells A1-A2 = SUBTRACTS the 2 cells

New Page