Family Food Health Home Money Style More Home » Computers » Computer Software » Spreadsheets » Elements of MS Excel More Articles Like This How to Convert MS Money to MS ExcelWhat Is MS Excel Workbook?How to Generate an MS Access Report to an Excel FileHow to keep track of useful software tips in an Excel spreadsheet with IndexHow to Combine Columns of Data in MS Excel Elements of MS Excel By FrankB,eHow Contributorupdated: November 5, 2010I want to do this!What's This? 
B2M Productions/Photodisc/Getty Images You can put away the calculator when using Excel.Microsoft Excel, the 25-year-old spreadsheet program that's one of the most frequently used productivity tools on computers, has eight basic elements. The spreadsheets are used to analyze small and large sets of numbers. Excel 2010 lets users analyze a maximum of 1,048,576 rows and 16,384 columns -- a far cry from the 16,384 rows and 256 columns available in Excel's earliest Windows incarnation.Toolbars, Ribbons and TabsThe top of the Excel window includes three basic elements. The "Office" button in the upper left-hand corner contains some of the most common program commands, such as "Save" and "Print." Contextual tabs to the right of the "Office" button are labeled "Home," "Insert," "Page Layout," "Formulas," "Data," "Review," and "View." Each contextual tab includes a "Ribbon," which contains relevant commands. The ribbon on the "Home" tab, for example, includes basic commands for formatting; the ribbon on the "Insert" tab lets you put charts, tables and special objects into your spreadsheet.Name and Formula BoxesThe name box in the upper-left hand corner of the spreadsheet, just below the ribbon, indicates the cell where your cursor is located. When you open a spreadsheet, the default location will show "A1," for example. The formula box next to it displays the contents of the cell where your cursor is located. If cell A1, for example, contains the phrase "John Smith," the formula box will display the phrase "John Smith." If the cell contains a formula, even though the cell displays the formula's results, the formula box shows the formula itself.Rows and ColumnsThis is the heart of the spreadsheet, where the information is located. Columns are denoted by letters, A through XFD. Rows are referred to by numbers, 1 through 1,048,476. A cell is defined by the intersection of those two parts. For example, the intersection of the third row and second column would be defined as cell B3.Pages, Layout and ZoomThe lower left-hand corner of the spreadsheet includes tabs for each worksheet in the spreadsheet; the default spreadsheet includes three tabs, labeled "Sheet 1," "Sheet 2," and "Sheet 3." The lower right-hand corner of the spreadsheet contains three layout tabs, allowing you to display the worksheet in different formats, and a zoom slider that lets you magnify or reduce the size of the information on the worksheet. References MS Office Tutorial: Excel Screen Elements Himmera: Elements of the Excel Screen Teacher Click: Elements of Excel Office Watch: Excel: A History of Rows and Columns ResourcesMicrosoft Office 2010: Download a Trial VersionWho Can HelpSponsoredFind Computer, Electrical and Telephone Services Here. Compare Up to 4 Quotes, Free Service & No Obligation.Photo CreditB2M Productions/Photodisc/Getty Images
I want to do this!printemailfavoriteshareFlag Article SubscribePost a Comment
Word Verification*Comment printemailfavoriteshareRelated Ads Related Articles & Videos
How to Convert MS Money to MS ExcelWhat Is MS Excel Workbook?How to Generate an MS Access Report to an Excel FileHow to keep track of useful software tips in an Excel spreadsheet with IndexHow to Combine Columns of Data in MS Excel(play this video)View A Sample Spreadsheet in Microsoft Excel(play this video)How to Choose a Spreadsheet Program(play this video)How to Insert a Row or Column in an Excel Spreadsheet(play this video)How to Create a Spreadsheet Template in Excel(play this video)How to create a simple budget spreadsheet using Microsoft Excel 2007More Have you done this? I Did This eHow delivers daily.Start your day with advice and inspiring ideas.Sign up for newsletters Today's Top How To(play this video)How to Survive an Airport Trip With Your Kids Featured How Tos(play this video)How to Donate Your Cell Phone to Change the World eHow of the Day(play this video)How to Follow Up After a Job Interview Others Also ViewedHow to Embed MS WordDefine MS ExcelParts of the MS Word ScreenWhat Is the Importance of MS Excel?What Is the Small Green Triangle on MS Excel? Home††Article Sitemap †Sitemap How Tos Copyright © 1999-2010 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use † and Privacy Policy †. en-US
† requires javascript
Partner Sites AnswerbagLivestrong eHow_eHow Technology and Electronics COMSCORE.beacon({c1:2,c2:6036385,c3:"",c4:"",c5:"",c6:"",c15:""});
Please login to eHow directly with this email address - you can still use Facebook features.
Ok");ThinBox.remove();ThinBox.open('/account/facebook_merge.aspx?error=duplicate_email&email='+data.split(':')[1]+'&fbid='+response.session.uid);} else {setTimeout("window.location.reload()",1000);}});} }}, {perms:'email,user_interests'});}); }});}});});$('.SecondaryNav ul.main').subNav();$('.PrimaryNav ul.main').subNav();$('.PrimaryNav ul.community').subNav();//$('.jsSearchDropdown').searchDropdown({input:'input.jsDefaultInput'});addLoadEvent(function(){$("img.LazyLoadImage").lazyImage();});addLoadEvent(function() {SiteLifeAvatars.Request();}, 10);UserAction.execute();
0 comments:
Post a Comment