Page 251 - open office
P. 251
Ex p erientia l L ea rning
Lab Assignment ‘n Activity Ex p erientia l L ea rning
Complete the following activities and tick on the circle.
Open Calc on your computer screen and create a new spreadsheet file.
Explore the interface of the ‘Calc’ workbook.
Create a new workbook and enter the following data in the worksheet.
With the help of the keyboard & mouse, move across the cells.
Save the Workbook.
Close the application OpenOffice Calc.
RANGE OF CELL
A group of cells is known as a cell range. A range comprises of two or more selected cells and those selected
cells need not be adjacent to each other. Rather than a single cell address, you will refer to a cell range using
the cell addresses of the first and last cell in the cell range separated by a colon. For example, a cell range that
includes cells A1, A2, A3, A4, and A5 would be written as A1:A5. Different types of cell ranges are:
Vertical/Column Range
Column range is the number of selected cells spread across the column. Here, the selected vertical/column
range is A2:A5. The range of cell starts at A2 and ends at A5.
Working with Spreadsheet 251

