#PARTS OF A SPREADSHEET MICROSOFT EXCEL SERIES#

#PARTS OF A SPREADSHEET MICROSOFT EXCEL SERIES#

A row is a horizontal series of cells from left to right. A column is a vertical series of adjacent cells from top to bottom. What are Columns, Rows, Cells, and RangesĬolumns, rows, and cells make up the fundamental components of a worksheet. In the previous image, Sheet1 is the worksheet that is currently being used. The name of the worksheet that you are presently working with will be in bold type on a white background. If the workbook that you are using includes more than one worksheet, you can switch between them by clicking the worksheet tab you want to view. By default, new blank workbooks only include one worksheet, but you can add others if needed: Notably this type of spreadsheet displays columns with alphabetical headers and rows with numerical ones.Ī workbook is a collection of one or more worksheets.

Worksheets are a digital form of the spreadsheet that is used by Microsoft Excel. This data, while most often numerical, can include text, shapes, and pictures. These cells are used to enter, store, and display data.

They consist of intersecting rows and columns that form cells. Spreadsheets are paper or digital documents that are typically used to store, sort, and work with data. What are Spreadsheets, Worksheets, and Workbooks Using Excel, you can analyze large amounts of data, move sets of data around to get a different picture of your figures, and generate a number of different charts and diagrams to help summarize the data. The intersection of a row and column is called a cell (3): In Excel, spreadsheet data is stored in a worksheet, which is made up of rows (1) and columns (2). A spreadsheet is essentially a large flexible grid that is used to hold information, usually numerical data. Microsoft Office Excel 2016 is the 16 th version of Microsoft’s spreadsheet program.

And while you may complete some of the work on your own, a teacher is present to answer all your questions. Soon, with our MS Excel onsite training, you will have all the skills you desire! A brief intro into the various components of an Excel spreadsheet There are many reasons to complete onsite instructor-led Microsoft Office courses with Training Performance.Īfter attending just a few courses you will develop a deep understanding of MS Excel that can ultimately increase your performance drastically. And one of them is Excel, which is used to create customized spreadsheets to hold many forms of data. Microsoft Office has several programs that you can learn to master. Are you looking to build your knowledge in Microsoft Excel? Easy.

Parts of a spreadsheet microsoft excel