Computer Science, asked by shivanshimishra50, 7 months ago

What is Cell Reference? Mention its types.

Answers

Answered by delisha8050

Answer:

There are two types of cell references: relative and absolute. Relative and absolute references behave differently when copied and filled to other cells. Relative references change when a formula is copied to another cell.

Answered by Anonymous

$\underline\mathfrak{ANSWER:-}$

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. In one or several formulas, you can use a cell reference to refer to: ... Data on other worksheets in the same workbook.

$<!DOCTYPE html><html lang="en"><head><title>Pot</title></head><body><body><div class="container"><div class="line1"><div class="leaf1"></div><div class="leaf2"></div><div class="leaf3"></div></div><div class=pot><div class="line2"></div></div></div></body><style>body{background: #fbe6d4;}.container{width: 170px;height: 250px;;background: #fbe6d4;position: absolute;margin: auto;top: 0;bottom: 0;left: 0;right:0;z-index: -2;}.pot{position: absolute;height: 130px;width: 130px;background: linear-gradient(to right, #f6ad7b 50%, #ed9a73 50%);bottom: 0px;left: 20px;border-radius: 50% ;}.line1{width: 140px;height: 100px;background: #fbe6d4;position: relative;top: 40px;left: 20px;z-index:1;overflow: hidden;}.line2{top: 118px;width: 130px;height: 20px;background: #fbe6d4;position: relative;z-index:1;}.leaf1, .leaf2, .leaf3{width: 80px;height: 80px;background: green;position: relative;border-radius: 150px 0;background: linear-gradient(-45deg, #5c7658 50%, #649d66 50%);}.leaf3{transform: rotate(-15deg);bottom: 130px;left: 53px;}.leaf2{transform: rotate(-45deg);z-index:1;bottom: 65px;left: 25px;}.leaf1{transform: rotate(-75deg);top: 30px;right: 4px;}</style></body></html>$

Attachments:

Previous Question

Next Question

What is Cell Reference? Mention its types.​

Answers

What is Cell Reference? Mention its types.