Electronic Spreadsheet Class 10 I.T. Part - 3

Conditional Formatting, insert sheets in a spreadsheet, Creating reference to other sheets, Types of cell references
Rating: 0.0 out of 5 (0 ratings)
361 students
English

Conditional Formatting and types of Conditional Formatting
How to insert or rename sheets in a spreadsheet
Creating reference to other sheets by using keyboard and mouse
Cell reference, Relative Cell reference
Absolute Cell reference, Mixed Cell reference

Requirements

  • Nil

Description

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?

1. What do you mean by Conditional Formatting and when it is used?

2. What are the different types of Conditional Formatting?

1. How to insert a new sheet in a spreadsheet?

2. How to rename sheets in a spreadsheet?

1. How to create cell reference to other sheets (in the same spreadsheet) by using mouse?

2. How to create cell reference using a keyboard?

3. How to create cell reference to other spreadsheets using mouse or by using keyboard?

1. What do you mean by cell reference.

2. What is relative cell reference? How to create relative cell reference?

1. What is Absolute Cell Reference? How to create absolute cell reference?

2. What is Mixed Cell Reference? How to create Mixed cell reference?

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?

1. What do you mean by Conditional Formatting and when it is used?

2. What are the different types of Conditional Formatting?

Who this course is for:

  • Electronic Spreadsheet Class 9 & 10 I.T.

Instructor

Prabh Kirpa Classes
  • 4.4 Instructor Rating
  • 45 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.