COMPUTER REVISION SHEET_2

STD:VI

COMPUTER REVISION

CH 3: ORGANIZING AND ANALYZING DATA USING OPEN OFFICE 4 CALC

SORTING

Highlight the cells to be sorted.

Then select Data > Sort to open the Sort dialog, or click the Sort Ascending or Sort Descending toolbar buttons. 

Using the dialog, you can sort the selected cells using up to three columns, in either ascending (A-Z, 1-9) or descending (Z-A, 9-1) order.

FILTERING

Auto filter lets you pick one value for a column,

1 Choose Data > AutoFilter.

2 Dropdown arrows will appear at the top of each column. This means we can restrict what you see in the spreadsheet to rows with a particular value.

 3 Click and hold down the arrow and select a value.

4 The spreadsheet will filter out everyone except the rows with that value.

5 To go back to showing all, click and hold down on the column’s arrow (blue now) and choose all.

 6 When you’re done, choose Data > Filter > AutoFilter again to turn off the filter.

Creating a chart

To create a chart,   first highlight (select) the data to be included in the chart. The selection does not need to be in a single block, you can also choose individual cells or groups of cells (columns or rows). for more about selecting cells and ranges of cells.

Next, open the Chart Wizard

·         Select Insert > Chart from the menu bar.

·         Or, click the Chart icon on the main toolbar.

Types of chart-

column chart,Pie chart,Line chart and Bar chart.