![]() 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
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |