LibreOffice Calc Data Menu (CCC)

                   LibreOffice Calc Menu

Use the information menu commands to edit the information within the current sheet. you'll be able to outline ranges, kind and filter the information, calculate results, define knowledge, and make a pivot table. 

Sort 

Sorts the chosen rows per the conditions that you simply specify. LibreOffice mechanically acknowledges and selects information ranges. 

Sort Ascending 

Text fields square measure sorted alphabetically, numerical fields square measure sorted by variety. 

Sort decending

Text fields square measure sorted alphabetically, variety fields square measure sorted by variety. 

AutoFilter 

Automatically filters the chosen cell vary, and creates one-row list boxes wherever you'll be able to opt for the things that you simply wish to show. 

More Filters 

Shows commands to filter your knowledge. 

Define range 

Defines a information vary supported the chosen cells in your sheet. 

Select Range

Selects a information vary that you simply outlined underneath knowledge - outline vary. 

Refresh Range 

Updates a knowledge vary that was inserted from AN external information. the information in  the sheet is updated to match the information within the external information. 

Pivot Table 

A pivot table provides a outline of huge amounts of knowledge. you'll be able to then arrange the pivot table to look at completely different summaries of the information.

Calculate 

Commands to calculate formula cells. 

Validity 

Defines what knowledge is valid for a specific cell or cell vary. 

Subtotals 

Calculates subtotals for the columns that you simply choose. LibreOffice uses the add perform to mechanically calculate the subtotal and grand total values in an exceedingly labeled  vary. you'll be able to additionally use different functions to perform the calculation.  LibreOffice mechanically acknowledges an outlined information space after you place the pointer in it. 

Form 

Data Entry type may be a tool to create table knowledge entry straightforward in spreadsheets. With the information Entry type, you'll be able to enter, edit and delete records (or rows) of knowledge and  avoid horizontal scrolling once the table has several columns or once some  columns square measure terribly wide. 

Streams 

Live knowledge stream for spreadsheets 

XML Source 

Import XML knowledge in an exceedingly computer programme. 

Data supplier for Spreadsheets 

Data supplier for Spreadsheets 

Multiple Operations 

Applies identical formula to completely different cells, however with completely different parameter values. 

Text to Columns 

Opens the Text to Columns dialog, wherever you enter settings to expand the  contents of chosen cells to multiple cells.

Consolidate 

Combines knowledge from one or a lot of freelance cell varys and calculates a replacement  range victimization the perform that you simply specify. 

Group and Outline

You will produce a top level view of your knowledge and cluster rows and columns along therefore that you simply can collapse and expand the teams with one click. 

Statistics 

Use {the knowledge|the info|the information} statistics in Calc to perform advanced data analysis

super mega mind computer center

smmcc gonda