ICT Spreadsheets Vocabulary Lesson 3

Absolute references

• 1. A cell address that does not change when you copy the formula to another cell.

• 1. A circular chart divided into slices. Each slice represents a part of the whole. 

• 1. A small clickable shape that you can click to make something happen, such as save a file.

• 1. The rules for how to put words and symbols together in code and spreadsheet formulas. 

Argument

• 1. A function that counts the number of cells that have numbers in them.

• 1. The information you put inside a formula to tell it what to do. 

• 1.  A symbol that tells the computer what math to do with the numbers. 

• 1. A function that adds up all the numbers in a selected group of cells.

Conditional formatting

• 1.  A way to organize information in a grid using columns and rows. 

• 1. A circular chart divided into slices. Each slice represents a part of the whole. 

• 1. A feature that changes the appearance of cells based on specific rules or conditions. 

• 1. The rules for how to put words and symbols together in code and spreadsheet formulas. 

COUNT

• 1. A cell address that does not change when you copy the formula to another cell.

• 1.  A circular chart divided into slices. Each slice represents a part of the whole. 

• 1. The line on the side of a chart that goes up and down, showing labels or values. 

• 1.  A function that counts the number of cells that have numbers in them.

MAX

• A function that finds the largest number in a group of numbers.

• 1.  A cell address where one part stays the same and other part changes. 

• 1.  A chart that uses dots to show how two things are connected by looking for patterns.

•  A type of chart that shows how something changes over time by connecting dots with straight segments.

MIN

• 1. A chart that uses dots to show how two things are connected by looking for patterns.

• 1. A function that finds the smallest number in a group of numbers. 

• 1. A function that finds the largest number in a group of numbers. 

• 1. A cell address that does not change when you copy the formula to another cell.

Mixed references

• 1. The information you put inside a formula to tell it what to do. 

• 1. A function that counts the number of cells that have numbers in them.

• A cell address where one part stays the same and other part changes.

• 1.  A circular chart divided into slices. Each slice represents a part of the whole. 

Operator

• 1. A function that counts the number of cells that have numbers in them.

• A row in a table that contains all the information about one item.

• 1. A way to organize information in a grid using columns and rows. 

• A symbol that tells the computer what math to do with the numbers.

Relative reference

• A cell address that changes when you copy the formula to another cell

• 1. A cell address that does not change when you copy the formula to another cell.

• 1. A feature that changes the appearance of cells based on specific rules or conditions. 

• 1. The line on the side of a chart that goes up and down, showing labels or values. 

SUM

• 1. The rules for how to put words and symbols together in code and spreadsheet formulas. 

• 1. A function that adds up all the numbers in a selected group of cells.

•  A symbol that tells the computer what math to do with the numbers.

• 1.  function that counts the number of cells that have numbers in them.