Question

Q.5) What is data consolidation?
(3)
Q.7) You want to add a link to one of the three tables in an HTML file(result.html). How would yo
do it in Calc? Write steps.
(4)marks​

Answer 1

Answer:

Q.5. Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that you can update easily

Q7. To insert sheets and rename afterwards: 1) In the Insert Sheet dialog, choose the position for the new sheets. (in this example, we use After current sheet). 2) Choose New sheet and 3 as the No. of sheets. ( Three sheets are. 3) Click OK to insert the sheets. 4) For the next steps, go to “Renaming sheets” below.