Introduction to LibreOffice Calc
Spreadsheet consist of a number of individual sheets, each sheet containing cells arranged in rows and columns. Calc is the one such spreadsheet that is a component of LibreOffice. To open the spreadsheet, double click on the Calc icon on the desktop. If the icon is not found in the desktop, search for LibreOffice Calc and double click on the icon.
On clicking the icon, a spreadsheet opens up. The interface of the spreadsheet is shown below marked with the main components.
In the spreadsheet , cells are arranged in rows and columns. These cells are in the form of a grid, with each cell being at the intersection of a column and a row. A particular cell is identified by its row headers (number) and column headers (alphabet). Active cell reference give the name of the cell combing the row and column headers for e.g. Column (A) and Row (1) will make cell (A1).
Title bar
The Title bar, located at the top, shows the name of the current spreadsheet. When the spreadsheet is newly created, its name is Untitled X , where X is a number. When you save a spreadsheet for the first time, you are prompted to enter a name of your choice.
Menu bar
Under the title bar of spreadsheet there exist a menu bar, when we click on a menu bar a submenu appears which allows us to choose different options
Following are the functions of different options given in the menu bar
File – contains commands that apply to the entire document; for example Open, Save, Wizards, Export as PDF, Print, Digital Signatures and so on.
Edit – contains commands for editing the document; for example Undo, Copy, Changes, Fill, Plug-in and so on.
View – contains commands for modifying how the Calc user interface looks; for example Toolbars, Column & Row Headers, Full Screen, Zoom and so on.
Insert – contains commands for inserting elements into a spreadsheet; for example Cells, Rows, Columns, Sheets, Picture and so on.
Format – contains commands for modifying the layout of a spreadsheet; for example Cells, Page, Styles and Formatting, Alignment and so on.
Tools – contains various functions to help you check and customize your spreadsheet, for example Spelling, Share Document, Gallery, Macros and so on.
Data – contains commands for manipulating data in your spreadsheet; for example Define Range, Sort, Consolidate and so on.
Window – contains commands for the display window; for example New Window, Split and so on.
Help – contains links to the help system included with the software and other miscellaneous functions; for example Help, License Information, Check for Updates and so on.
Toolbars
The default setting when Calc opens is for the Standard and Formatting toolbars placed at the top of the workspace.
Standard toolbar
Formatting toolbar
Calc toolbars can be either fixed in place, or floating allowing you to move a toolbar into a more convenient position on your workspace. The default set of icons (sometimes called buttons) on toolbars provide a wide range of common commands and functions. You can also remove or add icons to toolbars. Placing the mouse cursor over any of the icons displays a small box called a tooltip. It gives a brief explanation of the icon function.
Formula Bar
The Formula Bar is located at the top of the sheet in your Calc workspace. The Formula Bar is permanently docked in this position and cannot be used as a floating toolbar.
Sheet Tabs
You can have more than one sheet in the spreadsheet and each sheet can have many individual cells. At the bottom of the grid of cells in a spreadsheet are sheet tabs indicating how many sheets there are in your spreadsheet.
Note:
If any part of the Calc window is not shown, you can display it using the View menu. For example, View > Status Bar on the main menu bar will show or hide the Status Bar. It is not always necessary to display all the parts, as shown; you can show or hide any of them as desired.
Spreadsheet consist of a number of individual sheets, each sheet containing cells arranged in rows and columns. Calc is the one such spreadsheet that is a component of LibreOffice. To open the spreadsheet, double click on the Calc icon on the desktop. If the icon is not found in the desktop, search for LibreOffice Calc and double click on the icon.
On clicking the icon, a spreadsheet opens up. The interface of the spreadsheet is shown below marked with the main components.
In the spreadsheet , cells are arranged in rows and columns. These cells are in the form of a grid, with each cell being at the intersection of a column and a row. A particular cell is identified by its row headers (number) and column headers (alphabet). Active cell reference give the name of the cell combing the row and column headers for e.g. Column (A) and Row (1) will make cell (A1).
Title bar
The Title bar, located at the top, shows the name of the current spreadsheet. When the spreadsheet is newly created, its name is Untitled X , where X is a number. When you save a spreadsheet for the first time, you are prompted to enter a name of your choice.
Menu bar
Under the title bar of spreadsheet there exist a menu bar, when we click on a menu bar a submenu appears which allows us to choose different options
Following are the functions of different options given in the menu bar
File – contains commands that apply to the entire document; for example Open, Save, Wizards, Export as PDF, Print, Digital Signatures and so on.
Edit – contains commands for editing the document; for example Undo, Copy, Changes, Fill, Plug-in and so on.
View – contains commands for modifying how the Calc user interface looks; for example Toolbars, Column & Row Headers, Full Screen, Zoom and so on.
Insert – contains commands for inserting elements into a spreadsheet; for example Cells, Rows, Columns, Sheets, Picture and so on.
Format – contains commands for modifying the layout of a spreadsheet; for example Cells, Page, Styles and Formatting, Alignment and so on.
Tools – contains various functions to help you check and customize your spreadsheet, for example Spelling, Share Document, Gallery, Macros and so on.
Data – contains commands for manipulating data in your spreadsheet; for example Define Range, Sort, Consolidate and so on.
Window – contains commands for the display window; for example New Window, Split and so on.
Help – contains links to the help system included with the software and other miscellaneous functions; for example Help, License Information, Check for Updates and so on.
Toolbars
The default setting when Calc opens is for the Standard and Formatting toolbars placed at the top of the workspace.
Standard toolbar
Formatting toolbar
Calc toolbars can be either fixed in place, or floating allowing you to move a toolbar into a more convenient position on your workspace. The default set of icons (sometimes called buttons) on toolbars provide a wide range of common commands and functions. You can also remove or add icons to toolbars. Placing the mouse cursor over any of the icons displays a small box called a tooltip. It gives a brief explanation of the icon function.
Formula Bar
The Formula Bar is located at the top of the sheet in your Calc workspace. The Formula Bar is permanently docked in this position and cannot be used as a floating toolbar.
Sheet Tabs
You can have more than one sheet in the spreadsheet and each sheet can have many individual cells. At the bottom of the grid of cells in a spreadsheet are sheet tabs indicating how many sheets there are in your spreadsheet.
Note:
If any part of the Calc window is not shown, you can display it using the View menu. For example, View > Status Bar on the main menu bar will show or hide the Status Bar. It is not always necessary to display all the parts, as shown; you can show or hide any of them as desired.
No comments:
Post a Comment