THECHNOLOGY LESSON1

EXERCISE 8

Print Preview

1.     Click the Microsoft Office button. A menu appears.

2.     Highlight the Print option. The Preview and Print the Document menu appears.

3.     Click Print Preview. The Preview window appears, with your document in the window.

4.     Click One Page to view one page at a time. Click Two Pages to view two pages at a time.

5.     To view your document in normal size, click 100%.

6.     Click the Zoom Button. The Zoom dialog box appears.

7.     Select an option and then click OK. Perform this task for each option and note the results.

Note: As you review your document, if you see changes you would like to make to the layout, use the Margin, Orientation, or Page Size options to make the changes. If you want to make other types of changes to your document, click the Close Print Preview button, to return to your document. Once you are satisfied with your document, you are ready to print.

Print

1.     Click the Print button. The Print dialog box appears.

2.     Click the down arrow next to the Name field and select the printer to which you want to print.

3.     Choose All as the page range.

4.     Click OK. Word prints your document.

Excel Spreadsheet

Microsoft Excel is an electronic spreadsheet. As with a paper spreadsheet, you can use Excel to organize your data into rows and columns and to perform mathematical calculations. The tutorial teaches you how to create an Excel spreadsheet.

Previous Page

Table of Contents

Next Page

Lesson 1: Entering Text and Numbers

The Microsoft Excel Window

Microsoft Excel is an electronic spreadsheet. You can use it to organize your data into rows and columns. You can also use it to perform mathematical calculations quickly.

SPREADSHEET: HOJA DE CALCULO    DATA:DATOS   ROW:FILA   COLUMN:COLUMNA    PERFORM:REPRESENTAR

QUICKLY:RAPIDAMENTE

This tutorial teaches Microsoft Excel basics. Although knowledge of how to navigate in a Windows environment is helpful, this tutorial was created for the computer novice.

This lesson will introduce you to the Excel window. You use the window to interact with Excel. To begin this lesson, start Microsoft Excel 2007. The Microsoft Excel window appears and your screen looks similar to the one shown here.

Note: Your screen will probably not look exactly like the screen shown. In Excel 2007, how a window displays depends on the size of your window, the size of your monitor, and the resolution to which your monitor is set. Resolution determines how much information your computer monitor can display. If you use a low resolution, less information fits on your screen, but the size of your text and images are larger. If you use a high resolution, more information fits on your screen, but the size of the text and images are smaller. Also, settings in Excel 2007, Windows Vista, and Windows XP allow you to change the color and style of your windows.

The Microsoft Office Button

In the upper-left corner of the Excel 2007 window is the Microsoft Office button. When you click the button, a menu appears. You can use the menu to create a new file, open an existing file, save a file, and perform many other tasks.

The Quick Access Toolbar

Next to the Microsoft Office button is the Quick Access toolbar. The Quick Access toolbar gives you with access to commands you frequently use. By default, Save, Undo, and Redo appear on the Quick Access toolbar. You can use Save to save your file, Undo to roll back an action you have taken, and Redo to reapply an action you have rolled back.

The Title Bar

Next to the Quick Access toolbar is the Title bar. On the Title bar, Microsoft Excel displays the name of the workbook you are currently using. At the top of the Excel window, you should see "Microsoft Excel - Book1" or a similar name.

The Ribbon

You use commands to tell Microsoft Excel what to do. In Microsoft Excel 2007, you use the Ribbon to issue commands. The Ribbon is located near the top of the Excel window, below the Quick Access toolbar. At the top of the Ribbon are several tabs; clicking a tab displays several related command groups. Within each group are related command buttons. You click buttons to issue commands or to access menus and dialog boxes. You may also find a dialog box launcher in the bottom-right corner of a group. When you click the dialog box launcher, a dialog box makes additional commands available.

Worksheets

Microsoft Excel consists of worksheets.

 Each worksheet contains columns and rows. The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the rows are numbered 1 to 1,048,576. The number of columns and rows you can have in a worksheet is limited by your computer memory and your system resources.

LETTERED: ASIGNAR UNA LETRA    SO ON: ETCETERA     NUMBERED: ENUMERADA   RESOURCE: RECURSO

1.048.576  (ONE MILLION FORTY EIGHT THOUSAND FIVE HUNDRED SEVENTY SIX)

The combination of a column coordinate and a row coordinate make up a cell address. For example, the cell located in the upper-left corner of the worksheet is cell A1, meaning column A, row 1. Cell E10 is located under column E on row 10. You enter your data into the cells on the worksheet.

The Formula Bar

 

Formula Bar

If the Formula bar is turned on, the cell address of the cell you are in displays in the Name box which is located on the left side of the Formula bar. Cell entries display on the right side of the Formula bar

TURN ON: PRENDER   ADDRESS:DIRECCION   DISPLAY: MOSTRAR     NAME BOX: RECUADRO DE NOMBRE

. If you do not see the Formula bar in your window, perform the following steps:

1.     Choose the View tab.

2.     Click Formula Bar in the Show/Hide group. The Formula bar appears.

Note: The current cell address displays on the left side of the Formula bar.

The Status Bar

The Status bar appears at the very bottom of the Excel window and provides such information as the sum, average, minimum, and maximum value of selected numbers. You can change what displays on the Status bar by right-clicking on the Status bar and selecting the options you want from the Customize Status Bar menu. You click a menu item to select it. You click it again to deselect it. A check mark next to an item means the item is selected.

BOTTOM:PARTE INFERIOR   SUM: SUMA  AVERAGE:PROMEDIO  CHANGE:CAMBIAR  DISPLAY:MOSTRAR

CUSTOMIZE: PERSONALIZAR    ITEM: TEMA

Move Around a Worksheet

By using the arrow keys, you can move around your worksheet. You can use the down arrow key to move downward one cell at a time. You can use the up arrow key to move upward one cell at a time. You can use the Tab key to move across the page to the right, one cell at a time. You can hold down the Shift key and then press the Tab key to move to the left, one cell at a time. You can use the right and left arrow keys to move right or left one cell at a time. The Page Up and Page Down keys move up and down one page at a time. If you hold down the Ctrl key and then press the Home key, you move to the beginning of the worksheet.