1
Q

A

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

2
Q

1.2 Worksheet

A

A collection of cells organised in rows and columns.

3
Q

1.3 Function

A

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

4
Q

1.4 Formatting

A

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

5
Q

1.5 Formula

A

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

6
Q

2.1 Cell

A

A location of a piece of data in a spreadsheet.

7
Q

2.2 Row

A

A row arranges data horizontally from left to right.

8
Q

2.3 Column

A

A column arranges data vertically from top to bottom.

9
Q

3.1 IF

A

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

10
Q

3.2 SUM

A

Adds a specific range of values.

11
Q

3.3 SUMIF

A

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

12
Q

3.4 MIN

A

Finds the minimum value out of a range of cells.

13
Q

3.5 MAX

A

Finds the maximum value out of a range of cells.

14
Q

3.6 COUNT

A

Counts the number of cells that contain numbers.

15
Q

3.7 VLOOKUP

A

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

16
Q

3.8 Absolute Cell Referencing

A

A way of referencing a value in a specific cell. The cell reference will not change when the formula is copied.

17
Q

4.1 +

A

Adds the data in two cells

18
Q

4.2 -

A

Subtracts the data in one cell from another

19
Q

4.3 *

A

Multiplies two numbers/cells

20
Q

4.4 /

A

Divides the data in one cell by another

21
Q

4.5 <

A

Less than

22
Q

4.6 >

A

Greater than

23
Q

4.7 <=

A

Less than or equal to

24
Q

4.8 >=

A

Greater than or equal to