UNIT 2: Electronic Spreadsheet (Advanced) using LibreOffice Calc IT402 class10th

  Class -10th 

Information Technology (402)

UNIT 2:  Electronic Spreadsheet (Advanced)

using LibreOffice Calc

Practical Marks : 5

Download Libre 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 spreadsheets data :

• 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)  Use Macros in spreadsheet  :

• Demonstrate the use of a macro recorder.
• Create a simple macro.
• Use a macro
• Pass arguments to a macro
• Pass the arguments as values
• Write the macros that act like built – in functions
• Access cells directly
• Sort the columns using macro