EMTECH 2

Spreadsheet Software

a software that permits the utilization to prepare data in rows and columns and performs calculations on the data

Excel

a spreadsheet program developed by microsoft that allows you to manipulate, organize, and store data.

excel

It is a powerful program which contains number of rows and columns

cell

The intersection between column and row is called

row

the horizontal line of data entries in a table

columns

the vertical line of data entries in a table

cell

the intersection between row and column, the place where information is held

active cell

the selected cell that appears in the name box

column header

group of cells that runs from the top of the page to the bottom, columns are identified by letters.

row header

group of cells that runs from the left of the page to the right

cell reference

the cell adress of the cell combines by letter and number (A1, B4, C2)

Merge

combining or joining two or more cells

Formula

is an expression which calculates the value of a cell

Formula Bar

it displays the content of a cell, where you can edit, enter functions, or formula

Functions

are predefined formulas and already available in excel

fill handle

a small black box at the bottom right corner of a cell

function

a predefined formula that performs calculations using specific values in a particular order

syntax

a function must be written a specific way which is called the

sum

this function addas all of the values of the cells in the argument

average

It calculates the sum of the cells and then divides that value by the number of cells in the argument

count

this function counts the number of cells with numerical data in the argument.

max

this function determines the highest cell value included in the argument

min

this function determines the lowest cell value included in the argument

counta

counts the number of cells in arrange that are not empty

countblank

counts the number of empty cells

countif

counts the number of cells within a range that meet the given condition