Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated:
1
00:00:01,000 --> 00:00:09,820
In excel by default a formula references the cell relative to the formula location not the absolute
2
00:00:09,820 --> 00:00:12,150
position of the cell on the cheap.
3
00:00:13,020 --> 00:00:21,640
When you paste a formula to a new location it references cells relative to the new location not the
4
00:00:21,640 --> 00:00:23,770
original location.
5
00:00:23,770 --> 00:00:34,810
For example consider a formula in cell D nine that adds the values in the cells D4 to D D7 let us learn
6
00:00:35,020 --> 00:00:44,610
how Excel interprets the formula in cell D nine which is adding values in cells D for to D 7 to add
7
00:00:44,610 --> 00:00:55,980
the values in cells D Ford to D 7 it still looks up in the cells 2 3 4 and 5 rose above and in the same
8
00:00:55,980 --> 00:01:06,780
column as the current cell D 9 it adds to values and displays the result in the selected cell D 9.
9
00:01:06,780 --> 00:01:14,790
Note that excel is not looking for values in cells default to D7 but is interpreting the references
10
00:01:14,790 --> 00:01:20,000
to these cells in terms of the location from the current set.
11
00:01:20,010 --> 00:01:29,390
This is called relative referencing Excel uses relative referencing by default which makes the formula
12
00:01:29,390 --> 00:01:31,640
work in the new location.
13
00:01:32,000 --> 00:01:42,980
If we copy the cell D nine and paste it in Cell B nine cell B nine displays the sum of cells B for to
14
00:01:42,980 --> 00:01:50,880
be seven because formula in cell D nine uses relative referencing.
15
00:01:50,960 --> 00:02:02,600
Notice that the formula in B nine is referencing cells before to be seven and not cells D or 287 Excel
16
00:02:02,600 --> 00:02:11,940
can also use absolute referencing in that case Excel interprets it in terms of absolute location of
17
00:02:11,940 --> 00:02:13,320
the referenced cells.
18
00:02:14,250 --> 00:02:16,890
Select cell E4.
19
00:02:17,040 --> 00:02:25,050
Notice that the cell contains formula to display sale of Apple as a percentage of total fruit sales
20
00:02:25,470 --> 00:02:30,660
which is in cell D 9 for absolute referencing.
21
00:02:30,730 --> 00:02:39,210
You need to put a dollar sign before the column and the raw identifiers in the same name.
22
00:02:39,240 --> 00:02:51,090
That is why in the formula you see dollar D dollar 9 to copy the formula click copy select cell e 5
23
00:02:53,090 --> 00:03:03,110
click the down arrow on the best tool Excel displays the paste gallery click the second option in the
24
00:03:03,110 --> 00:03:13,470
first row of the gallery to paste the copied formula in cell e 5 cell e 5 now displays the seal of Orange
25
00:03:13,890 --> 00:03:24,480
as a percentage of total fruit sales the formula in e 5 is referencing cell D 9 as it should due to
26
00:03:24,480 --> 00:03:32,650
the use of absolute referencing let us again copy the formula from cell e 5 to cell E6
27
00:03:35,640 --> 00:03:45,600
the cell E6 contains formula to display seal of mangle as a percentage of total food sales by default
28
00:03:45,930 --> 00:03:51,120
Excel copies both formula and formatting to the destination set.
3314
Can't find what you're looking for?
Get subtitles in any language from opensubtitles.com, and translate them here.