Class-X, UNIT 2: ELECTRONIC SPREADSHEET (ADVANCED), IT SKILLS-402

 

UNIT 2: ELECTRONIC SPREADSHEET (ADVANCED)

IMPORTANT Q/ ANS                                strictly as per the CBSE syllabus for class-X        INFORMATION TEC\HNOLOGY-402

Q1: What is data consolidation?

Data consolidation is the process of combining data from multiple sources into a single location or Master Location.

Q2: Write the functions that are used in data consolidation?

The data can be consolidated using a variety of functions, such as SUM, COUNT, AVERAGE, MAX, and MIN.

Q3: What are the uses of data consolidation?

Data consolidation is a useful tool for

1.      Analysing data

2.      Identifying result

3.      Making informed decisions

4.      Create reports and presentations.

Q4: Where you find the data consolidation function?

Data tab

Q5: Explain Subtotal.

A subtotal in Calc is a summary of data within a range of cells. It is calculated using a mathematical function, such as SUM, AVERAGE, or COUNT. Subtotals can be used to group data and make it easier to read and analyse. It also allow you to sort the data.

 

Q6. What is “what-if” scenario?

A what-if scenario in a spreadsheet is a set of values that you can use to test the impact of changes to your data.

Or

The Scenario Manager allows you to create and save multiple sets of values for a worksheet. You can then switch between these scenarios to see how different values affect the results.

Q7. What is Goal-seek? Write the steps to apply Goal-seek?

The Goal Seek feature allows you to set a target value for a cell and then Excel will automatically change the values in other cells to achieve that target value.

To use Goal Seek, follow these steps:

1. Click on the Data tab.
2. In the What-If Analysis group, click on Goal Seek.
3. In the Goal Seek dialog box, enter the target value in the To value box.
4. Select the cell that contains the value you want to change. Then Click on OK.

 

Q8. What is solver? Why it is used?

Solver is a tool in spreadsheet under the tool menu that allows you to find the optimal solution to a mathematical problem. It can be used to find the minimum or maximum value of a formula.

Q9. Write a short note on “Link-data” in spreadsheet?

Link-data in spreadsheets is a way of connecting data from different worksheets or workbooks. Uses of Linking Data are as follows:

1.    Consolidating data

2.       Creating reports

3.       Sharing data

4.       Data is consistent across multiple worksheets 

5.       Save time and effort by automating the process

 

Q10. How many ways to are there to link data in spreadsheets?

Or

What are the two ways of referencing cells in other worksheets?

There are two ways to link data in spreadsheets:

1. Relative links: Relative links use the position of the cells in the source worksheet to determine the location of the linked data in the destination worksheet.
2. Absolute links: Absolute links use the absolute address of the cells in the source worksheet to determine the location of the linked data in the destination worksheet.

Q11. How can we rename a worksheet?

There are three methods any one can be use:

1.       Method-1: Double-click on one of the existing worksheet names.

2.       Method-2: Right-click on an existing worksheet name, then choose Rename from the resulting Context menu.

3.       Method-3: Select the worksheet you want to rename (click on the worksheet tab) and then select the Sheet option from the Format menu. This displays a submenu from which you should select the Rename option.

 

 Q12. List the procedure involved in Linking HTML Tables to Calc Worksheet.

1. Open the Calc worksheet.
2. Select the cell.
3. Click on the Insert tab.
4. In the Data group, click on Link to External Data.
5. In External Data dialog box, click on the from a file tab.
6. In the File name field, enter the URL of the HTML file that contains the table you want to link.
7. Click on the Open button.
8. In the Link to Data Range dialog box, select the table that you want to link. Then click ok.

Q13. Blanks:

1.       At the bottom of each worksheet window is a small tab that indicates the name of the worksheets in the workbook.

2.    A cell reference refers to a cell or a range of cells on a worksheet and can be used to find the values or data that you want formula to calculate.

3.       Spreadsheet software allows the user to share the workbook and place it in the network location where several users can access.

4.      Spreadsheet software can find the changes by Comparing Sheets.

5.      Macros are useful to automate a task the same way over and over again

 

Q14. What is the purpose of sharing worksheet?

Sharing worksheet data refers to the process of allowing multiple users to access and edit the same worksheet. This can be done in a number of ways, depending on the spreadsheet software.

Spreadsheet software allows the user to share the workbook and place it in the cloud location where several users can access.

Cloud storage is a way to store data online so that it can be accessed from anywhere with an internet connection. This makes it ideal for sharing workbooks with other users, as they can access the workbook from their own computers or devices.

Some popular cloud storage services that can be used to share spreadsheet workbooks include:

• Google Drive
• OneDrive
• Dropbox
• iCloud

Q15. What is the purpose of comparing sheets

Spreadsheet software can find the changes by comparing sheets.

Most spreadsheet software programs have a built-in feature that allows you to compare two sheets and see the differences between them

Steps to compare sheets :

To compare two sheets in spreadsheet software, you typically select the two sheets that you want to compare and then click on the "Compare" button. The spreadsheet software will then generate a report that shows the differences between the two sheets.

Q16. What are Macros? How can we record a Macro?

A macro is a series of commands that can be recorded and played back later. This can be useful for tasks that you do frequently.

To record a macro, you can use the following steps:

1. Open the spreadsheet where you want to record the macro.
2. Click on the Developer tab.
3. In the Macros group, click on Record Macro.
4. In the Macro name box, enter a name for the macro.
5. In the Store macro in box, select the workbook where you want to store the macro.
6. Click on the OK button.