Menú Dades

From the menu bar:

Choose Data - Text to Columns.

From the tabbed interface:

Choose Data - Text to Columns.

On the Data menu of the Data tab, choose Text to Columns.

From toolbars:

Text to Columns

From the menu bar:

Trieu Dades ▸ Defineix l'interval.

From the tabbed interface:

Choose Data - Define Range.

On the Data menu of the Data tab, choose Define Range.

From toolbars:

Define Range

From the menu bar:

Trieu Dades ▸ Selecciona l'interval.

From the tabbed interface:

Choose Data - Select Range.

On the Data menu of the Data tab, choose Select Range.

From toolbars:

Select Range

From the menu bar:

TrieuDades ▸ Ordena....

From the tabbed interface:

Choose Data - Sort.

On the Data menu of the Data tab, choose Sort.

From toolbars:

Sort

From the menu bar:

Trieu Dades ▸ Ordre ascendent

From the tabbed interface:

Choose Data - Sort Ascending.

On the Data menu of the Data tab, choose Sort Ascending.

From toolbars:

Sort Ascending

From the menu bar:

TrieuDades ▸ Ordre descendent

From the tabbed interface:

Choose Data - Sort Descending.

On the Data menu of the Data tab, choose Sort Descending.

From toolbars:

Sort Descending

Trieu la pestanya Dades ▸ Ordena ▸ Criteris d'ordenació.

En la barra Estàndard, feu clic

Orde ascendent

Orde descendent

Trieu Dades ▸ Ordena, pestanya Opcions.

From the menu bar:

Trieu Dades ▸ Més filtres.

From the menu bar:

Trieu Dades ▸ Filtre automàtic.

From the tabbed interface:

Choose Data - AutoFilter.

On the Data menu of the Data tab, choose AutoFilter.

From toolbars:

Filtre automàtic

From the keyboard:

+ Shift + L

From the menu bar:

Trieu Dades ▸ Més filtres ▸ Filtre avançat...

From the tabbed interface:

Choose Data - Advanced Filter.

On the Data menu of the Data tab, choose Advanced Filter.

From toolbars:

Advanced Filter

Trieu l'etiqueta Opcions a Dades ▸ Més filtres ▸ Filtre estàndard.

Trieu l'etiqueta Opcions a Dades ▸ Més filtres ▸ Filtre avançat.

From the menu bar:

Trieu Dades ▸ Més filtres ▸ Reinicia el filtre.

From the tabbed interface:

On the Data menu of the Data tab, choose Reset Filter.

From the menu bar:

Choose Data - More Filters - Hide AutoFilter.

From the tabbed interface:

Choose Data - Hide AutoFilter.

On the Data menu of the Data tab, choose Hide AutoFilter.

From toolbars:

Hide AutoFilter

From the menu bar:

Trieu Dades ▸ Subtotals.

From the tabbed interface:

Choose Data - Subtotals.

On the Data menu of the Data tab, choose Subtotals.

From toolbars:

Subtotals

From the menu bar:

Trieu les pestanyes Dades ▸ Subtotals ▸ 1r, 2n, 3r grup.

From the tabbed interface:

On the Data menu of the Data tab, choose Subtotals - 1st, 2nd or 3rd Group tabs.

From the menu bar:

Trieu la pestanya Opcions a Dades ▸ Subtotals.

From the tabbed interface:

On the Data menu of the Data tab, choose Subtotals - Options tab.

From the menu bar:

Trieu Dades ▸ Validesa.

From the tabbed interface:

Choose Data - Validity.

On the Data menu of the Data tab, choose Validity.

From toolbars:

Data Validity

From the menu bar:

Trieu la pestanya Dades ▸ Validesa ▸ Criteris.

From the tabbed interface:

On the Data menu of the Data tab, choose Validity - Criteria tab.

From the menu bar:

Trieu la pestanya Dades ▸ Validesa ▸ Ajuda d'entrada.

From the tabbed interface:

On the Data menu of the Data tab, choose Validity - Input Help tab.

From the menu bar:

Trieu la pestanya Dades ▸ Validesa ▸ Avís d'error.

From the tabbed interface:

On the Data menu of the Data tab, choose Validity - Error Alert tab.

From the menu bar:

Trieu Dades ▸ Operacions múltiples.

From the tabbed interface:

On the Data menu of the Data tab, choose Multiple Operations.

From the menu bar:

Trieu Dades ▸ Consolida.

From the tabbed interface:

Choose Data - Consolidate.

On the Data menu of the Data tab, choose Consolidate.

From toolbars:

Consolidate

From the menu bar:

Trieu Dades ▸ Grup i esquema.

From the menu bar:

Trieu Dades ▸ Grup i esquema ▸ Mostra els detalls.

From the tabbed interface:

Choose Data - Show Details.

On the Data menu of the Data tab, choose Show Details.

From toolbars:

Show Details

From the menu bar:

Trieu Dades ▸ Grup i esquema ▸ Amaga els detalls.

From the tabbed interface:

Choose Data - Hide Details.

On the Data menu of the Data tab, choose Hide Details.

From toolbars:

Hide Details

From the menu bar:

Trieu Dades ▸ Grup i esquema ▸ Agrupa.

From the tabbed interface:

Choose Data - Group.

On the Data menu of the Data tab, choose Group.

From toolbars:

Agrupa

From the keyboard:

F12

From the menu bar:

Trieu Dades ▸ Grup i esquema ▸ Desagrupa.

From the tabbed interface:

Choose Data - Ungroup.

On the Data menu of the Data tab, choose Ungroup.

From toolbars:

Desagrupa

From the keyboard:

+ F12

From the menu bar:

Trieu Dades ▸ Grup i esquema ▸ Esquema automàtic.

From the tabbed interface:

On the Data menu of the Data tab, choose AutoOutline.

From toolbars:

AutoOutline

From the menu bar:

Trieu Dades ▸ Grup i esquema ▸ Suprimeix l'esquema.

From the tabbed interface:

On the Data menu of the Data tab, choose Remove Outline.

Trieu Dades ▸ Grup i esquema ▸ Mostra els detalls (per a algunes taules dinàmiques).

From the menu bar:

Trieu Dades ▸ Taula dinàmica.

From the menu bar:

Trieu Insereix ▸ Taula dinàmica.

Choose Data - Pivot Table - Insert or Edit.

From the tabbed interface:

Choose Insert - Pivot Table.

Choose Data - Pivot Table.

On the Data menu of the Data tab, choose Insert or Edit Pivot Table.

From toolbars:

Pivot Table

Trieu Insereix ▸ Taula dinàmica; en el diàleg Selecciona la font, trieu l'opció Font de dades registrada al LibreOffice.

Trieu Insereix ▸ Taula dinàmica; en el diàleg Selecciona la font, trieu l'opció Selecció actual.

Trieu Insereix ▸ Taula dinàmica; en el diàleg Selecciona la font, trieu l'opció Font de dades registrada al LibreOffice i feu clic a D'acord per a veure el diàleg Seleccioneu la font de dades.

From the menu bar:

Trieu Dades ▸ Taula dinàmica ▸ Actualitza.

From the tabbed interface:

Choose Data - Refresh Pivot Table.

On the Data menu of the Data tab, choose Refresh.

From the context menu:

Choose Refresh.

From toolbars:

Refresh Pivot Table

From the menu bar:

Trieu Dades ▸ Taula dinàmica ▸ Suprimeix.

From the tabbed interface:

Choose Data - Delete Pivot Table.

On the Data menu of the Data tab, choose Delete.

From the context menu:

Choose Delete.

From toolbars:

Delete Pivot Table

From the menu bar:

Trieu Dades ▸ Actualitza l'interval.

From the tabbed interface:

Choose Data - Refresh Range.

On the Data menu of the Data tab, choose Refresh Range.

From toolbars:

Refresh Range

Trieu Dades ▸ Grup i esquema ▸ Agrupa.

From the menu bar:

Choose Data - Calculate - Recalculate hard.

From the keyboard:

+ Shift + F9

From the menu bar:

Choose Data - Calculate - Recalculate.

From the tabbed interface:

Choose Data - Recalculate.

On the Data menu of the Data tab, choose Recalculate.

From toolbars:

Recalculate

From the keyboard:

From the menu bar:

Choose Data - Calculate - Formula to Value.

From the menu bar:

Choose Data - Calculate - AutoCalculate.

From the menu bar:

Choose Data - Calculate

From the menu bar:

Choose Data – Form...

From the tabbed interface:

On the Data menu of the Data tab, choose Form.

From the menu bar:

Choose Data – Streams

From the tabbed interface:

Choose Data - Streams.

On the Data menu of the Data tab, choose Streams.

From toolbars:

Streams

From the menu bar:

Choose Data - XML Source.

From the tabbed interface:

Choose Data - XML Source.

From toolbars:

XML Source

From the menu bar:

Choose Data - Statistics.

From the tabbed interface:

Choose Data - Statistics.

On the Data menu of the Data tab, choose Statistics.

From toolbars:

Statistics

From the menu bar:

Choose Data - Statistics - Sampling

From the tabbed interface:

Choose Data - Statistics - Sampling.

On the Data menu of the Data tab, choose Statistics - Sampling.

From the menu bar:

Choose Data - Statistics - Descriptive Statistics

From the tabbed interface:

Choose Data - Statistics - Descriptive Statistics.

On the Data menu of the Data tab, choose Statistics - Descriptive Statistics.

From the menu bar:

Choose Data - Statistics - Analysis of Variance (ANOVA)

From the tabbed interface:

Choose Data - Statistics - Analysis of Variance (ANOVA).

On the Data menu of the Data tab, choose Statistics - Analysis of Variance (ANOVA).

From the menu bar:

Choose Data - Statistics - Correlation

From the tabbed interface:

Choose Data - Statistics - Correlation.

On the Data menu of the Data tab, choose Statistics - Correlation.

From the menu bar:

Choose Data - Statistics - Covariance

From the tabbed interface:

Choose Data - Statistics - Covariance.

On the Data menu of the Data tab, choose Statistics - Covariance.

From the menu bar:

Choose Data - Statistics - Exponential Smoothing

From the tabbed interface:

Choose Data - Statistics - Exponential Smoothing.

On the Data menu of the Data tab, choose Statistics - Exponential Smoothing.

From the menu bar:

Choose Data - Statistics - Moving Average

From the tabbed interface:

Choose Data - Statistics - Moving Average.

On the Data menu of the Data tab, choose Statistics - Moving Average.

From the menu bar:

Choose Data - Statistics - Regression

From the tabbed interface:

Choose Data - Statistics - Regression.

On the Data menu of the Data tab, choose Statistics - Regression.

From the menu bar:

Choose Data - Statistics - Paired t-test

From the tabbed interface:

Choose Data - Statistics - Paired t-test.

On the Data menu of the Data tab, choose Statistics - Paired t-test.

From the menu bar:

Choose Data - Statistics - F-test

From the tabbed interface:

Choose Data - Statistics - F-test.

On the Data menu of the Data tab, choose Statistics - F-test.

From the menu bar:

Choose Data - Statistics - Z-test

From the tabbed interface:

Choose Data - Statistics - Z-test.

On the Data menu of the Data tab, choose Statistics - Z-test.

From the menu bar:

Choose Data - Statistics - Chi-square Test

From the tabbed interface:

Choose Data - Statistics - Chi-square Test.

On the Data menu of the Data tab, choose Statistics - Chi-square Test.

From the menu bar:

Choose Data - Statistics - Fourier Analysis

From the tabbed interface:

Choose Data - Statistics - Fourier Analysis.

On the Data menu of the Data tab, choose Statistics - Fourier Analysis.