2.2 How to Create and a worksheet?
To create a spreadsheet :
- First you’ve to enter your data into the sheet. Here we’ve created a sheet where we’re organising the daily expenses. Where in total we’ve applied a formula.
Sum is used to add the entries from E2 to E7, where E stands for the column. And 2 & 7 stands for the row no.
- “:” this is known as Range which selects the range of the cells. For example in the picture below Range have been selected from E2 to E7.
To save a worksheet:
- Click on File > Save As.
- Then choose the location where you want to save your file. Here I’ve selected desktop.
3. Give name to your file and click on save.
4. Now you can check your file will be saved as Book1.xlsx.
Watch this video!
Video Player
00:00
00:00