Electronic Spreadsheet Class 10 I.T. Part-2

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.

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?


Online Tutorials
Show full profile

Online Tutorials

Online Tutorials is a website sharing online courses, and online tutorials for free on a daily basis. You can find the best free online courses and thousands of free online courses with certificates to take your knowledge to the next level with the free courses.

We will be happy to hear your thoughts

Leave a reply

Online College Courses
Logo
Register New Account