Скачать или смотреть SCENARIS ANALYSIS | ELECTRONIC SPREADSHEET (ADVANCED) | VOCATIONAL SKILLS | IT 402 | CLASS 10

Well Explained answer in video.

Class - X IT 402 Solution / Assignment Playlist
   • CLASS 10 | IT | 402 | COMPUTER | SUMITA AR...  

Class - X Previous Year Question Paper(ALL Subject) Playlist
   • Плейлист  

Question Explained in the Vocational skills sections
(ELECTRONIC SPREADSHEET - Session 1 to 4)
Session 1 Scenarios Analysis
1. What is data consolidation? What is its use?
2. How do you consolidate data in Calc?
3. What is the command used to consolidate data in Calc?
4. Write command(s) to calculate subtotals for expense field in a expense worksheet.
5. What is What-if analysis? How is it useful?
6. What various tools are available for what-if analysis in Calc?
7. Write Calc Commands used for various what-if tools.
8. How is solver different from goal seek?
9. What is the use of scenario tool?
10. What is the use of goal seek tool?

Session 2 Linking Spreadsheet Data
1. What is the use of multiple sheets in a workbook?
2. How would you
(a) Insert a new sheet in a workbook?
(b) Rename a sheet in a workbook?
(c) Delete a sheet from a workbook?
3. How do you link two or more sheets in a workbook?
4. What is a document hyperlink?
5. How are hyperlinks of documents useful?
6. When would you insert following types of links in your worksheets? Give example situation.
(a) A document hyperlink (b) Link to external data

Session 3 Share and Review a spreadsheet
1. What is the need for sharing a document in Calc?
2. How do you open a document in sharing mode in Calc?
3. Which command changes the mode of a document from shared to unshared mode and vice-versa?
4. What happens when you are saving a shared document and there are changes made by multiple users in separate non-overlapping ranges?
5. What happens when you are saving a shared document and there are changes made by multiple users in common overlapping ranges?
6. If someone is resolving the conflicts made a shared document and you try to save the same document at that time, what will happen?
7. What is the use of record changes mode?
8. What is the use of comments in record change mode? How do you add/edit them?
9. How would you review the changes made in record changes mode?
10. You want to reject all the changes made in the Record changes mode? What will you do?
11. You want to accept or reject changes after going through each of them in a document. How would you do this?
12. How would you compare two documents in Calc?
13. When would you prefer merging two document? Which command would you use to do this?

Session 4 Macros in Spreadsheet
1. What is a macro?
2. What is the need for macros?
3. You know the advantages of the macros. Can you think of any disadvantage of macros?
4. Which command would you use to (a) Record a macro (b) Run a Macro
5. How are macro internally saved?




Entrepreneurial skills
green skills
computer
computer class
dav public school
digital documentation class 9
digital documentation class 10
style in document
insert image
mail merge
templates
table
Scenarios Analysis
linking spreadsheet data
goal seek
scenarios analysis
whatifanalysis
solver
share and review a spreadsheets
macro in spreadsheets
introducing database
creating database and tables
creating/ editing tables in Design view
Performing Operations on Tables
Queries in Base
Structured Query Language
Forms Wizard
Report Wizard
Working with Accessibility Options
Networking Fundamentals
Instant Messaging
Publishing Blogs (web logs)
Online Transactions
Internet Security
Workplace Safety
Accidents, emergencies and prevention.

digital documentation
electronic spreadsheets
database management system
dbms
web application class
networking
fundamental
preparation
it class 10 sample paper
it class 10
it class 10 code 402 book
it class 10 code 402 solutions
it class 10 practical
it class 10 notes
it 402 class 10 syllabus
it 402 class 10 solutions
it 402
class 10 it 402 sample paper
class 10 it 402 book
solution


#itclass10
#it_402
#class09
#class10maths
#syllabus
#class10
#davpublicschool
#cbse
#answer
#solution
#computerscience
#computer_applications
#computer
#it402
#operatingsystem
#ubuntu
#computermostquestion
#it402class10
#importantquestions
#class9th
#class9maths
#question
#questionanswer
#sumita_arora

VKPDT IT GURU
VINOD KUMAR PANDIT IT GURU