![]() ![]() The tab at the bottom of a worksheet tells you the name of the worksheet – such as Sheet1, Sheet2 etc.By default there is one worksheet in an Excel 2013 file.It also contains options for activating a number of settings – such as automatic recalculation of worksheet files and choosing which languages to use for spell check and grammar. The options item, which is also located on the menu, is used to alter the look of the program as a whole by choosing which screen elements to display, such as scroll bars and gridlines.This tab also contains items that are mostly related to file and document management – such as opening new or existing worksheet files, saving, and printing.Instead of having its options display on the horizontal ribbon, clicking on the File tab opens a drop down menu on the left side of the screen. ![]() The File tab was introduced in Excel 2010 replacing the Excel 2007 Office Button, and it works differently than the others tabs.Each tab – such as Home, Page Layout, and Formulas – contains a number of related features and options that are activated by clicking on the appropriate icon. Tabs are part of the horizontal ribbon menu that contains links to various features of the program.First introduced in Excel 2007, the ribbon replaced the menus and toolbars found in Excel 2003 and earlier versions. When clicked on, these buttons and icons activate the various features of program. The Ribbon is the strip of buttons and icons located above the worksheet.Columns run vertically on a worksheet and each one is identified by a letter in the column header.Located next to the formula bar, the Name Box displays the cell reference or the name of the active cell.Click on the down arrow at the end of the toolbar to display available options. This toolbar allows you to add frequently used commands.The forumula bar can also be used for entering or editing data and formulas. Located above the worksheet, this area displays the contents of the active cell. ![]() Each cell in the worksheet can be identified by a cell reference, which is a combination of letters and numbers such as A1, F456, or AA34.A cell is the intersection point of a vertical column and a horizontal row.Each cell can hold only one piece of data at a time. Data entered into a worksheet is stored in a cell.Cells are the rectangular boxes located in central area of a worksheet.Adding additional worksheets can be done by clicking on the add sheet icon next to the sheet tab at the bottom of the screen or you can use this keyboard shortcut to add a new worksheet. ![]() Different cells can be made active by clicking on them with the mouse or by using the arrow keys on the keyboard. Data is always entered into the active cell.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |