Page 284 - TP_IT_V1.0_C10_flipbpookl
P. 284
3. What do you understand by hyperlink? Also, explain its types.
Ans. In LibreOffice Calc, a hyperlink is a feature that allows you to create clickable links within a spreadsheet. When users click
on the hyperlink, Calc will navigate to the specified destination, whether it’s another location within the spreadsheet, a file
on the computer, or a website on the internet.
Hyperlinks in Calc can be edited or removed by selecting the cell containing the hyperlink and then using the appropriate
options by using the context menu.
Hyperlinks helps you to:
● Move to a specific cell within the current spreadsheet.
● Move to a specific location in another file. This file can be a spreadsheet, document, or any other file.
● Accessing a specific website.
● Sending an email to a specific address.
● Creating a new file.
Hyperlinks in a spreadsheet are of two types which are as follows:
● Relative Hyperlink: It refers to reaching the linked document with respect to the current location. It will include the
partial cell address in hyperlink. If the start and target locations change relative to each other, then relative hyperlink
will not work.
● Absolute Hyperlink: It refers to reaching to the linked file by writing the complete address starting from the root
directory. If the target location only changes then the absolute hyperlink will stop working.
4. What do you understand What -If Analysis?
Ans. What-If analysis involves exploring how changes in input variables affect the results of a formula or model. This analysis
can be conducted with one input variable (one-input analysis) or two input variables (two-input analysis). The description
of each input is as follows:
● One-Input What-If Analysis: One-input What-If analysis allows you to examine how changes in a single input variable
impact the outcome of a formula or calculation. You typically set up a column or row of cells containing different values
for the input variable, and then observe how these changes affect the result of a formula elsewhere in the spreadsheet.
For example, if you are analysing the impact of interest rates on loan payments, you might vary the interest rate across
a range of values to see how it affects the monthly payment.
● Two-Input What-If Analysis: Two-input What-If analysis extends this concept to explore the effects of changes in two
input variables on the outcome of a formula or calculation. You set up a grid of cells containing different combinations
of values for the two input variables, and observe how changes in both variables simultaneously affect the result of the
formula. For example, if you are analysing the impact of both interest rates and loan terms on monthly payments, you
might vary both variables across a grid to see how different combinations affect the payment amount.
5. What are the advantages of using macros?
Ans. This process of saving the sequence of commands or keystrokes by a specific name for the later use is called macros. The
main advantages of using macros are:
● It helps you save time as the long and time consuming tasks are saved as macros and can be executed with a click of a
button.
● It saves you from the tedious repetitive tasks.
● The chances of errors in the complex task are reduced.
● You can run a macro as many times as you want until you delete it from the computer.
6. What is the purpose of creating a macro for sorting a column in a spreadsheet, and how can you use it to sort data
automatically?
Ans. The purpose of creating a macro for sorting a column in a spreadsheet is to automate the repetitive task of arranging
data in ascending or descending order. By recording a sequence of commands for sorting, you can execute the same steps
automatically on different datasets without having to manually sort the data each time.
To create and use the macro for sorting data, follow these steps:
Step 1: Create a Spreadsheet: Open LibreOffice Calc and enter the list of cities in the range A1.
Step 2: Select the Data Range: Highlight the range of cells from A2 where the cities are listed.
Step 3: Open Macros Menu: Click on Tools in the Menu bar, then select Macros.
282 Trackpad Information Technology (Ver. 1.0)-X

