1
00:00:00,080 --> 00:00:04,808
You calculated the first line total but need the same formula for every order.

2
00:00:04,808 --> 00:00:09,198
Dragging a tiny fill handle is awkward on a trackpad and unnecessary here.

3
00:00:09,198 --> 00:00:13,588
We will select a four-cell range, use Excel's Fill Down command,

4
00:00:13,588 --> 00:00:16,628
and check each result against a fictional order list.

5
00:00:16,628 --> 00:00:21,018
The important part is that references update to the row they belong to.

6
00:00:21,618 --> 00:00:24,751
Open the practice Excel workbook, not the optional CSV.

7
00:00:24,751 --> 00:00:28,580
It has quantities in column A and unit prices in column

8
00:00:28,580 --> 00:00:31,017
B, regardless of your regional separator settings.

9
00:00:31,017 --> 00:00:34,846
Row two is three units at twelve dollars fifty; row three

10
00:00:34,846 --> 00:00:38,676
is two at eight dollars; row four is five at four

11
00:00:38,676 --> 00:00:42,157
dollars twenty; row five is one at twenty-five dollars.

12
00:00:42,157 --> 00:00:43,549
Column C begins empty.

13
00:00:43,549 --> 00:00:47,379
Confirm that you see three separate columns before adding a formula.

14
00:00:47,979 --> 00:00:51,732
Click C two and enter equals A two times B two.

15
00:00:51,732 --> 00:00:55,484
That is written exactly as equals A two asterisk B two.

16
00:00:55,484 --> 00:00:58,896
The first line total should be thirty-seven dollars fifty.

17
00:00:58,896 --> 00:01:02,649
If it displays zero or an error, inspect A two and

18
00:01:02,649 --> 00:01:05,720
B two for text values before copying the formula.

19
00:01:05,720 --> 00:01:09,473
A bad first formula will be reproduced in every selected row.

20
00:01:10,073 --> 00:01:14,111
Select C two through C five, including the formula cell at

21
00:01:14,111 --> 00:01:16,681
the top and the three empty destinations.

22
00:01:16,681 --> 00:01:19,251
With the worksheet focused, press Control D.

23
00:01:19,251 --> 00:01:23,289
In our English Excel web test, the four results appeared immediately.

24
00:01:23,289 --> 00:01:27,327
Microsoft also documents Home, Fill, Down as a menu route if

25
00:01:27,327 --> 00:01:29,163
your browser intercepts the shortcut.

26
00:01:29,163 --> 00:01:33,201
Do not select only the empty cells: Excel needs the source

27
00:01:33,201 --> 00:01:34,670
formula inside the selection.

28
00:01:35,270 --> 00:01:37,361
Click C three, then C four.

29
00:01:37,361 --> 00:01:41,195
Their formulas should refer to A three times B three and

30
00:01:41,195 --> 00:01:45,029
A four times B four, not keep pointing at row two.

31
00:01:45,029 --> 00:01:48,864
Those are relative references, so Excel adjusts them when filling down.

32
00:01:48,864 --> 00:01:52,001
The results are sixteen dollars and twenty-one dollars.

33
00:01:52,001 --> 00:01:54,440
C five should read twenty-five dollars.

34
00:01:54,440 --> 00:01:57,926
This cell-by-cell check catches an accidental fixed reference.

35
00:01:58,526 --> 00:02:03,705
Add the four line totals: thirty-seven fifty, sixteen, twenty-one, and twenty-five.

36
00:02:03,705 --> 00:02:05,555
They equal ninety-nine fifty.

37
00:02:05,555 --> 00:02:09,625
If yours differs, compare each row rather than changing the final

38
00:02:09,625 --> 00:02:11,105
sum until it matches.

39
00:02:11,105 --> 00:02:14,064
The answer check lists every formula and value.

40
00:02:14,064 --> 00:02:18,134
This lesson fills a simple relative formula; if a later exercise

41
00:02:18,134 --> 00:02:22,203
needs one fixed tax rate cell, that requires an absolute reference

42
00:02:22,203 --> 00:02:24,423
such as a dollar-anchored cell.