OpenOffice.org OpenOffice - 3.3 Guía básica descargar pdf (Pagina 262)

To insert just one sheet, choose whether before or after then currently selected sheet,

give it a new name if desired, and click OK. The new sheet will be selected and

visible in the line of sheet tabs.

In our example, we need 6 sheets (one for each of the 5 accounts and one as a

summary sheet), so we will add 3 more. We also want to name each of these sheets

for the account they represent: Summary, Checking Account, Savings Account, Credit

Card 1, Credit Card 2, and Car Loan.

We have two choices: insert 3 new sheets and rename all 6 sheets afterwards; or

rename the existing sheets, then insert the 3 new sheets one at a time, renaming

each new sheet during the insert step.

To insert sheets and rename afterwards:

1) In the Insert Sheet dialog, choose the position for the new sheets (in this

example, we use After current sheet).

2) Choose New sheet and 3 as the No. of sheets. (Three sheets are already

provided by default.) Because you are inserting more than one sheet, the

Name box is not available.

3) Click OK to insert the sheets.

4) For the next steps, see “Renaming sheets” on page 260.

To insert sheets and name them at the same time:

1) Rename the existing sheets Summary, Checking Account, and Savings Account,

as described in “Renaming sheets” on page 260.

2) In the Insert Sheet dialog, choose the position for the first new sheet.

3) Choose New sheet and 1 as the No. of sheets. The Name box is now available.

4) In the Name box, type a name for this new sheet, for example Credit Card 1.

5) Click OK to insert the sheet.

6) Repeat steps 1–4 for each new sheet, giving them the names Credit Card 2 and

Car Loan.

Your sheet tab area should now look like this.

Figure 259: Six renamed sheets

Now we will set up the account ledgers. This is just a simple summary that includes

the previous balance plus the amount of the current transaction. For withdrawals, we

enter the current transaction as a negative number so the balance gets smaller. A

basic ledger is shown in Figure 260.

This ledger is set up in the sheet named Checking Account. The total balance is

added up in cell F3. You can see the equation for it in the formula bar. It is the

summary of the opening balance, cell C3, and all of the subsequent transactions.

262 OpenOffice.org 3.3 Calc Guide

1 2 ... 257 258 259 260 261 262 263 264 265 266 267 ... 433 434

Sin comentarios

OpenOffice.org OpenOffice - 3.3 Guía básica Pagina 262