NEW
Font size
WorksheetsAdvance Spreadsheet Skills
Total questions: 10
Worksheet time: 3mins
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()
