Analyzing Information Using ICT

A spreadsheet made of rows and columns.

• Cell

• Cell Address

It displays the name of the cell.

• Formula Box

• Name Box

It is composed of the letter and number that identifies the location or address of the cell.

• Cell

• Cell Reference/Cell Address

It displays the maximum or the largest value in a range of cells.

• Min

• Max

It displays the total number of numerical values that are in range of cells.

• Max

• Count

It displays the minimum or the smallest value in a range of cells.

• Min

• Max

It is a function that makes Excel search for a certain value in a column in order to return a value from a different column in the same row.

• VLOOKUP

• HLOOKUP

A feature of excel that makes manipulation of data much faster and easier .

• Autosum

• Autofill

The power of spreadsheet/excel is utilized by formulas, without it, excel is just a grid with numbers entered in it.

• True

• False

A feature of Microsoft Excel which can be used

to enter or copy formula cells or charts.

• Title Bar

• Formula Bar