Question

Enlist any two spreadsheet software what is the difference between absolute cell and relative cell referencing?​

Answer 1

The two popular spreadsheet software is Microsoft Excel and Calc. These both have all the features of handling the calculation of the data.

Explanation:

Absolute cell referencing: The process in cell reference is that formula remains unchanged whenever copy function is executed. Being helpful, the feature is used in a specific cell for multiple calculations.

when using the relative cell referencing, if the formula is copied from one cell to the other, it adjusts itself to have the same relation to new location.  

• For example: If cell C10 contains formula =SUM(C1: C9) and it is copied to E10, formula is automatically adjusted to =SUM(E1: E9)
• Whereas, when you use absolute referencing, the formula will remain the same even after you copy it to other cells.
• For example: If the formula in cell C11 is =SUM($C$1:$C$10), when you copy the formula to a new location E44, the formula in new location will remain the same as =SUM($C$1:$C$10)
• The use of '$' before column letter indicated that the reference to column is absolute or fixed. and '$' used before row represents an absolute row reference.

To learn more about Absolute cell referencing:

Example of absolute cell reference

https://brainly.in/question/7160321

What is absolute cell referencing

https://brainly.in/question/12488614

Answer 2

The two spreadsheet software's:

Two spreadsheet software examples are:

1) Google Sheets

2) Microsoft Excel

In absolute referencing, when we write a formula based on a combination  of cells and copy them to some other cell, the formula gets modified in accordance with the trend or access pattern.

In relative referencing, when we write a formula based on a combination  of cells, we need to use the dollar signs so that the cells do not change  with the trend and we can access the same cells to produce results in different  fields.

Learn More About spreadsheet software:

THE USES OF SPREADSHEET SOFTWARE/MS EXCEL

https://brainly.in/question/68693

Spreadsheet software's page layout options for organising pages

https://brainly.in/question/11393868