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:
A.)
arr[0] = 10;
arr[1] = 10;
Explanation:
Given the array:
arr = {1,2,3,4,5}
To set the first two elements of array arr to 10.
Kindly note that ; index numbering if array elements starts from 0
First element of the array has an index of 0
2nd element of the array has an index of 1 and so on.
Array elements can be called one at a time using the array name followed by the index number of the array enclosed in square brackets.
arr[0] = 10 (this assigns a value of 10 to the index value, which replace 1
arr[1] = 10 (assigns a value of 10 to the 2nd value in arr, which replaces 2
To bleep it out! hopefully this helped
Answer:
The output is "Pasta"
Explanation:
Given
The attached code segment
Required
The output
The first line of the program implies that:
MyFavFood="Pasta"
This means that, the value of the variable MyFavFood is string "Pasta"
Next,
print (MyFavFood)
This prints the value of the variable MyFavFood which is "Pasta"
<em>Hence, the output is "Pasta"</em>
