Dear Teachers,
These slides have been prepared based on the SCERT syllabus to support you in teaching Plus One and Plus Two Accountancy and Computerised Accounting.
Please review and verify the content before using it in your classrooms. If you find any errors or have feedback, please let me know.
Mujeeb Rahiman C
HSST Commerce
GHSS Pattikkad
Malappuram Dt.
✉️ mujeebchemmala@gmail.com
9995983075 �
DATA ENTRY, TEXT MANAGEMENT AND CELL FORMATTING
In any computerised business application, the basic requirement is to input data.
Data should be correct, accurate and should be in proper format. This means
that data should be validated, corrected and can be display in proper format.
By default in spreadsheet the numbers are right aligned and texts are left aligned.
Data fill options
The Calc provides for entering data automatically to continue a series of numbers,
number and text combinations, dates, based on a pattern that we require. To fill
quickly , we select cells and drag the fill handle.
(A Fill handle is the small black square in the lower right corner of the selection)
Option 1 Drag the fill handle to fill data into adjacent cells
Fill Handle
Drag Fill
Handle to the
adjacent cells
Option 2 fill the active cell with the contents of an adjacent cell
Import/Copy Data from other sources
This method will transfer data into required cells by copying or importing
an external file to Calc sheet. These data files may be either in text files
or non text files format. These files often have extension .txt, .csv (Comma
Separated Values text file), easily read into Calc.
Data Validation
Data validation is a feature to define restrictions on type of data entered into
a cell. There may be warning messages when users tries to type wrong data in
the cell.
Example:
Enter students details in a table
(column heading as NAME OF STUDENTS, CLASS , SEX) using data validity
DATA FORMATTING
Formatting of spreadsheets makes easier to read and understand the important
information (e.g. conditional formatting, number formatting, text and general
spreadsheet formatting etc.).
Formatting Tools
Format -> Cells
Changing cell colours
Adding text formatting
Conditional Formatting
Using the menu Format >> conditional >> condition, the dialogue allows
you to define conditions per cell, which must be met in order for the selected cells
to have a particular format. To apply conditional formatting, Auto Calculate must
be enabled. Choose Tools → Cell Contents → AutoCalculate
Merging a range of Cells and Split Cells
Merged cells are a single cell that is created by combining two or more selected cells.
The cell reference for a merged cell is the upperleft cell in the original selected range.
Formatting a Table
Format → AutoFormat
Adding Headers and Footers to Excel Spreadsheet
Insert → Headers and Footers
Page Setup
We can customise our output Report by editing the page setup option.
Format → Page
ONE VARIABLE DATA TABLE
The One Variable Data Table allows you to identify a single decision variable in
your model and see how changing the values for that variable affect the values
calculated by one or more formulas in your model.
Name of Sales men
Amount of Sales
SANDEEP
250000
YASIR
300000
SUBAIR
240000
ALEX
340000
SHIBU
180000
They got 10% commission in addition to their salary. Find out sales men's
commission by using ONE VARIABLE TABLE
Example: Blue Star Detergent Company have five Sales men,
their sales in March 2017 are given below
Data → Multiple Operations
TWO VARIABLE DATA TABLE
Two Variable Data Table works similar to the One Variable Data Table. However,
which specify two decision variables and a variety of inputs and only a single formula.
Name of Sales men
Amount of Sales
SANDEEP
250000
YASIR
300000
SUBAIR
240000
ALEX
340000
SHIBU
180000
Example: Blue Star Detergent Company have five Sales men,
their sales in March 2017 are given below
Calculate the sales men's Commission in different rates (10%,11%,12%,13%,14%)
Pivot table
Pivot table is a special type of table that allows easy compression, analysing
and presenting data. It allow us to create a cross tabulation summary.
Example:
Raju sold Home Appliance in a week from his shop, on the basis of this
transaction prepare a pivot table
ITEMS
BRAND
SALES PRICE
COLOUR TV
SAMSUNG
25000
WASHING MACHINE
LG
22000
REFREGATER
WHIRLPOOL
24000
WASHING MACHINE
LG
20000
COLOUR TV
WHIRLPOOL
32000
REFREGATER
SAMSUNG
26000
WASHING MACHINE
SAMSUNG
21000
COLOUR TV
LG
19000
MUJEEB RAHIMAN C
HSST COMMERCE
GHSS PATTIKKAD
MALAPPURAM DT