SPREAD SHEET MANUAL NINTH GRADE #1

MANUAL HANDLING BASIC SPREADSHEET

SPREADSHEET

DEFINITION.

Spreadsheets are part of the office tools (programs to generate office documents) they allow the storage, organization, relationship and efficient data presentation alphanumeric (letter values ​​and numbers) and operators (= <> + - * /% ()) or symbols (# @ $?) important information when handling large quantities. For this system are worth grid or mesh that allows easily locate the data.

COMPONENTS.

Spreadsheets are basically composed of a basic and simple system to quickly locate where you are or you want to store a data specifically. The components are:

Cells: These are squares that form the intersection of vertical and horizontal lines of the spreadsheet, cells are the basic component of these. In versions as Ms. Excel 2010 cells total for each worksheet is 17,179,852,800.

Columns: groups of cells are arranged vertically, that is, each one below the other. In versions as Ms. Excel 2010 total columns in each worksheet is 16,383.

Rows: are groups of cells arranged horizontally, ie beside each other. In versions as Ms. Excel 2010 the total rows in each worksheet is 1'048 .575.

Headers: They are placed at the top of the columns (top) and rows (left), they let you know which row or column are. In this case the columns are identified by letters (in the top of the spreadsheet) ranging from A to XFD, and the columns are identified by numbers (in the left side of the spreadsheet) ranging from 1 to 1'048 

EDITORS.

There are several office software for creating and editing spreadsheets among others include:

Excel. Editor spreadsheet package Microsoft Office business. Installation and paid licensed use. The document generated when working with this program and where they are stored spreadsheets called Book.

Office Calc spreadsheets editor of the OpenOffice suite from Sun Micro system. Installation and free for any user.

Docs Spreadsheet. Google Tool free for those user accounts (free) to this corporation.

ENTERING THE PROGRAM.

To enter the program in operating systems like Windows XP you can click the Start button in the lower left corner of the desktop, locate the option program that displays a pop-up menu, click the Microsoft Office option from the menu and click the option Microsoft Excel.

In Windows 7 operating systems such as access to the program is through the Start button in the lower left corner of the desktop, locate the option All Programs, clicking there you will find the option there you will find the Microsoft Office Access Microsoft Excel.

WINDOW ENVIRONMENT

La ventana de trabajo de este editor tiene los componentes típicos de los programas de office como:

Task bar: it contains.

<!--[if !supportLists]-->·         <!--[endif]-->• Toolbar shortcuts: icons on the left side that allow the most common tasks of document editing : save, undo , repeat , print , preview , and an option to customize this bar .

<!--[if !supportLists]-->·         <!--[endif]-->• Name of the Book and the program: in the middle of this bar allow the identification of the document.

<!--[if !supportLists]-->·         <!--[endif]-->• Icons minimize , restore and close : To manipulate the size of the editor window.

<!--[if !supportLists]-->·         <!--[endif]-->Eyelashes : To access the tools in the form of icons organized in groups or grids , the work area ( in this case the spreadsheet) . These are :

<!--[if !supportLists]-->·         <!--[endif]-->• File Tab : It has all the options to save , open or print books and spreadsheets among others.

<!--[if !supportLists]-->·         <!--[endif]-->• Home Tab : Contains all text formatting options and cells among others.

<!--[if !supportLists]-->·         <!--[endif]-->• Insert Tab : it has all the options to insert images, graphs and tables, and more.

<!--[if !supportLists]-->·         <!--[endif]-->• Tab page layout : it has all the options to edit the document properties , among other options.

<!--[if !supportLists]-->·         <!--[endif]-->• Tab formulas : it has all the options to link the information stored in the cells of the spreadsheet , and more.

<!--[if !supportLists]-->·         <!--[endif]-->• Data Tab : it has all the options to sort and classify data , and more.

<!--[if !supportLists]-->·         <!--[endif]-->• Tab review : It has all the options to discuss and protect components spreadsheets , and more.

<!--[if !supportLists]-->·         <!--[endif]-->• Tab view : it has all the options to display the book, spreadsheets and components, among other options.

<!--[if !supportLists]-->·         <!--[endif]-->Formula Bar: allows you to find cells, and write or edit them information, formulas and functions.

<!--[if !supportLists]-->·         <!--[endif]-->Workspace: This is the area where the spreadsheet.

<!--[if !supportLists]-->·         <!--[endif]-->Tabs or labels worksheet: are located on the bottom of the spreadsheet, identify and access allow each (Sheet1, Sheet2, and Sheet3) these names can be changed by double clicking on the tab and typing in it a more appropriate name for the spreadsheet.

<!--[if !supportLists]-->·         <!--[endif]-->Scrollbars view information that is not on view in the spreadsheet due to its large size. There is a sliding bar and one for horizontal scrolling.

<!--[if !supportLists]-->·         <!--[endif]-->Status Bar let’s see if the active cell (shaded) is ready to write on it or just is selected. It also provides quick access to the zoom tool ( zoom in or out to display the spreadsheet or display form : normal , preview and page layout )