U-2 Spreadsheet IT(402) Class 10th Pr

  Class -10th 

IT (402)

UNIT 2: ELECTRONIC SPREADSHEET (ADVANCED)

Practical Marks : 5

Download Open Office:

1) Analyse data using scenarios and goal seek.

• • Use consolidating data Create subtotals 
•  • Use “what if” scenarios Use “what if” tools 
•  • Use goal seek and solver 

2)  Link data and spreadsheets :

• • Setup multiple sheets by inserting new sheets. 
•  • Create reference to other sheets by using keyboard and mouse. 
•  • Create references to other documents by using keyboard and mouse. 
•  • Create, Edit and Remove hyperlinks to the sheet. 
•  • Link to external data. 
•  • Link to registered data source.

3)  Share and review a spreadsheet :

• • Set up a spreadsheet for sharing. 
•  • Open and save a shared spreadsheet. 
•  • Record changes. 
•  • Add, Edit and Format the comments. 
•  • Review changes – view, accept or reject changes. 
•  • Merge and compare sheets. 

4)  Create and Use Macros in spreadsheet  :

• • Demonstrate the use of a macro recorder. 
• • Create a simple macro. 
• • Use a macro 
•  • Access cells directly 
• • Using a macro. 
•  • Sort the columns using macro.