+2 Computerised Accounting Questions and Answers - Chapter 2

A Spreadsheet is a computer application software which helps the user to arrange and organise huge volume of data in tabular form.

Gnumeric, Calligra Sheets, Lotus 1-2-3, LibreOffice Calc, MS Office Excel etc.. are examples of Spreadsheet Softwares.

Libre Office Calc

LibreOffice Calc is a spreadsheet application. It is used to calculate, analyse and manage data. A calc file is also known as Workbook . A workbook is a collection of a number of worksheets.

Features of Libre Office Calc

1. Easy calculations
2. What-if calculations
3. Serves as a database
4. Arranging data
5. Dynamic Charts

Components of Libre Office Calc Spreadsheet

1. Rows and Columns : Rows are numbered numerically from top to bottom. Columns are referred by alpha character from left to right.
2. Cell : The intersection of a Row and a Column is called a Cell.
3. Range : A cell range is a collection of selected cells.

SPREADSHEET OPERATIONS

1. Starting a new work book
   Applications --> Office --> LibreOffice Calc
2. To open a new work book while working in a spreadsheet
   File --> New --> Spreadsheet
3. To open an existing workbook while working in a spreadsheet
   File --> Open (Select file from location and then open)
4. To save a worksheet
   File --> Save
5. To close a worksheet
   File --> Close
6. To add a new worksheet in the workbook
   Click on the + sign near to Sheet tab
7. To delete a worksheet
   Select the sheet to be deleted. Then select Delete Sheet option available under Sheet menu.
8. To rename a worksheet
   Select the sheet to be renamed. Then select Rename Sheet under Sheet menu.

Cell references

Cell address used in a formula is called Cell reference. A Cell reference identifies the location of a cell or group of cells in the spreadsheet.

A cell reference may be relative, absolute and mixed.

• Relative Cell Reference
  It means when the formula is copied, it changes to reflect the new location.
• Absolute Cell Reference
  Absolute cell reference is used to keep a cell reference constant. It consists of column letter and row number surrounded by dollar sign ($).
• Mixed Cell Reference
  Mixed cell reference is a combination of Relative and Absolute cell references.

Functions in Spreadsheet

1. DATE AND TIME FUNCTIONS
2. STATISTICAL FUNCTIONS
3. LOGICAL FUNCTIONS
4. MATHEMATICAL FUNCTIONS

1. Date and Time Functions

1. Today - This function returns the current computer system date in the cell.
2. Now – NOW function returns current computer system time also with the date.
3. DAY - This function returns the day of a date represented by a number.
4. Month – This function returns the month of a given date.
5. Year – This function returns the year from the date.
6. Date – This function returns a date, when the year, month and day parameters are given as integer separated by commas.
7. Datevalue – This function converts a date and returns its corresponding date value number.

2. Statistical Functions

1. COUNT: This function will count cells that contains numbers, dates and time.
2. COUNTA : This function will counts the number of cells that contains any type of data. That is it counts the cells that are not empty in a range.
3. COUNTBLANK : This function counts the number of cells which are empty in a range
4. COUNTIF : This function is used to count the number of cells that meet a criteria.

3. Logical Functions

1. IF : This function returns one value if the condition is true, and another value if the condition is false.
2. AND : It checks more than one condition at the same time and returns TRUE if all conditions are satisfied. Otherwise it returns FALSE.
3. OR : OR function is used to compare two values.

4. Mathematical Functions

1. SUM : This function adds together a supplied set of number or numbers given in a range.
2. SUMIF : This function adds all numbers in a range of cells, only if it meets given criteria.
3. ROUND : Round function rounds a number to a specified number of digits.