Friday, July 19, 2019
Friday, July 5, 2019
Wednesday, July 3, 2019
SST Question Bank of VI Standard
https://drive.google.com/file/d/1jzPGCfK3Zlt49lAVear6PG-7BGh8zRua/view?usp=drivesdk
https://drive.google.com/file/d/1jzPGCfK3Zlt49lAVear6PG-7BGh8ztoRua/view?usp=drivesdk
https://drive.google.com/file/d/1ucJwrZ2hM-rYz-PJ6_j-eLy2kpXzNYmA/view?usp=drivesdk
Tuesday, July 2, 2019
Monday, July 1, 2019
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.
STD_VI
COMPUTER -REVISION
SHEET_1
CH2:
INTRODUCTION TO OPEN OFFICE 4 CALC
|
S.NO
|
TASK
|
SHORTCUT KEY
|
|
1
|
CREATING A NEW WORKBOOK
|
CTRL+N
|
|
2
|
OPENING A SAVED CALC FILE
|
CTRL+O
|
|
3
|
MOVING CELL CONTENT -CUT
|
CTRL+X
|
|
4
|
COPY CELL CONTENT-COPY
|
CTRL +C
|
|
5
|
PASTING
CELL CONTENT
|
CTRL+V
|
|
6
|
APPLYING CELL FORMATS
|
CTRL+1
|
IMPORTANT DEFINITIONS:
1. WORKBOOK-Default
file that opens when you start open office calc.
2. WORKSHEET-Sheets
within each workbook.
3. ROW-Horizontal
arrangement of cells from left to right.
4. COLUMN-Vertical
arrangement of cells from top to bottom
5. CELL-Intersection
of row and column.
6. AUTOSUM-Function
in calc that inserts a formula in the selected cell that adds the numbers in
column above it.
7. WRAP
TEXT-Used to display the content of multiple lines in the same cell
8. MERGE
AND CENTER-Used to join multiple cells to one larger cell and place the
contents in its center.
Note:
Horizontal alignment- left, right, center and justified
Vertical alignment- Top align,
middle align and bottom align
Subscribe to:
Posts (Atom)