Introduction of Libreoffice Calc Spreadsheet

Introduction of Libreoffice Calc Spreadsheet

Calc is the spreadsheet program of Libreoffice. It is similar to programs Such as Microsoft Excel. It is an ideal alternative to Microsoft Excel. It allows you to effectively analyze and manage your data. Calc is also a good application to use to create spreadsheets for inventories, timesheets, grade books etc. Like Excel you can enter data in Calc spreadsheet and also manipulate (add, subtract, multiply, divide, average etc.) it to produce certain results.

Element of Spread Sheet:- 

Spreadsheet-

A Spreadsheet is the place where the user works and performs arithmetical and functional calculations. By default it is named as sheet1. You can rename the sheet.

Row-

A Row is the horizontal sequence of the spreadsheet. A Row is named as the numbers 1, 2, 3 etc. in Calc, Total number of row is 10, 48,576.

Column-

A Column is the vertical sequence of the spreadsheet. It is named and A, B, C, etc. In Calc Application in Calc, Total number of column is 1024 (AMJ) (From A to AMJ). The last cell name is AMJ1048576.

Cell-

A Cell is the intersection of Row and column. For example, Cell A1 is the intersection of column  A and Row 1. Cell in which mouse pointer is available that cell is known as active cell; cells may contain text, numbers and formulas. LibreOffice Calc has a character limit of 32,767 characters in each cell.

Cell Range-

A range is identified by its first and last cell address, separated by a colon. For example: If we want to add cell A1 to cell A5 then we write formula =Sum (A1: A5)  

Functions-

A Function is a predefined formula that performs calculations using specific values in a particular order, Calc includes many common functions that can be used to quickly find the sum, average, count, maximum value and minimum value for a range of cells.

Formulas-

In Calc, any formula is always starts by using equal sign. A formula is an expression that operates on value in a range of cell or a cell. For example, =A1+A2+A3, which finds the sum of the range of value from cell A1 to cell A3. It performs some operations like mathematical calculations and Logical operations and so on.

Formula Bar-

This bar appears at the rights side of the Name box. It displays formula as well as value entered into the active cell. It is also used to edit formulas and content in it.

Name box-

This box appears at the left of the formula bar and displays the address of active cell.

Active Spreadsheet-

The spreadsheet on which we are presently working is known as active spreadsheet.

Title Bar-

This bar appears at the top left corner of the Libreoffice Calc and Displays the name of the application file by default name Untitled 1 – LibreOffice Calc.

Menu Bar-

This bar appears below the Title bar. It is the collection of commands of menus. There are following menus appearing in the Libreoffice Calc.

Status Bar-

This bar appears at the bottom of the Libreoffice Calc and displays Information about the current spreadsheet. 

New Sheet-

To Add New Spreadsheet click on + button indicated left side of Sheet1.

Creation of spreadsheets (Ctrl + N)-

A New spreadsheet Document file containing a grid of cells will appear on your screen in which we can enter data to perform some calculation. LibreOffice Calc, you can create a New Spreadsheet file to enter a data by using following ways.

·         Go to Standard toolbar --> Select New icon drop down arrow-->select spreadsheet or

·         Go to the File Menu>New>Spreadsheet.

·         You can press Ctrl + N to open a new Calc Spreadsheet in a New window.

·         You can also create templates (Ctrl + Shift + N) from the menu bar and toolbar.

Navigation in Calc Spreadsheet -

You can navigate in Calc spreadsheet by using following method.

Methods	Description
Mouse Pointer	Use The mouse pointer to select a cell.
Scroll bars	Use the horizontal and vertical scroll bars to move around the spreadsheet to view column and rows not currently visible. Click the mouse pointer once the desired cell in visible.
Arrows keys	Use the left, right, up, and down arrows to move accordingly among cells.
Enter	Press the enter key to move one cell down at a time.
Shift + Enter	Press the Shift + Enter key to move one cell upward at a time.
Tab	Press the Tab key to move one cell to the right.
Shift + Tab	Press the Shift + Tab key to move one cell to the left.
Ctrl + Home	Moves the curser to the first cell (A1).
Ctrl + End	Moves the curser to the Last cell on the sheet that contains data.
Shift + Ctrl + F5	Moves the curser to the Name box.