Trabajar Con Calc
-
Upload
cocacola1945 -
Category
Documents
-
view
220 -
download
0
Transcript of Trabajar Con Calc
-
8/8/2019 Trabajar Con Calc
1/17
Captulo0Captulo022Calc Guide
Trabajar, editar y formatearceldas con Calc
OpenOffice.org
-
8/8/2019 Trabajar Con Calc
2/17
Copyright
Este documento posee Copyright 2005 de sus contribuyentes como se muestra en laseccin titulada Autores . Puedes distribuirlo y modificarlo bajo los trminos de either theGNU General Public License, version 2 or later (http://www.gnu.org/licenses/gpl.html), or LaLicencia Comn Creativa , versi n 2.0 o posterior
(http://creativecommons.org/licenses/by/2.0/).Todas las marcas registradas en sta gua corresponden a sus dueos .
Autores
Peter KupferJean Hollis WeberIain Roberts
Retroalimentacin
Mantenedores : Peter Kupfer,[email protected] cualquier comentario o sugerencia sobre ste documento a :[email protected]
Fecha y software de la versin de la publicacin
Publicado el 17 de Abril del 2005. Basado en OpenOffice.org 2.0.
You can download an editable version of this document fromhttp://oooauthors.org/en/authors/userguide2/published/
http://creativecommons.org/licenses/by/2.0/mailto:[email protected]:[email protected]://oooauthors.org/en/authors/userguide2/published/http://oooauthors.org/en/authors/userguide2/published/http://creativecommons.org/licenses/by/2.0/mailto:[email protected]:[email protected] -
8/8/2019 Trabajar Con Calc
3/17
DRAFT based on pre-release software Contents
Contenidos
Copyright......................................................................................................................................i
Autores.........................................................................................................................................i
Retroalimentacin........................................................................................................................iAcknowledgments........................................................................................................................i
Publication date and software version..........................................................................................i
Ingresando Datos en Calc.................................................................................................................1
Ingresar Datos .............................................................................................................................1
Movindose entre celdas ............................................................................................................1
Usando el mouse ....................................................................................................................1
Usando las flechas del teclado ...............................................................................................1
Usando la tecla Enter..............................................................................................................1
Mltiples lneas de texto ............................................................................................................2
Ajustando el texto ..................................................................................................................2
Salto de Lnea.........................................................................................................................3
Reducir para ajustar a la celda ...............................................................................................4
Editar datos en Calc.........................................................................................................................4
Eliminar texto .............................................................................................................................5
Slo eliminar texto ................................................................................................................5Eliminar texto y formato........................................................................................................5
Escribir sobre el texto ............................................................................................................5
Editar parte de una celda.............................................................................................................5
Atajos de Teclado ..................................................................................................................5
Ratn......................................................................................................................................6
Formatear datos en Calc...................................................................................................................6
Nmeros......................................................................................................................................7
Fuentes........................................................................................................................................8
Efectos de Fuentes.......................................................................................................................9
Subrayado...............................................................................................................................9
Texto tachado........................................................................................................................10
Entering, Editing, and Formating Data i
-
8/8/2019 Trabajar Con Calc
4/17
DRAFT based on pre-release software Contents
Relief....................................................................................................................................10
Alineacin.................................................................................................................................10
Bordes........................................................................................................................................11
Fondo.........................................................................................................................................12
Proteccin de celdas..................................................................................................................13
Entering, Editing, and Formating Data ii
-
8/8/2019 Trabajar Con Calc
5/17
DRAFT based on pre-release software Entrar datos en Calc
Entrar datos en Calc
Entrar datos en OpenOffice.org (OOo) Calc es un proceso simple que se logra con el uso delteclado. La celda que se seleccione de la planilla ser en donde se ingresen los datos .Navegar a travs de la planilla se puede hacer con el teclado o el ratn .
Entrar datos
La mayora de la entrada de datos en Calc se puede hacer usando el teclado . Puedes entrartanto texto como nmeros usando el rea principal de teclado, o bien, con el tecaldonumrico . Como se discuti en el captulo Comenzando con Calc, la planilla Calc sedivide en diferentes celdas . Cada celda puede contener un dato independiente tal como semuestra a continuacin Figura1.
Figura1: Celdas independientes
Movindose entre las celdas
Existen tres formas de navegar entre las celdas en Calc.
Usando el Ratn
Para mover el foco usando el ratn, solo mueve el puntero del ratn a la celda donde quierasque est el foco y luego haz click izquierdo . De esta manera se cambia el foco a la nuevacelda . ste mtodo es muy til cuando dos celdas se encuentran muy separadas entre s .
Usando las flechas del teclado
Las flechas del teclado pueden mover el foco una celda cada vez, es decir una celda haciaarriba, abajo izquierda y derecha.
Usando la tecla RetornoPuedes personalizar la direccin en que la teclaRetorno mueve el foco, esto se hace conHerramientas > Opciones > OpenOffice.org Calc > General. (VerFigura2.)
Entering, Editing, and Formating Data 1
-
8/8/2019 Trabajar Con Calc
6/17
DRAFT based on pre-release software Entrar datos en Calc
Figura2: Personalizar la funcin de la tecla Retorno
En el men de las opciones en OOo 2.0 estn disponibles las configuracionesrelevantes . En OOo 1.1.x puedes cambiar las configuraciones en Writer tal como enCalc. Ahora puedes cambiar la configuracin en Calc.
The four choices for the direction of theEnterkey are shown on the right side ofFigura2. Itcan move down, right, up, or left. Depending on the file being used or on the type of databeing entered, different directions can be useful.
In addition to this, theEnter
key doesnt have to make the focus move at all. It can also beused to switch into and out of editing mode. Use the checkboxes underInput settings inFigura2 to change theEnterkey settings.
Multiple lines of text
Multiple lines of text can be entered into a single cell, in two ways. Each method is useful fordifferent situations.
Wrapping text
Text in cells can be set to wrap at the end of the cell. This option can be set by right-clicking
on a cell and selecting Format Cells. (See Figura3.) Click on the Alignment tab. Near thebottom of the dialog is a checkbox labeled Wrap text automatically. Selecting thischeckbox will cause a line break to appear when the text gets to the end of the cell. Theresults can be seen in Figura4.
Entering, Editing, and Formating Data 2
-
8/8/2019 Trabajar Con Calc
7/17
DRAFT based on pre-release software Entrar datos en Calc
Figura3: Format Cells > Alignment dialog box
Figura4: Automatic text wrap
Line breaks
Multiple lines of text can also be entered by using manual line breaks. Line breaks put extraspaces in between lines of text. When a manual line break is entered, the cell width does notchange.
Entering, Editing, and Formating Data 3
-
8/8/2019 Trabajar Con Calc
8/17
DRAFT based on pre-release software Entrar datos en Calc
To insert a manual line break, press Ctrl+Enterwhile typing. The results can be seeninFigura5.
Figura5: Cell with manual line breaks
Shrinking to fit cell
A new feature in OOo 2.0 is automatically adjust the text size to fit a cell.
Using the alignment options shown in Figura3 the size of the data in a cell can automaticallyadjust to fit in a cell. To do this, check the Shrink to fit cell checkbox. The results of this canbe seen in Figura6.
Figura6: Shrink to fit cells
Editing data in Calc
Editing text is done is almost the same way it is entered.
The first step to editing text is selecting the cell with the text that needs to be edited. To selectthe appropriate cell, use one of the above methods. Once the cell is selected, the text in it canedited.
Entering, Editing, and Formating Data 4
-
8/8/2019 Trabajar Con Calc
9/17
DRAFT based on pre-release software Editing data in Calc
Removing text
Text can be removed in several ways.
Removing text only
The text alone can be removed from a cell without removing any of the formatting of the cell,
by pressing theBackspace key.Removing text and formatting
The text and the formatting can be removed from a cell at the same time. Pressing the Deletekey brings up a Delete Contents dialog. (See Figura7.)
Figura7: Delete Contents dialog
From this dialog, the different aspects of the cell can be deleted. To delete everything in a cell
(contents and format), checkDelete all.Typing over text
To remove text and insert new text, simply type over the old text. The new text will retain theoriginal formatting.
Editing part of a cell
Sometimes it is necessary to edit the contents of cell without removing all of the contents, forinstance if the phrase See Dick run is in a cell and it needs to be modified to See Dick runfast. It is often useful to do this without deleting the old cell contents first.
The process is the similar to the one described above, but you need to place the cursor insidethe cell. You can do this in two ways.
Keyboard shortcut
After selecting the appropriate cell, press theF2 key and the cursor is placed at the end of thecell. Then use the keyboard arrows to move the cursor through the text in the cell.
Entering, Editing, and Formating Data 5
-
8/8/2019 Trabajar Con Calc
10/17
DRAFT based on pre-release software Editing data in Calc
Mouse
Using the mouse, select the appropriate cell to edit. Once the cell is selected, move the mousepointer up to the input line and click into it to place the cursor for editing. You can either editthe text from the input line or, once the cursor is in the input line, click the mouse in theoriginal cell for editing.
Formatting data in Calc
The data in Calc can be formatting in several different ways. It can either be edited as part ofa cell style so that it is automatically applied, or it can be applied manually to the cell. Toaccess the options to format a cell, select the appropriate cell or cells, right-click on it, andselect Format Cells. All of the format options are discussed below.
Note All the settings that will be discussed below can also be set as a part of the styleusing the Stylist.
Entering, Editing, and Formating Data 6
-
8/8/2019 Trabajar Con Calc
11/17
DRAFT based on pre-release software Formatting data in Calc
Numbers
On theNumbers tab (Figura8), the behavior of the data in the cell can be controlled:
Any of the data types in the Category list can be applied to the data.
The number of decimal places and leading zeros can be controlled.
A custom format code can also be entered.
Using the language setting in this menu controls the local settings for the different formatssuch as the date order and the currency marker.
Figura8: Format Cells > Numbers
Entering, Editing, and Formating Data 7
-
8/8/2019 Trabajar Con Calc
12/17
DRAFT based on pre-release software Formatting data in Calc
Font
The font for the cell can be chosen on theFonttab (Figura9). The display on the bottomshows a preview of the cell.
Here you can also set the language of the cell. The language setting is useful, because itallows different languages to exist in the same document and be spell checked correctly.
Figura9: Format Cells > Font
Entering, Editing, and Formating Data 8
-
8/8/2019 Trabajar Con Calc
13/17
DRAFT based on pre-release software Formatting data in Calc
Font effects
TheFont Effects tab (Figura10) offers more font options.
Figura10: Format Cells > Font Effects
Underlining
The underlining options are summarized in Figura11.
Figura11: Calc underline options
The underlining color can also be changed on this tab.
Entering, Editing, and Formating Data 9
-
8/8/2019 Trabajar Con Calc
14/17
DRAFT based on pre-release software Formatting data in Calc
Strikethrough
The strikethrough options are summarized in Figura12.
Figura12: Calc Strikethrough Options
Relief
The relief options are embossed (raised text) and engraved (sunken text).
Alignment
On theAlignmenttab (Figura13) you can set the horizontal and vertical alignment, and rotate
the text.
Figura13: Format Cells > Alignment
The spacing to grid lines settings have been moved in OOo 2.0. They are now underthe Borders menu tab.
Entering, Editing, and Formating Data 10
-
8/8/2019 Trabajar Con Calc
15/17
DRAFT based on pre-release software Formatting data in Calc
Borders
On theBorders tab (Figura14) you can set the borders for the cell, along with a shadow.
Figura14: Format Cells > Borders
Note The cell border properties apply to a cell, and can only be changed if you are editingthat cell. For example, if cell C3 has a top border (which would be equivalentvisually to a bottom border on C2), that border can only be removed by selectingC3. It can not be removed in C2.
Entering, Editing, and Formating Data 11
-
8/8/2019 Trabajar Con Calc
16/17
DRAFT based on pre-release software Formatting data in Calc
Background
On theBackgroundtab (Figura15) you can choose the background color for a cell.
Figura15: Format Cells > Background
Entering, Editing, and Formating Data 12
-
8/8/2019 Trabajar Con Calc
17/17
DRAFT based on pre-release software Formatting data in Calc
Cell Protection
The Cell Protection options can be chosen here (Figura16). These options will be covered ina later chapter.
Figura16Format Cells > Cell Protection
Entering, Editing, and Formating Data 13