![]() The Page Up and Page Down keys move up and down one pageĪt a time. You can use the right and left arrow keys to move right or left oneĬell at a time. You can hold down the Shift key and then press the Tab key to move to You can use the Tab key to move across the page to the right, one cellĪt a time. You can use the up arrow key to move upward one cell at a time. You can use the down arrow key to move downward one cell at a time. Move Around a Worksheetīy using the arrow keys, you can move around your worksheet. A check mark next to an item means the item is selected. 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. 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. Note: The current cell address displays on the left side of the Click Formula Bar in the Show/Hide group. ![]() If you do not see the Formula bar in your window, perform the following steps: If the Formula bar is turned on, the cell address of the cell you are in displays in the Nameīox which is located on the left side of the Formula bar. You enter your data into the cells on the worksheet. Of the worksheet is cell A1, meaning column A, row 1. ![]() For example, the cell located in the upper-left corner The combination of a column coordinate and a row coordinate make The number of columns and rows you can have in a worksheet is limited by your computer memory and your system resources. The columns are lettered A to Z and then continuing with AA, AB, AC and so on the rows are numbered 1 toġ,048,576. When you click the dialog box launcher, a dialog box makes additional commands available. You may also find a dialog box launcher in the bottom-right corner of a group. You click buttons to issue commands or to access menus and dialog boxes. Within each group are related command buttons. At the top of the Ribbon are several tabs clicking a tab displays several related command groups. The Ribbon is located near the top of the Excel window, below the Quick Access toolbar. In Microsoft Excel 2007, you use the Ribbon to issue commands. You use commands to tell Microsoft Excel what to do. At the top of the Excel window, you should see "MicrosoftĮxcel - Book1" or a similar name. On the Title bar, Microsoft Excel displays the name of the workbook Next to the Quick Access toolbar is the Title bar. 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. By default, Save, Undo, and Redo appear on the Quick Access toolbar. The Quick Access toolbar gives you with access to commands you frequently use. Next to the Microsoft Office button is the Quick Access toolbar. You can use the menu to create a new file, open an existing file, save a file, and perform many other tasks. When you click the button, a menu appears. In the upper-left corner of the Excel 2007 window is the Microsoft Office button. Also, settings in Excel 2007, Windows Vista, and Windows XP allow you to change the color and style of your windows. If you use a high resolution, more information fits on your screen, but the size of the text and images are smaller. If you use a low resolution, less information fits on your screen, but the size of your text and images are larger. Resolution determines how much information your computer monitor can display. 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. Note: Your screen will probably not look exactly like the screen shown. The Microsoft Excel window appears and your screen looks similar to the one shown here. To begin this lesson, start Microsoft Excel 2007. ![]() You use the window to interact with Excel. This lesson will introduce you to the Excel window. How to navigate in a Windows environment is helpful, this tutorial was This tutorial teaches Microsoft Excel basics. You can also use it to perform mathematical calculations quickly. You can use it to organize your data into rows and columns. Microsoft Excel is an electronic spreadsheet. Lesson 1: Entering Text and Numbers The Microsoft Excel Window
0 Comments
Leave a Reply. |