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.
Answer: D.) All of the above. (happy to help)
Explanation: A.)
problem solving
B.)
expertise
C.)
content
D.)
all of the above
1. To track inventory on excel you should have thorough knowledge on how it is used and different techniques and buttons behave on it. Tracking inventory may use formulas for example the total amount of items sold for the specific day. So where to right formulas and how to use them should be learned.
2.Track personal loan will take a little knowledge about the tool and again here also a little amount of formulas can be used and thus will need a little knowledge that where to write them but will need less knowledge than first one.
3.Evaluation of commitments will need a very low knowledge about tool and can be used easily.
4. Track a project It also need a little knowledge about the tool and will need least knowledge if compared with other options.
Answer: Pseudo code
Explanation:Pseudo code is a false code that is written in the textual story board to make the fictional plot of the story more understandable in the layman terms for everyone.This is done to increase the readability of the code , which cannot be understood easily by the actual code.
It is implemented on the algorithms of a program in computer field so that the complex coding statements can be understood by the programmer.
Answer:
D. Algorithms need to be written in the design phase so they can be translated into code in the development phase.
Explanation:
