[Free] Electronic Spreadsheet Class 10 I.t. Part-2
Add delete/rename/move worksheet,Freeze Panes,Rows & Columns, Consolidation of data, What-If Analysis, Goal Seek,Solver – Free Course
What you’ll learn
- How to add a new worksheet? How to delete/rename/move or copy a worksheet?
- How to Freeze Panes, Freeze Rows and Columns. How to Unfreeze Rows or Columns
- Consolidation of data, Creating Subtotals
- What-If Analysis, What-if scenario, Goal Seek, Data Table, Solver
Requirements
- Nil
Description
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?
Author(s): Prabh Kirpa Classes
