compo1 calc presentation lesson
TRANSCRIPT
-
8/11/2019 COMPO1 CALC Presentation Lesson
1/21
Introducing LibreOffice Calc
Calc is the spreadsheet component of LibreOffice.
-
8/11/2019 COMPO1 CALC Presentation Lesson
2/21
Introducing LibreOffice Calc
What is LibreOffice Calc Other Features
Spreadsheet, Sheets and CellsParts of the main Calc window
Title barMenu bar
ToolbarFormatting Toolbar
Formula BarIndividual cells
Sheet tabsStatus Bar
-
8/11/2019 COMPO1 CALC Presentation Lesson
3/21
What is Calc?
Calc is the spreadsheet component ofLibreOffice. You can enter data (usuallynumerical) in a spreadsheet and then
manipulate this data to produce certain results. Alternatively, you can enter data and then useCalc in a What if... manner by changing someof the data and observing the results withouthaving to retype the entire spreadsheet orsheet.
-
8/11/2019 COMPO1 CALC Presentation Lesson
4/21
Other Features
Functions, which can be used to create formulasto perform complex calculations on dataDatabase functions, to arrange, store, and filter
dataDynamic charts; a wide range of 2D and 3D chartsMacros, for recording and executing repetitivetasks; scripting languages supported includeLibreOffice Basic, Python, BeanShell, andJavaScript
-
8/11/2019 COMPO1 CALC Presentation Lesson
5/21
Other Features
Ability to open, edit, and save Microsoft ExcelspreadsheetsImport and export of spreadsheets in multiple
formats, including HTML, CSV, PDF, andPostScript
-
8/11/2019 COMPO1 CALC Presentation Lesson
6/21
Spreadsheets, sheets, and cells
Calc works with elements called spreadsheets .Spreadsheets consist of a number of individual sheets ,each sheet containing cells arranged in rows and columns.
A particular cell is identified by its row number and columnletter.Cells hold the individual elements text, numbers,formulas, and so on that make up the data to display andmanipulate.
Each spreadsheet can have many sheets, and each sheetcan have many individual cells. In Calc 3.3, each sheet canhave a maximum of 1,048,576 (65,536 rows in Calc 3.2and earlier) and a maximum of 1024 columns
-
8/11/2019 COMPO1 CALC Presentation Lesson
7/21
Parts of the main Calc window
-
8/11/2019 COMPO1 CALC Presentation Lesson
8/21
Title bar
The Title bar, located at the top, shows thename of the current spreadsheet. Whenthe spreadsheet is newly created, its nameis Untitled X , where X is a number. Whenyou save a spreadsheet for the first time,you are prompted to enter a name of your
choice.
-
8/11/2019 COMPO1 CALC Presentation Lesson
9/21
Menu bar
Under the Title bar is the Menu bar. When you choose one ofthe menus, a submenu appears with other options.File contains commands that apply to the entire documentsuch as Open , Save , Wizards , Export as PDF , and Digital
Signatures .Edit contains commands for editing the document such asUndo , Changes , Compare Document , and Find andReplace .View contains commands for modifying how the Calc userinterface looks such as Toolbars , Full Screen , and Zoom .Insert contains commands for inserting elements such ascells , rows , columns , sheets , and pictures into aspreadsheet.
-
8/11/2019 COMPO1 CALC Presentation Lesson
10/21
Menu bar
Format contains commands for modifying the layout ofa spreadsheet such as Styles and Formatting ,Paragraph , and Merge Cells .Tools contains functions such as Spelling , ShareDocument , Cell Contents , Gallery , and Macros .Data contains commands for manipulating data in yourspreadsheet such as Define Range , Sort , Filter , andDataPilot .Window contains commands for the display windowsuch as New Window , Split , and Freeze .Help contains links to the Help file bundled with thesoftware, What's This? , Support , Registration , andCheck for Updates .
-
8/11/2019 COMPO1 CALC Presentation Lesson
11/21
-
8/11/2019 COMPO1 CALC Presentation Lesson
12/21
Formatting toolbar
In the Formatting toolbar, the three boxes on the left arethe Apply Style , Font Name , and Font Size lists (seeFigure 7). They show the current settings for theselected cell or area. (The Apply Style list may not bevisible by default.) Click the down-arrow to the right ofeach box to open the list.
-
8/11/2019 COMPO1 CALC Presentation Lesson
13/21
Formula Bar
On the left hand side of the Formula Bar is asmall text box, called the Name Box , with a letterand number combination in it, such as D7 . This
combination, called the cell reference, is thecolumn letter and row number of the selectedcell.
-
8/11/2019 COMPO1 CALC Presentation Lesson
14/21
Individual cells
The main section of the screen displays the cellsin the form of a grid, with each cell being at theintersection of a column and a row.
At the top of the columns and at the left end of therows are a series of gray boxes containing lettersand numbers. These are the column and rowheaders. The columns start at A and go on to theright, and the rows start at 1 and go down.These column and row headers form the cellreferences that appear in the Name Box on theFormula Bar
-
8/11/2019 COMPO1 CALC Presentation Lesson
15/21
Sheet tabs
At the bottom of the grid of cells are thesheet tabs. These tabs enable access toeach individual sheet, with the visible(active) sheet having a white tab. Clickingon another sheet tab displays that sheet,and its tab turns white. You can also select
multiple sheet tabs at once by holdingdown the Control key while you click thenames.
-
8/11/2019 COMPO1 CALC Presentation Lesson
16/21
Status bar
The Calc status bar provides information aboutthe spreadsheet and convenient ways to quicklychange some of its features.
-
8/11/2019 COMPO1 CALC Presentation Lesson
17/21
Status bar
Sheet sequence number () Shows the sequence number of the currentsheet and the total number of sheets in the
spreadsheet. The sequence number may notcorrespond with the name on the sheet tab.Page style () Shows the page style of the current sheet. Toedit the page style, double-click on this field.The Page Style dialog opens.
-
8/11/2019 COMPO1 CALC Presentation Lesson
18/21
Status bar
Insert mode ()Click to toggle between INSRT ( Insert ) andOVER ( Overwrite ) modes when typing. This
field is blank when the spreadsheet is not in atyping mode (for example, when selecting cells).Selection mode () Click to toggle between STD ( Standard ), EXT(Extend ), and ADD ( Add ) selection. EXT is analternative to Shift+click when selecting cells.
-
8/11/2019 COMPO1 CALC Presentation Lesson
19/21
Status bar
Unsaved changes () An icon appears here if changes to thespreadsheet have not been saved.
Digital signature () If the document has not been digitally signed,double-clicking in this area opens the DigitalSignatures dialog, where you can sign thedocument. See Chapter 6, Printing, Exporting,and E-mailing, for more about digital signatures.
-
8/11/2019 COMPO1 CALC Presentation Lesson
20/21
Status bar
Cell or object information ()Displays information about the selected items. Whena group of cells is selected, the sum of the contentsis displayed by default; you can right-click on thisfield and select other functions, such as the averagevalue, maximum value, minimum value, or count(number of items selected).When the cursor is on an object such as a picture or
chart, the information shown includes the size of theobject and its location.
-
8/11/2019 COMPO1 CALC Presentation Lesson
21/21
Status bar
Zoom ()To change the view magnification, drag the Zoomslider or click on the + and signs. You can alsoright-click on the zoom level percentage to select amagnification value or double-click to open the Zoom& View Layout dialog.