technology lesson 1

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.