Free Excel Tutorial – Electronic Spreadsheet Class 10 I.T. Part-I
This course is designed for students in Class 9 and 10 studying Information Technology. It covers various topics related to electronic spreadsheets, including the benefits, workbook and worksheet management, cell addressing, page breaks, chart types, data sorting and filtering. The course provides step-by-step instructions on how to perform different tasks in Excel, making it suitable for beginners.
1. What is Electronic Spreadsheet?
2. What are the benefits of Electronic Spreadsheet?
3. What do you mean by a workbook?
4. What do you mean by a worksheet?
5. How can we add a new worksheet in an Excel workbook?
6. How to delete a worksheet in an Excel workbook?
7. How to rename a worksheet?
8. What do you mean by Rows and Columns in a worksheet?
9. What do you mean by Cell in a worksheet?
10. What is the meaning of Cell Address?
11. What is Active Cell?
12. What is Cell pointer?
13. What do you mean by Page Break?
14. How to insert Horizontal Page Break?
15. How to insert Vertical Page Break?
16. How to remove Page Break in Excel?
17. How to remove all manual page breaks?
18. What is Address Bar?
19. What is Formula Bar?
20. What do you mean by Status Bar?
21. How many cells would be there is the cell range?
1. What are the various types of charts in Electronic Spreadsheet?
2. Write a note of Bar charts?
3. Write a few lines on Column Charts?
4. What do you mean by Line Charts?
5. What are Pie Charts?
6. Write a note on Area Charts?
7. What are XY (Scatter) Charts?
8. What are the different components of a chart?
9. What do you mean by Chart area?
10. What are Grid Lines?
11. What do you mean by Legends?
12. What do you mean by Data sorting?
13. How to Sort Data in Excel?
14. What is Data filtering?
15. How to filter data in Excel?
16. What do you mean by Freeze Panes?
1. Define Bar Chart? How to prepare a Bar Chart?
2. Define Column Chart? How to prepare a Column Chart?
3. What is Pie Chart? How to prepare a Pie Chart?
4. What is Line Chart? How to prepare a Line Chart?
5. What is an Area Chart? How to prepare an Area Chart?
6. What is XY(Scatter) Chart? How to prepare a XY(Scatter) Chart?
7. Discuss the important components of a chart?
8. How to do Data Sorting?
9. How to filter data?
1. What is Page Break?
2. What are the various steps to insert a horizontal page break?
3. What are the various steps to remove a horizontal page break?
4. How to remove all manual page breaks?
5. What are the various steps to insert a vertical page break?
6.What are the various steps to remove a vertical page break?
Who this course is for:
- Class 9 and 10 I.T.
User Reviews
Be the first to review “Free Excel Tutorial – Electronic Spreadsheet Class 10 I.T. Part-I”
You must be logged in to post a review.
There are no reviews yet.