95
edits
Changes
From Open Educational Resources
→Functionalities
{| class="wikitable"
{| class="wikitable"
|-
|-
|style="width: 50%;|[[File:LO Calc 1 viewing a spreadsheet.png|450px]] [[File:LO_Calc_1_viewing_a_spreadsheet.png Image]]
|style="width: 50%;|[[File:LO Calc 1 viewing a spreadsheet.png|450px]]
|style="width: 50%;|[[File:LO Calc 3 Processing the data Summing up rainfall information.png|450px]] [[File:LO_Calc_3_Processing_the_data_Summing_up_rainfall_information.png Image]]
|style="width: 50%;|[[File:LO Calc 3 Processing the data Summing up rainfall information.png|450px]]
|-
|-
|style="width: 50%;|Step 1 -When we open the LO Calc application, it will show the window like this. The spreadsheet consists of rows and columns. Each intersection is a cell
|style="width: 50%;|Step 1 -When we open the LO Calc application, it will show the window like this. The spreadsheet consists of rows and columns. Each intersection is a cell
Sheets can be added or deleted from a work book
Sheets can be added or deleted from a work book
|-
|-
|style="width: 50%;|[[File:LO Calc 6 Formatting numbers.png|450px]][[File:LO_Calc_6_Formatting_numbers.png Image]]
|style="width: 50%;|[[File:LO Calc 6 Formatting numbers.png|450px]]
|style="width: 50%;|[[File:LO Calc 2 Freeze rows and columns.png|450px]] [[File:LO_Calc_2_Freeze_rows_and_columns.png Image]]
|style="width: 50%;|[[File:LO Calc 2 Freeze rows and columns.png|450px]]
|-
|-
|style="width: 50%;|Step 3 -Most of the formating options available in LibreOffice Writer are available in Calc also. Making the text bold, italicised, increasing/reducing font size, font color etc are all available. Data can also be formated based on its nature – numeric information can be assigned “,” separators
|style="width: 50%;|Step 3 -Most of the formating options available in LibreOffice Writer are available in Calc also. Making the text bold, italicised, increasing/reducing font size, font color etc are all available. Data can also be formated based on its nature – numeric information can be assigned “,” separators
|style="width: 50%;|Step 4-If you enter data for more than 50 cities, you will not be able to read the column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on View → Freeze Cells → Freeze Rows and Columns
|style="width: 50%;|Step 4-If you enter data for more than 50 cities, you will not be able to read the column headings. To be able to see the column (and row) headings, you should move your cursor to the cell above which (and to the left of which) you want to be able to see your headings and click on View → Freeze Cells → Freeze Rows and Columns
|-
|-
|style="width: 50%;|[[File:LO Calc 3 Processing the data Summing up rainfall information.png|450px]] [[File:LO_Calc_3_Processing_the_data_Summing_up_rainfall_information.png Image]]
|style="width: 50%;|[[File:LO Calc 3 Processing the data Summing up rainfall information.png|450px]]
|style="width: 50%;|[[File:LO_Calc_4_Sorting_data.png|450px]] [[File:LO_Calc_4_Sorting_data.png Image]]
|style="width: 50%;|[[File:LO_Calc_4_Sorting_data.png|450px]]
|-
|-
|style="width: 50%;|Step 5 -You can do almost any kind of computation or processing with a spreadsheet. Here we will calculate the total rainfall for the cities. You can go to the cell below last row with data in Column B, which has the rainfall information and simply type in “=Sum(B2:B15)” assuming the data is in rows 2 through 15 of column B. Any computation or formula must begin with the “=” sign. Or you can simply use the shorthand icon on the menu bar “∑” and hit enter and the application will insert the same formula.
|style="width: 50%;|Step 5 -You can do almost any kind of computation or processing with a spreadsheet. Here we will calculate the total rainfall for the cities. You can go to the cell below last row with data in Column B, which has the rainfall information and simply type in “=Sum(B2:B15)” assuming the data is in rows 2 through 15 of column B. Any computation or formula must begin with the “=” sign. Or you can simply use the shorthand icon on the menu bar “∑” and hit enter and the application will insert the same formula.
|-
|-
|style="width: 50%;|[[File:LO_Calc_7_Inserting_a_chart.png|450px]][[File:LO_Calc_7_Inserting_a_chart.png Image]]
|style="width: 50%;|[[File:LO_Calc_7_Inserting_a_chart.png|450px]]
|style="width: 50%;|[[File:LO_Calc_8_Graph_of_rainfall_with_data.png|450px]][[File:LO_Calc_8_Graph_of_rainfall_with_data.png Image]]
|style="width: 50%;|[[File:LO_Calc_8_Graph_of_rainfall_with_data.png|450px]]
|-
|-
|style="width: 50%;|Step 7 -Select the data (columns A and B) and select Insert → chart option. You will get the chart wizard. You can select Bar chart to get a Bar chart of the rainfall. You should experiment with different graphical formats to learn.
|style="width: 50%;|Step 7 -Select the data (columns A and B) and select Insert → chart option. You will get the chart wizard. You can select Bar chart to get a Bar chart of the rainfall. You should experiment with different graphical formats to learn.
|-
|-
|style="width: 50%;|[[File:LO_Calc_9_Adding_Page_Header_before_printing.png|450px]] [[File:LO_Calc_9_Adding_Page_Header_before_printing.png Image]]
|style="width: 50%;|[[File:LO_Calc_9_Adding_Page_Header_before_printing.png|450px]]
|style="width: 50%;|Step 8-Formating a sheet for printing is not an easy task. To make it simpler, some tips are:
|style="width: 50%;|Step 8-Formating a sheet for printing is not an easy task. To make it simpler, some tips are:
*use the ‘text wrap’ feature to wrap all the text input in a cell so that it won’t overflow to the next cell (
*use the ‘text wrap’ feature to wrap all the text input in a cell so that it won’t overflow to the next cell (
