Spreadsheet Modelling

Question 1

Computer model

Answer 1

A model (or application) which can be used to predict the outcome of a real-life desicion.

Question 2

Spreadsheet modelling

Answer 2

Used to model real life situations, & they can help predict the likely outcome of certain decisions

Question 3

Financial modelling

Answer 3

A spreadsheet that uses formulas and data to forecast financial performance and scenarios.

Question 4

Data model

Answer 4

A way to organise and connect data in a spreadsheet, often using tables and relationships to analyse it more effectively.

Question 5

Absolute cell reference

Answer 5

A cell reference that will not change at all when it is copied and spread across multiple cells

Question 6

Relative cell reference

Answer 6

A cell reference that changes based on the position where it is copied.

Question 7

Conditional formatting

Answer 7

Conditional formatting in Excel is a feature that automatically applies formatting, such as colors or fonts, to cells based on specific criteria or conditions.

Question 8

Data validation

Answer 8

Data validation in Excel is a feature that ensures the accuracy and consistency of data by restricting the type, format, or range of values that can be entered into a cell.

Question 9

Range

Answer 9

A group of selected cells in a spreadsheet, specified by the top-left and bottom-right cells

Question 10

Named range

Answer 10

A range of cells in a spreadsheet given a specific name to make it easier to refer to in formulas