Free Excel Tutorial – Electronic Spreadsheet Class 10 I.T. Part-2
Learn how to add, delete, rename, move, and copy worksheets in Excel. Discover how to freeze panes, rows, and columns for easier navigation. Understand the concept of data consolidation and how to use the Subtotal function. Explore What-if Analysis tools, including Goal Seek and Data Tables. Gain insights into Excel Solver and its functionality. This course is ideal for students studying electronic spreadsheets in classes 9 and 10. Enhance your Excel skills and excel in your IT studies.
1. How to add a new worksheet in excel workbook?
2. How to delete a worksheet in an excel workbook?
3. How to rename a worksheet?
4. How to move a worksheet?
5. How to copy a worksheet?
1. How to Freeze Panes?
2. How to Freeze Rows?
3. How to Freeze Columns?
4. How to Freeze Rows and Columns?
5. How to unfreeze Rows or Columns?
1. What do you mean by consolidation of data?
2. How to do consolidation of data?
3. What is Subtotal function in Excel and for what purpose, it has been designed?
4. What are the steps to be followed if we want to use the Subtotal function?
1. What do you mean by What-if Analysis?
2. What are the three kinds of What-if Analysis tools which come with Excel?
3. What is What-if Scenario?
4. Write a note on Goal Seek?
5. What are Data tables- One variable data table and two variable data table?
6. Write a note on Excel Solver tool? How it works?
What are Data tables- One variable data table and two variable data table?
6. Write a note on Excel Solver tool? How it works?
4. Write a note on Goal Seek?
5. What are Data tables- One variable data table and two variable data table?
6. Write a note on Excel Solver tool? How it works?
What are Data tables- One variable data table and two variable data table?
6. Write a note on Excel Solver tool? How it works?
Who this course is for:
- Electronic Spreadsheet Class 9 and 10 I.T.
User Reviews
Be the first to review “Free Excel Tutorial – Electronic Spreadsheet Class 10 I.T. Part-2”
You must be logged in to post a review.
There are no reviews yet.