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
Rating: 0.0 out of 5 (0 ratings)
385 students
English

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?


Who this course is for:

  • Electronic Spreadsheet Class 9 and 10 I.T.

Instructor

Prabh Kirpa Classes
  • 4.4 Instructor Rating
  • 46 Reviews
  • 5,160 Students
  • 40 Courses

This channel is purely education based. Our aim is to ensure that the students are able to understand each and every question in an easy way.  We take pride in providing quality educational services to the students of Class VII to Class X  Science NCERT ,English & Computer solutions..  Our goal is to help the leaders of tomorrow to learn to succeed today.