Archive for June 2015
Create Spreadsheet Charts
Create different types of charts from spreadsheet data: column chart, bar chart, line chart, pie chart. In Calc, we can represent our data with the help of different graphical representations like column chart, bar chart, line chart, or pie chart. This makes the data more presentable and also easier to comprehend. To create the different…
Read MoreSpreadsheet Formats – Alignment and Border Effects
Apply text wrapping to contents within a cell, cell range. To apply text wrapping to contents within a cell or a cell range, first select the cell or the cell range and then right click anywhere on the entire range. From the resulting menu, click on ‘Format Cells’, this will open the ‘Format Cells’ dialog…
Read MoreChange Spreadsheet Cell Content Appearance
Change cell content appearance: font sizes, font types. In the same ‘Format Cells’ dialog box, under the ‘Font’ tab, we have the ‘Font’ and ‘Size’ drop-down lists. The ‘Font’ drop-down list gives the different font types and ‘Size’ gives the different font sizes. These values can be chosen accordingly. After selecting the required values, click…
Read MoreFormatting
Numbers/Dates Format cells to display numbers to a specific number of decimal places, to display numbers with, without a separator to indicate thousands. It is possible in Calc to format cells to display any input in some particular styles. To format a cell to display numbers to a specific number of decimal places, right-click on…
Read MoreThe IF Function
Use the logical function if (yielding one of two specific values) with comparison operator: =, >, <. To use the logical function ‘IF’, we need to follow the same steps as before to reach the ‘Function Wizard’. In the ‘Function Wizard’, select ‘Logical’ in the ‘Category’ and from ‘Function’, select ‘IF’. Click on ‘Next’ and…
Read MoreFunctions
Use sum, average, minimum, maximum, count, counta, round functions. Functions help us in analyzing and referencing data. To use functions in a worksheet, first of all we need some data on which the functions are to be applied. Any function needs some arguments to be passed to it as parameters, upon which the calculations or…
Read MoreFormulas and Functions
Arithmetic Formulas Recognize good practice in formula creation: refer to cell references rather than type numbers into formulas. We have been entering either text or numbers into the cells till now, but in case the data in a cell is dependent on the value of data of other cells, we use formulas. Formulas use numbers…
Read MoreWorksheets
Switch between worksheets. To switch between different open worksheets, we just need to click on the appropriate sheet name from the bottom of the Calc window, as has been shown in the below given illustration. When we click on a particular sheet name, that sheet will get opened. This is how we can switch between…
Read MoreManaging Worksheets
Rows and Columns Select a row, range of adjacent rows, and range of non-adjacent rows. To select a row, simply click on the row header for that row. It should just be a single click and not a double click. This will select the entire row. To select a range of adjacent rows, click on…
Read MoreCopy, Move, Delete Spreadsheet Cells
Copy the content of a cell, cell range within a worksheet, between worksheets, between open spreadsheets. To copy the content of a cell or a range of cells within a worksheet, between worksheets or even to another open spreadsheet, simply select the cell or the range of cells. Then right click anywhere on the selected…
Read More