hlep me with this question i will make u brainlist
Answers
Answer:
1.If the cell A1 contains 10 and the B1 contains the 5 then the formula "=A1+B1 *2^3" calculates the value 50. The processor of this is as follows:-
=A1+B1 *2^3
=10+5*8
=10+40
=50
If the user wants to use this formula for the C1 column, then he needs to write this formula in the FX column after pointing the cell C1. Then he gets the answer 50.
2.I think the easiest way to understand it is to start with a very basic example…
Say you have dates 3/15/15, 3/16/15, and 3/17/15 in cells a1 a2 and a3 respectively..
Then in column b you have sales volumes of 50,60,and 70 units in row 1,2,3 respectively and in column c you have sales price of 11, and $12 respectively..
Now in column d you can calculate revenue by selecting cells d1 through d3 (all three cells at the same time) and typing the formula =B1:B3*C1:C3 and pressing ctrl+shift+enter. What this does is treats each section (ie your b and c cells) of your multiplication formula as an array (or group of cells) and gives you seperate results for each cell row in the corresponding cell of the array you entered the formulas into.
3.The formula is "=$B5+C$5", which is copied on the cell E6.
Explanation:
If any formula is copied to any cell, then that cell holds that formula and it also holds the value which is generated by the formula.
The above formula is used to add the cell value of B5 and C5 and then that value is displayed on the cell D5 and E6 if the formula is copied from the cell D5 into E6.
This type of formula is used, if anyone wants to perform any operation for any cell.
4.Cell D5 contains the formula = $B$5+C5 and this formula is copied to cell E5, the copied formula in cell E5 will be = $B$5+D5.
In MS-Excel we use the symbol $ for absolute cell addresses, which does not change when copied to other cells.
In the given formula = $B$5+C5 '$' is used twice with column and row name both, so both will remain constant when copied to another cell.
Cell C5 which is written in the formula in D5 is not constant, so it will change with change in the rows.
The formula = $B$5+C5 when copied to E5 will become = $B$5+D5.
Hence, Cell D5 contains the formula = $B$5+C5, and this formula is copied to cell E5, the copied formula in cell E5 will be = $B$5+D5.
plz mark me brainliest