Definitions [2]
Define Rows and Columns of spreadsheet.
The worksheet has number of rows and columns, where each column is labelled as A, B, C, D ….. AA, AB, AC ….. and the rows are numbered from 1, 2, 3….
Define Text Operator.
In Calc, “&” is a text operator which is used to combine two or more text, Joining two different texts is also known as “Text Concatenation” An expression using the text operator has the following syntax:
text reference 1 & text reference2.
Concepts [14]
- Introduction to Spreadsheet
- Working with Openoffice Calc
- Creating a New Worksheet
- Working with Data
- Creating Formulae
- Save, Close and Open the Worksheet
- Cut, Copy and Paste
- Auto Fill Feature
- Inserting Columns, Rows and Cells
- Deleting Columns and Rows
- Formatting Worksheet
- Working with Chart
- Advanced Data Analysis Tools
- Setting the Page Size, Orientation and Margins
