Tuesday, February 28, 2012

Computer study lesson No.3

SPREADSHEETS

         Spreadsheets take their name from the oversize sheets or double-page spreads of an accounting record book, ruled into rows and columns. The rectangle at the intersection of a row and column is known as a ‘CELL’.

Features of spreadsheets programs include:
Creation of a workbook file consisting of one or more sheets, whose cells contain labels, numerical data and text data, or formulae.
Identification of cells by row number and column letter(letters)
Sheet headers and footers that hold standart text, graphics and automatic page numbering of each printed page.
Features of spreadsheets programs include:
Margins, paper size and orientation for pages
Importing data from a text file, a databases or a table on a web page
Data entry controls such as combo boxes, list boxes,  spin buttons, scrollbars, check boxes and option buttons to speed up data input and help validate the data
Validation rules for input data to check that an item falls within specified limits and, if not, produce on error message
Calculations performed by formulae
Replication(copy) of the contents(format) of a cell
Automated error checking: the program may warn the user when a formula in one cell is inconsistent(not consistent) with that in adjacent cells
Formatting options for cells and their contents, including number formats such as decimal(.000), currency, data and time, font name, style and size, text alignment and orientation
Creation of graphs or charts from the spreadsheet`s data, often using a chart wizard
Exporting data as a text file or a web page
Features of spreadsheets programs include:

In formula, a reference to another cell can be entered by selecting the cell. All formula(or ‘formulas’) are recalculated each each time any cell is updated. A formula can contain one or one mathematical functions or functions for calculating statistics such as a sum, count, maximun, minimum, average or rank.

=(A3+C9)*100 adds the numerical contents of A3 and C9 and multiplies the result by 100.
=C8&”  “&D8 joins(or ‘concatenates’) the text or number in C8, a single space and the text or number in D8
=sum(C2:C37) adds the numerical contents of the range of cell from C2 to C37, ignoring any non-numerical values in those cells. =C2+…+C37 would find the same total, but take a long time to construct, might contain errors and would return an error message if any cell to contain text.
=if(C6>200, C6*5%, “No discount”)

Tests the logical condition C6>200, which is either TRUE or FALSE depending on the current value of cell C6.

No comments:

Post a Comment