Answer:
1.) Relative cell reference - A1
2.) Absolute cell reference - $D$2
3.) Mixed cel reference - $D2
Explanation:
In Microsoft Excel, cell references are very important and critical when dealing with formula. They can give you what you’re looking for or make your entire worksheet incorrect.
A cell reference is a cell address or a range of cell addresses that can be used in a formula.
There are three types of cell references and they are;
a) Relative reference
b) Absolute reference
c) Mixed reference
A relative cell reference is a cell reference that changes when you copy the formula to other cells. It s usually just a normal cell reference like A1, B2, C3. If a formula with a relative cell reference is copied down to other cells, the formula will change. That is a formula with a relative cell reference changes with respect to the cell which it is copied to.
An absolute reference does not change when you copy the formula to other cells. In absolute references, the dollar sign $ is used to “lock” both the row and column so that it does not change when it is copied to other cells. An example is $D$2.
Using a mixed cell reference, one is trying to see that only either the row or column changes with respect to other cells when they are copied. It is like “locking” either the column or the row while changing the other. Just like from the example, $D2 is a mixed cell reference where only the column is locked such that only the row changes when the formula is copied to other cells.
The options are available for storing backups, physically are:
- In both on site and off site,, a person can backup data to a given system that is located on-site, or the backups can be sent to any remote system that is off-site.
<h3>What is a backup?</h3>
This is known to be a device that helps to save information or data temporarily or permanently.
Note that in the above, The options are available for storing backups, physically are:
- In both on site and off site,, a person can backup data to a given system that is located on-site, or the backups can be sent to any remote system that is off-site.
Learn more about backups from
brainly.com/question/17355457
#SPJ12
My parental figures utilize a wide range of sorts of innovation to help bolster me. For instance, I would state an auto is a gigantic piece of tend to a youngster. When I should have been dropped off at school or move my folks had an auto to enable me to arrive. Another case would be kitchen innovation. My mother dependably cooks for my family and that is a basic piece of developing is nourishment. Guardians can find out about new innovation through the Internet and by assets.
This site is only for education related questions. You should only answer or ask questions. That's what we are here for. Whoever is reading this answer, please spread it to stop people from zooming, hurting others, or just posting non-related to education questions. Thank you.
