It also contains Quick Access Toolbar, Search Bar, and Minimum, Maximum, and Close options.įor instance, the Title Bar will show the name as, Travel Expenses Tracker.xlsx. It is the green part at the top of the Excel sheet.ĭisplays the name of the current spreadsheet/ workbook and its extension. It helps to access various tabs such as Home, Insert, Formulas, Data, Page Layout, View, Review, etc.įor instance, in the “ Home” tab of Excel, you can format cells, change alignments, and many more. You can switch between the “ Itinerary” and the “ Budget” sheets by clicking on the desired sheet tab. You can also add, delete, hide, and rename worksheets. You can navigate between worksheets by clicking on the sheet tab. It is located at the bottom left of the spreadsheet program window. If you enter the formula =SUM(D1:D5) in Cell D6, this same formula will also be visible in the Formula Bar. You can enter and edit text, functions, and formulas in the formula bar. It displays the content of the selected cell. It helps to identify the row location of the selected cell.įor instance, Row 1 can represent “ Switzerland,” and Row 2 can represent “ Paris“. There are 1,048,576 rows in the newer version of Microsoft Excel. Rows are labeled with numbers like 1, 2, 3, etc. It is located on the extreme left side of the spreadsheet. You can label Column A as Cities and Column B as Hotels in the worksheet. It helps to identify the column location of the selected cell. 16,384 is the maximum number of columns in the newer version of Microsoft Excel. After Z, the column is referred to as AA, AB, AC, and so on. If you enter “ Flight Details” in Cell C1, then Cell C1 becomes the active cell.Ĭolumns are designated using the letters A to Z. The active cell, also called cell address, is the currently selected cell in a spreadsheet. The main center area consists of columns and rows in the form of a grid.įor instance, if you create a travel plan worksheet, you can enter details like Flight Details, Cities, and Hotels in the spreadsheet work area. For convenience, some useful Excel to PDF converters convert Excel to PDF files for free while maintaining the original formatting. Once you create an Excel Spreadsheet, you can convert it to a universally accepted format like PDF. Step 13: Double-click on the chart title and change the name of the bar chart.
The bar chart has been changed to the new style format. Step 12: Select the desired design format under the “ Chart Styles” group of the “ Chart Design” tab. Step 11: Select the result table, go to the “ Insert” tab, and select the desired option of the bar chart under the “ Charts” group.
Let’s make a pie chart to make this result table more attractive. Step 10: You can also create a result table to display only the total projected cost, total actual cost, and the difference between them. The image below shows that the dollar symbol is assigned to every data cell. Step 9: Select the whole data, go to the “ Home” tab, and select the dollar sign under the “ Number” group. We will add a dollar sign to all cells of the data. The formula will display the difference between projected and actual costs. Step 6: Enter the below formula in “ Cell D2” to calculate the difference. The formula will display the total actual cost. Step 4: Select “ Cell C10” and enter the formula: =SUM(C2:C9) The formula will display the total projected cost in Cell B10. Note: The SUM function adds all the data of the selected range and returns its total. Step 6: Enter all data, as shown in the below image. Move this arrow to the desired width, as shown below.
Step 5: To fit it, select the border between column A and column B. Step 4: Enter “Student Name” as shown below.Īs you can see, the word “Student Name” didn’t fit properly in the cell. Here, we have selected “ Cell A1” and will add headings for our table. Step 3: Select any cell and start typing. Step 2: Select “ New” and click “ Blank workbook”, as shown below.Ī new workbook is created, and “ Sheet1” is open, as shown below. Let’s see how we can do this by opening a new spreadsheet. In this example, you will learn to enter data in a worksheet and calculate the total marks of students. The spreadsheet’s name will be Book 1 if you open it for the first time.Įxample #1: How to Enter Data in a Worksheet Step 3: By default, Sheet 1 will be created as a worksheet in the spreadsheet. OR – Press Ctrl + N: To create a new spreadsheet. Step 2: Go to Menu and select New > Click on the Blank workbook to create a simple worksheet. You can download this Create Spreadsheet Excel Template here – Create Spreadsheet Excel Template