# 9.2 Spreadsheets Flashcards

1.1 Spreadsheet

A program which is used to store, add, delete and edit data.

1.2 Worksheet

A collection of cells organised in rows and columns.

1.3 Function

A specific set of operations that can be performed on referenced values.

1.4 Formatting

A way that we can modify the data’s appearance in a worksheet.

1.5 Formula

An expression made by the user that can perform calculations on values in a range of cells

2.1 Cell

A location of a piece of data in a spreadsheet.

2.2 Row

A row arranges data horizontally from left to right.

2.3 Column

A column arranges data vertically from top to bottom.

3.1 IF

Returns a value if the criteria is met, returns another if the criteria is not met.

3.2 SUM

Adds a specific range of values.

3.3 SUMIF

Adds a specific range of values if they meet the criteria.

3.4 MIN

Finds the minimum value out of a range of cells.

3.5 MAX

Finds the maximum value out of a range of cells.

3.6 COUNT

Counts the number of cells that contain numbers.

3.7 VLOOKUP

Allow a search for a value across a set range of columns.