Advance Spreadsheet Skills

It allows users to organize data

in rows and columns and perform calculations on the data.

• Presentation

• Word Processing

• Spreadsheet

• Publication

The place where information is held in a spreadsheet.

• Row

• Column

• Formula Bar

• Cell

The cell address of the cell usually combine letter and number (ex. A1, B4, C2).

• Formula Bar

• Cell Reference

• Active Cell

• Cellphone

It is an expression which calculates the value of a cell.

• Formula Bar

• Function

• Formula

• Expression

Combining or joining two or more cells

• Combination

• Merge

• Function

• Fusion

It is the box at the top of each column containing a letter.

• Column

• Row

• Column Heading

• Row Heading

Returns the product of x and y.

• x+y

• x-y

• x*y

• x/y

Joins x and y.

• =ABS(x)

• =AVERAGE(x,y)

• =CONCATENATE(x,y)

• =IF(Condition, x, y)

Removes extra spaces in x.

• =REMOVE(x)

• =TRIM(x)

• =CUT(x)

• =DELETE(x)

It is a function that returns the current date and time.

• =NOW()

• =TODAY()

• =DATE()

• =TIME()