Its name is comprised of two parts: the column letter and the row number. In the following picture, the cell C3—formed by the intersection of column C and row 3—contains the dark border. It is the active cell. The vertical scroll bar located along the right edge of the screen is used to move up or down the spreadsheet. The horizontal scroll bar located at the bottom of the screen is used to move left or right across the spreadsheet.
The PageUp and PageDown keys on the keyboard are used to move the cursor up or down one screen at a time. As mentioned, each workbook defaults to three worksheets. These worksheets are represented by tabs—named Sheet1, Sheet2 and Sheet3—that appear at the bottom of the Excel window. By the end of this lesson, you should be able to: Identify the parts of the Excel window Understand the differences between a workbook and a worksheet Understand a cell and its importance to Excel Move around a workbook.
Workbook Also called a spreadsheet, the workbook is a unique file created by Excel XP. Title bar The title bar displays both the name of the application and the name of the spreadsheet. Menu bar The menu bar displays all of the menus available for use in Excel XP. Toolbar Some commands in the menus have pictures or icons associated with them. Column headings Each Excel spreadsheet contains columns.
Row headings Each spreadsheet contains 65, rows. Each row is named by a number. Name box This shows the address of the current selection or active cell.
Formula bar The formula bar isplays information entered—or being entered as you type—in the current or active cell. Which window is used to display an open workbook file? Window is used to display an open workbook file? Who are the creators of Microsoft Excel? How do you launch Microsoft Excel? Are there any Games in Microsoft Excel ?
What is titlebar in Microsoft Excel? Give the Parts and the functions of Microsoft Windows? Where can you find a labeled diagram of Microsoft Excel on the Internet? Is Microsoft Excel is a software? Microsoft Excel is an example of a?
Does the iPad have Microsoft Excel on it? What is the difference between excel and a word window? Is Excel a part of Microsoft office? What is Microsoft Word Excel?
What is another name for Microsoft Excel? Who created Microsoft Excel? Who developed Microsoft Excel? Does window 8 have Word Excel Powerpoint and Onenote? What is Microsoft Office Excel Excel? Study Guides. Trending Questions. What's the most outdated thing you still use today? Is it better to take a shower in the morning or at night? What scramble words can you make with these letters a i t o r?
Worksheet Window — A window that displays an Excel worksheet, basically this is where you work all the tasks. Vertical Scroll Bar — Scroll bar to use when you want to scroll vertically through the worksheet window.
Horizontal Scroll Bar — Scroll bar to use when you want to scroll horizontally through the worksheet window. Zoom Controls — Used for magnifying and shrinking of the active worksheet. View Shortcuts — Buttons used to change how the worksheet content is displayed.
Sheet Tabs — Tabs the display the name of the worksheet in the workbook, by default its name sheet 1, sheet 2, etc. You can rename this to any name the best represent to your sheet. By default, new formulas use relative references.
If the position of the cell that contains the formula changes, the absolute reference remains the same. If you copy or fill the formula across rows or down columns, the absolute reference does not adjust. By default, new formulas use relative references, so you may need to switch them to absolute references. Mixed references A mixed reference has either an absolute column and relative row, or absolute row and relative column. If the position of the cell that contains the formula changes, the relative reference is changed, and the absolute reference does not change.
If you copy or fill the formula across rows or down columns, the relative reference automatically adjusts, and the absolute reference does not adjust. Conveniently referencing multiple worksheets If you want to analyze data in the same cell or range of cells on multiple worksheets within a workbook, use a 3-D reference.
A 3-D reference includes the cell or range reference, preceded by a range of worksheet names. Excel uses any worksheets stored between the starting and ending names of the reference. B5 adds all the values contained in cell B5 on all the worksheets between and including Sheet 2 and Sheet P, VAR.
What occurs when you move, copy, insert, or delete worksheets The following examples explain what happens when you move, copy, insert, or delete worksheets that are included in a 3-D reference. A2:A5 to add cells A2 through A5 on worksheets 2 through 6. Insert or copy If you insert or copy sheets between Sheet2 and Sheet6 the endpoints in this example , Excel includes all values in cells A2 through A5 from the added sheets in the calculations. Delete If you delete sheets between Sheet2 and Sheet6, Excel removes their values from the calculation.
Move If you move sheets from between Sheet2 and Sheet6 to a location outside the referenced sheet range, Excel removes their values from the calculation. Move an endpoint If you move Sheet2 or Sheet6 to another location in the same workbook, Excel adjusts the calculation to accommodate the new range of sheets between them. Delete an endpoint If you delete Sheet2 or Sheet6, Excel adjusts the calculation to accommodate the range of sheets between them.
You can also use a reference style where both the rows and the columns on the worksheet are numbered. The R1C1 reference style is useful for computing row and column positions in macros. In the R1C1 style, Excel indicates the location of a cell with an "R" followed by a row number and a "C" followed by a column number. When you record a macro, Excel records some commands by using the R1C1 reference style. For example, if you record a command, such as clicking the AutoSum button to insert a formula that adds a range of cells, Excel records the formula by using R1C1 style, not A1 style, references.
0コメント