WEBVTT
Kind: captions
Language: en

00:00:06.350 --> 00:00:08.780 align:start position:0%
 
Excel<00:00:07.350><c> is</c><00:00:07.529><c> intended</c><00:00:08.040><c> to</c><00:00:08.189><c> be</c><00:00:08.309><c> used</c><00:00:08.340><c> to</c>

00:00:08.780 --> 00:00:08.790 align:start position:0%
Excel is intended to be used to
 

00:00:08.790 --> 00:00:11.419 align:start position:0%
Excel is intended to be used to
calculate<00:00:09.030><c> and</c><00:00:09.630><c> analyze</c><00:00:10.429><c> numerical</c>

00:00:11.419 --> 00:00:11.429 align:start position:0%
calculate and analyze numerical
 

00:00:11.429 --> 00:00:16.779 align:start position:0%
calculate and analyze numerical
information<00:00:11.750><c> such</c><00:00:12.750><c> as</c><00:00:12.780><c> household</c><00:00:13.320><c> budgets</c>

00:00:16.779 --> 00:00:16.789 align:start position:0%
 
 

00:00:16.789 --> 00:00:29.720 align:start position:0%
 
company<00:00:17.789><c> finances</c><00:00:21.500><c> inventory</c><00:00:22.760><c> and</c><00:00:25.279><c> more</c><00:00:28.730><c> to</c>

00:00:29.720 --> 00:00:29.730 align:start position:0%
company finances inventory and more to
 

00:00:29.730 --> 00:00:32.359 align:start position:0%
company finances inventory and more to
do<00:00:29.970><c> this</c><00:00:30.240><c> you</c><00:00:30.779><c> need</c><00:00:30.990><c> to</c><00:00:31.199><c> understand</c><00:00:31.710><c> formulas</c>

00:00:32.359 --> 00:00:32.369 align:start position:0%
do this you need to understand formulas
 

00:00:32.369 --> 00:00:36.080 align:start position:0%
do this you need to understand formulas
in<00:00:32.750><c> lesson</c><00:00:33.750><c> five</c><00:00:34.020><c> we</c><00:00:34.680><c> cover</c><00:00:34.980><c> simple</c><00:00:35.550><c> formulas</c>

00:00:36.080 --> 00:00:36.090 align:start position:0%
in lesson five we cover simple formulas
 

00:00:36.090 --> 00:00:38.959 align:start position:0%
in lesson five we cover simple formulas
that<00:00:36.270><c> we</c><00:00:36.719><c> have</c><00:00:36.899><c> one</c><00:00:37.309><c> mathematical</c><00:00:38.309><c> operation</c>

00:00:38.959 --> 00:00:38.969 align:start position:0%
that we have one mathematical operation
 

00:00:38.969 --> 00:00:43.459 align:start position:0%
that we have one mathematical operation
such<00:00:39.480><c> as</c><00:00:39.629><c> two</c><00:00:39.899><c> plus</c><00:00:40.350><c> two</c><00:00:40.710><c> in</c><00:00:42.110><c> this</c><00:00:43.110><c> lesson</c>

00:00:43.459 --> 00:00:43.469 align:start position:0%
such as two plus two in this lesson
 

00:00:43.469 --> 00:00:46.970 align:start position:0%
such as two plus two in this lesson
we'll<00:00:44.129><c> discuss</c><00:00:44.390><c> complex</c><00:00:45.390><c> formulas</c><00:00:46.170><c> that</c><00:00:46.379><c> use</c>

00:00:46.970 --> 00:00:46.980 align:start position:0%
we'll discuss complex formulas that use
 

00:00:46.980 --> 00:00:50.209 align:start position:0%
we'll discuss complex formulas that use
multiple<00:00:47.539><c> mathematical</c><00:00:48.539><c> operators</c><00:00:49.110><c> and</c><00:00:49.350><c> that</c>

00:00:50.209 --> 00:00:50.219 align:start position:0%
multiple mathematical operators and that
 

00:00:50.219 --> 00:00:53.799 align:start position:0%
multiple mathematical operators and that
use<00:00:50.489><c> absolute</c><00:00:51.180><c> and</c><00:00:51.420><c> relative</c><00:00:52.219><c> references</c>

00:00:53.799 --> 00:00:53.809 align:start position:0%
use absolute and relative references
 

00:00:53.809 --> 00:00:56.569 align:start position:0%
use absolute and relative references
this<00:00:54.809><c> lesson</c><00:00:55.440><c> may</c><00:00:55.620><c> take</c><00:00:55.920><c> you</c><00:00:56.070><c> back</c><00:00:56.250><c> to</c><00:00:56.280><c> high</c>

00:00:56.569 --> 00:00:56.579 align:start position:0%
this lesson may take you back to high
 

00:00:56.579 --> 00:00:59.060 align:start position:0%
this lesson may take you back to high
school<00:00:56.879><c> math</c><00:00:57.180><c> because</c><00:00:57.660><c> in</c><00:00:57.780><c> Excel</c><00:00:58.230><c> there</c><00:00:58.890><c> are</c>

00:00:59.060 --> 00:00:59.070 align:start position:0%
school math because in Excel there are
 

00:00:59.070 --> 00:01:01.160 align:start position:0%
school math because in Excel there are
certain<00:00:59.489><c> math</c><00:00:59.760><c> rules</c><00:01:00.149><c> that</c><00:01:00.420><c> you</c><00:01:00.600><c> have</c><00:01:00.870><c> to</c>

00:01:01.160 --> 00:01:01.170 align:start position:0%
certain math rules that you have to
 

00:01:01.170 --> 00:01:07.219 align:start position:0%
certain math rules that you have to
follow<00:01:01.500><c> for</c><00:01:02.280><c> formulas</c><00:01:02.760><c> to</c><00:01:02.969><c> work</c><00:01:05.659><c> the</c><00:01:06.659><c> order</c><00:01:07.080><c> of</c>

00:01:07.219 --> 00:01:07.229 align:start position:0%
follow for formulas to work the order of
 

00:01:07.229 --> 00:01:10.010 align:start position:0%
follow for formulas to work the order of
mathematical<00:01:08.220><c> operations</c><00:01:08.340><c> is</c><00:01:09.090><c> very</c><00:01:09.540><c> very</c>

00:01:10.010 --> 00:01:10.020 align:start position:0%
mathematical operations is very very
 

00:01:10.020 --> 00:01:12.920 align:start position:0%
mathematical operations is very very
important<00:01:10.710><c> if</c><00:01:10.920><c> you</c><00:01:11.490><c> enter</c><00:01:12.090><c> a</c><00:01:12.119><c> formula</c><00:01:12.900><c> that</c>

00:01:12.920 --> 00:01:12.930 align:start position:0%
important if you enter a formula that
 

00:01:12.930 --> 00:01:15.560 align:start position:0%
important if you enter a formula that
contains<00:01:13.500><c> several</c><00:01:13.950><c> operations</c><00:01:14.880><c> like</c>

00:01:15.560 --> 00:01:15.570 align:start position:0%
contains several operations like
 

00:01:15.570 --> 00:01:18.530 align:start position:0%
contains several operations like
addition<00:01:15.810><c> subtraction</c><00:01:16.400><c> multiplication</c><00:01:17.540><c> and</c>

00:01:18.530 --> 00:01:18.540 align:start position:0%
addition subtraction multiplication and
 

00:01:18.540 --> 00:01:21.020 align:start position:0%
addition subtraction multiplication and
division<00:01:18.979><c> Excel</c><00:01:19.979><c> knows</c><00:01:20.280><c> to</c><00:01:20.520><c> work</c><00:01:20.700><c> these</c>

00:01:21.020 --> 00:01:21.030 align:start position:0%
division Excel knows to work these
 

00:01:21.030 --> 00:01:25.429 align:start position:0%
division Excel knows to work these
operations<00:01:21.810><c> in</c><00:01:21.990><c> a</c><00:01:22.080><c> specific</c><00:01:22.320><c> order</c><00:01:24.259><c> first</c><00:01:25.259><c> in</c>

00:01:25.429 --> 00:01:25.439 align:start position:0%
operations in a specific order first in
 

00:01:25.439 --> 00:01:28.580 align:start position:0%
operations in a specific order first in
that<00:01:25.590><c> order</c><00:01:25.830><c> is</c><00:01:26.130><c> parenthesis</c><00:01:27.590><c> operations</c>

00:01:28.580 --> 00:01:28.590 align:start position:0%
that order is parenthesis operations
 

00:01:28.590 --> 00:01:30.560 align:start position:0%
that order is parenthesis operations
that<00:01:28.770><c> are</c><00:01:28.920><c> enclosed</c><00:01:29.369><c> in</c><00:01:29.579><c> parentheses</c><00:01:30.270><c> are</c>

00:01:30.560 --> 00:01:30.570 align:start position:0%
that are enclosed in parentheses are
 

00:01:30.570 --> 00:01:36.789 align:start position:0%
that are enclosed in parentheses are
completed<00:01:31.290><c> first</c><00:01:32.869><c> next</c><00:01:33.869><c> we</c><00:01:34.020><c> have</c><00:01:34.430><c> exponents</c>

00:01:36.789 --> 00:01:36.799 align:start position:0%
completed first next we have exponents
 

00:01:36.799 --> 00:01:39.859 align:start position:0%
completed first next we have exponents
calculations<00:01:37.799><c> that</c><00:01:38.009><c> involve</c><00:01:38.400><c> exponents</c><00:01:39.390><c> such</c>

00:01:39.859 --> 00:01:39.869 align:start position:0%
calculations that involve exponents such
 

00:01:39.869 --> 00:01:43.370 align:start position:0%
calculations that involve exponents such
as<00:01:40.049><c> two</c><00:01:40.409><c> to</c><00:01:40.829><c> the</c><00:01:40.950><c> second</c><00:01:41.369><c> power</c><00:01:41.570><c> are</c><00:01:42.570><c> completed</c>

00:01:43.370 --> 00:01:43.380 align:start position:0%
as two to the second power are completed
 

00:01:43.380 --> 00:01:46.310 align:start position:0%
as two to the second power are completed
next<00:01:43.860><c> I</c><00:01:44.090><c> would</c><00:01:45.090><c> guess</c><00:01:45.479><c> that</c><00:01:45.509><c> most</c><00:01:45.750><c> of</c><00:01:46.229><c> the</c>

00:01:46.310 --> 00:01:46.320 align:start position:0%
next I would guess that most of the
 

00:01:46.320 --> 00:01:48.679 align:start position:0%
next I would guess that most of the
spreadsheets<00:01:46.950><c> you</c><00:01:47.100><c> work</c><00:01:47.399><c> with</c><00:01:47.700><c> will</c><00:01:48.030><c> not</c><00:01:48.060><c> use</c>

00:01:48.679 --> 00:01:48.689 align:start position:0%
spreadsheets you work with will not use
 

00:01:48.689 --> 00:01:50.990 align:start position:0%
spreadsheets you work with will not use
exponents<00:01:49.439><c> but</c><00:01:49.619><c> this</c><00:01:50.189><c> is</c><00:01:50.340><c> part</c><00:01:50.610><c> of</c><00:01:50.670><c> the</c><00:01:50.790><c> basic</c>

00:01:50.990 --> 00:01:51.000 align:start position:0%
exponents but this is part of the basic
 

00:01:51.000 --> 00:01:52.819 align:start position:0%
exponents but this is part of the basic
mathematical<00:01:51.390><c> order</c><00:01:52.110><c> so</c><00:01:52.380><c> it's</c><00:01:52.619><c> worth</c>

00:01:52.819 --> 00:01:52.829 align:start position:0%
mathematical order so it's worth
 

00:01:52.829 --> 00:01:56.959 align:start position:0%
mathematical order so it's worth
mentioning<00:01:54.590><c> the</c><00:01:55.590><c> next</c><00:01:56.040><c> steps</c><00:01:56.310><c> in</c><00:01:56.579><c> the</c><00:01:56.759><c> order</c>

00:01:56.959 --> 00:01:56.969 align:start position:0%
mentioning the next steps in the order
 

00:01:56.969 --> 00:02:04.969 align:start position:0%
mentioning the next steps in the order
are<00:01:57.560><c> multiplication</c><00:01:58.560><c> and</c><00:02:00.860><c> division</c><00:02:03.979><c> these</c>

00:02:04.969 --> 00:02:04.979 align:start position:0%
are multiplication and division these
 

00:02:04.979 --> 00:02:06.740 align:start position:0%
are multiplication and division these
two<00:02:05.280><c> operations</c><00:02:05.759><c> are</c><00:02:06.149><c> considered</c><00:02:06.600><c> to</c><00:02:06.719><c> be</c>

00:02:06.740 --> 00:02:06.750 align:start position:0%
two operations are considered to be
 

00:02:06.750 --> 00:02:09.770 align:start position:0%
two operations are considered to be
equal<00:02:07.290><c> or</c><00:02:07.530><c> at</c><00:02:07.920><c> the</c><00:02:08.039><c> same</c><00:02:08.250><c> level</c><00:02:08.729><c> this</c><00:02:09.420><c> means</c>

00:02:09.770 --> 00:02:09.780 align:start position:0%
equal or at the same level this means
 

00:02:09.780 --> 00:02:11.930 align:start position:0%
equal or at the same level this means
that<00:02:09.959><c> if</c><00:02:10.140><c> you</c><00:02:10.289><c> have</c><00:02:10.319><c> a</c><00:02:10.470><c> formula</c><00:02:10.950><c> with</c><00:02:11.400><c> both</c><00:02:11.700><c> a</c>

00:02:11.930 --> 00:02:11.940 align:start position:0%
that if you have a formula with both a
 

00:02:11.940 --> 00:02:13.080 align:start position:0%
that if you have a formula with both a
multiplication

00:02:13.080 --> 00:02:13.090 align:start position:0%
multiplication
 

00:02:13.090 --> 00:02:15.630 align:start position:0%
multiplication
and<00:02:13.180><c> a</c><00:02:13.390><c> division</c><00:02:13.810><c> sign</c><00:02:14.080><c> Excel</c><00:02:15.040><c> will</c><00:02:15.250><c> read</c><00:02:15.489><c> the</c>

00:02:15.630 --> 00:02:15.640 align:start position:0%
and a division sign Excel will read the
 

00:02:15.640 --> 00:02:18.900 align:start position:0%
and a division sign Excel will read the
formula<00:02:16.120><c> from</c><00:02:16.330><c> left</c><00:02:16.720><c> to</c><00:02:17.020><c> right</c><00:02:17.530><c> and</c><00:02:17.920><c> perform</c>

00:02:18.900 --> 00:02:18.910 align:start position:0%
formula from left to right and perform
 

00:02:18.910 --> 00:02:22.880 align:start position:0%
formula from left to right and perform
whichever<00:02:19.870><c> operation</c><00:02:20.560><c> comes</c><00:02:20.770><c> first</c><00:02:21.160><c> and</c>

00:02:22.880 --> 00:02:22.890 align:start position:0%
whichever operation comes first and
 

00:02:22.890 --> 00:02:27.860 align:start position:0%
whichever operation comes first and
finally<00:02:23.890><c> we</c><00:02:24.250><c> have</c><00:02:24.520><c> addition</c><00:02:25.300><c> and</c><00:02:26.340><c> subtraction</c>

00:02:27.860 --> 00:02:27.870 align:start position:0%
finally we have addition and subtraction
 

00:02:27.870 --> 00:02:30.240 align:start position:0%
finally we have addition and subtraction
these<00:02:28.870><c> two</c><00:02:29.110><c> operations</c><00:02:29.530><c> are</c><00:02:29.830><c> considered</c>

00:02:30.240 --> 00:02:30.250 align:start position:0%
these two operations are considered
 

00:02:30.250 --> 00:02:32.370 align:start position:0%
these two operations are considered
equal<00:02:30.640><c> light</c><00:02:31.060><c> multiplication</c><00:02:31.780><c> and</c><00:02:31.900><c> division</c>

00:02:32.370 --> 00:02:32.380 align:start position:0%
equal light multiplication and division
 

00:02:32.380 --> 00:02:35.040 align:start position:0%
equal light multiplication and division
so<00:02:32.920><c> Excel</c><00:02:33.340><c> will</c><00:02:33.580><c> read</c><00:02:33.730><c> the</c><00:02:33.880><c> formula</c><00:02:34.209><c> from</c><00:02:34.750><c> left</c>

00:02:35.040 --> 00:02:35.050 align:start position:0%
so Excel will read the formula from left
 

00:02:35.050 --> 00:02:38.430 align:start position:0%
so Excel will read the formula from left
to<00:02:35.349><c> right</c><00:02:35.709><c> and</c><00:02:36.370><c> perform</c><00:02:37.060><c> whichever</c><00:02:37.750><c> operation</c>

00:02:38.430 --> 00:02:38.440 align:start position:0%
to right and perform whichever operation
 

00:02:38.440 --> 00:02:45.780 align:start position:0%
to right and perform whichever operation
comes<00:02:38.680><c> first</c><00:02:39.130><c> a</c><00:02:43.830><c> mnemonic</c><00:02:44.830><c> that</c><00:02:45.250><c> can</c><00:02:45.370><c> help</c><00:02:45.640><c> you</c>

00:02:45.780 --> 00:02:45.790 align:start position:0%
comes first a mnemonic that can help you
 

00:02:45.790 --> 00:02:49.259 align:start position:0%
comes first a mnemonic that can help you
remember<00:02:46.239><c> this</c><00:02:46.420><c> is</c><00:02:46.840><c> please</c><00:02:47.400><c> excuse</c><00:02:48.400><c> my</c><00:02:49.209><c> dear</c>

00:02:49.259 --> 00:02:49.269 align:start position:0%
remember this is please excuse my dear
 

00:02:49.269 --> 00:02:50.940 align:start position:0%
remember this is please excuse my dear
Aunt<00:02:49.900><c> Sally</c>

00:02:50.940 --> 00:02:50.950 align:start position:0%
Aunt Sally
 

00:02:50.950 --> 00:02:53.370 align:start position:0%
Aunt Sally
I<00:02:50.980><c> actually</c><00:02:51.760><c> remember</c><00:02:52.600><c> this</c><00:02:52.720><c> from</c><00:02:52.959><c> my</c><00:02:53.080><c> ninth</c>

00:02:53.370 --> 00:02:53.380 align:start position:0%
I actually remember this from my ninth
 

00:02:53.380 --> 00:02:54.330 align:start position:0%
I actually remember this from my ninth
grade<00:02:53.500><c> math</c><00:02:53.950><c> class</c>

00:02:54.330 --> 00:02:54.340 align:start position:0%
grade math class
 

00:02:54.340 --> 00:02:58.259 align:start position:0%
grade math class
it<00:02:55.049><c> stands</c><00:02:56.049><c> for</c><00:02:56.549><c> parentheses</c><00:02:57.549><c> exponents</c>

00:02:58.259 --> 00:02:58.269 align:start position:0%
it stands for parentheses exponents
 

00:02:58.269 --> 00:03:01.920 align:start position:0%
it stands for parentheses exponents
multiplication<00:02:58.860><c> division</c><00:02:59.880><c> addition</c><00:03:00.930><c> and</c>

00:03:01.920 --> 00:03:01.930 align:start position:0%
multiplication division addition and
 

00:03:01.930 --> 00:03:05.729 align:start position:0%
multiplication division addition and
subtraction<00:03:03.510><c> like</c><00:03:04.510><c> I</c><00:03:04.660><c> said</c><00:03:04.930><c> before</c><00:03:05.080><c> you</c>

00:03:05.729 --> 00:03:05.739 align:start position:0%
subtraction like I said before you
 

00:03:05.739 --> 00:03:07.500 align:start position:0%
subtraction like I said before you
probably<00:03:06.099><c> won't</c><00:03:06.640><c> have</c><00:03:06.910><c> to</c><00:03:07.060><c> deal</c><00:03:07.299><c> with</c>

00:03:07.500 --> 00:03:07.510 align:start position:0%
probably won't have to deal with
 

00:03:07.510 --> 00:03:09.539 align:start position:0%
probably won't have to deal with
exponents<00:03:07.989><c> but</c><00:03:08.380><c> it</c><00:03:08.530><c> will</c><00:03:08.739><c> help</c><00:03:09.130><c> you</c><00:03:09.280><c> remember</c>

00:03:09.539 --> 00:03:09.549 align:start position:0%
exponents but it will help you remember
 

00:03:09.549 --> 00:03:13.470 align:start position:0%
exponents but it will help you remember
the<00:03:09.790><c> order</c><00:03:10.000><c> of</c><00:03:10.120><c> operations</c><00:03:11.370><c> now</c><00:03:12.370><c> let's</c><00:03:13.150><c> take</c><00:03:13.450><c> a</c>

00:03:13.470 --> 00:03:13.480 align:start position:0%
the order of operations now let's take a
 

00:03:13.480 --> 00:03:15.780 align:start position:0%
the order of operations now let's take a
look<00:03:13.810><c> at</c><00:03:13.900><c> how</c><00:03:14.170><c> the</c><00:03:14.230><c> order</c><00:03:14.799><c> of</c><00:03:14.920><c> operations</c><00:03:15.549><c> will</c>

00:03:15.780 --> 00:03:15.790 align:start position:0%
look at how the order of operations will
 

00:03:15.790 --> 00:03:20.220 align:start position:0%
look at how the order of operations will
affect<00:03:16.180><c> your</c><00:03:16.660><c> Excel</c><00:03:17.109><c> formulas</c><00:03:18.900><c> let's</c><00:03:19.900><c> write</c><00:03:20.200><c> a</c>

00:03:20.220 --> 00:03:20.230 align:start position:0%
affect your Excel formulas let's write a
 

00:03:20.230 --> 00:03:24.509 align:start position:0%
affect your Excel formulas let's write a
formula<00:03:20.920><c> with</c><00:03:21.160><c> two</c><00:03:21.430><c> operations</c><00:03:22.359><c> as</c><00:03:22.890><c> always</c><00:03:23.890><c> we</c>

00:03:24.509 --> 00:03:24.519 align:start position:0%
formula with two operations as always we
 

00:03:24.519 --> 00:03:30.530 align:start position:0%
formula with two operations as always we
start<00:03:24.910><c> our</c><00:03:25.150><c> formulas</c><00:03:25.840><c> with</c><00:03:26.049><c> an</c><00:03:26.170><c> equal</c><00:03:26.530><c> sign</c>

00:03:30.530 --> 00:03:30.540 align:start position:0%
 
 

00:03:30.540 --> 00:03:33.809 align:start position:0%
 
now<00:03:31.560><c> Excel</c><00:03:32.560><c> will</c><00:03:32.769><c> follow</c><00:03:33.100><c> the</c><00:03:33.400><c> order</c><00:03:33.430><c> of</c>

00:03:33.809 --> 00:03:33.819 align:start position:0%
now Excel will follow the order of
 

00:03:33.819 --> 00:03:36.809 align:start position:0%
now Excel will follow the order of
operations<00:03:34.569><c> and</c><00:03:34.840><c> will</c><00:03:35.170><c> multiply</c><00:03:35.350><c> two</c><00:03:35.819><c> numbers</c>

00:03:36.809 --> 00:03:36.819 align:start position:0%
operations and will multiply two numbers
 

00:03:36.819 --> 00:03:45.840 align:start position:0%
operations and will multiply two numbers
and<00:03:37.120><c> then</c><00:03:37.480><c> add</c><00:03:39.359><c> so</c><00:03:40.359><c> 3</c><00:03:41.019><c> times</c><00:03:41.350><c> 2</c><00:03:42.010><c> equals</c><00:03:42.060><c> 6</c><00:03:43.060><c> and</c><00:03:44.850><c> 3</c>

00:03:45.840 --> 00:03:45.850 align:start position:0%
and then add so 3 times 2 equals 6 and 3
 

00:03:45.850 --> 00:03:50.610 align:start position:0%
and then add so 3 times 2 equals 6 and 3
plus<00:03:46.329><c> 6</c><00:03:46.750><c> equals</c><00:03:47.230><c> 9</c><00:03:47.470><c> so</c><00:03:48.690><c> I'll</c><00:03:49.690><c> just</c><00:03:49.900><c> click</c><00:03:50.170><c> enter</c>

00:03:50.610 --> 00:03:50.620 align:start position:0%
plus 6 equals 9 so I'll just click enter
 

00:03:50.620 --> 00:03:58.650 align:start position:0%
plus 6 equals 9 so I'll just click enter
and<00:03:50.650><c> see</c><00:03:53.400><c> yes</c><00:03:54.400><c> the</c><00:03:55.000><c> answer</c><00:03:55.209><c> is</c><00:03:55.540><c> 9</c><00:03:56.880><c> now</c><00:03:57.880><c> what</c><00:03:58.540><c> if</c>

00:03:58.650 --> 00:03:58.660 align:start position:0%
and see yes the answer is 9 now what if
 

00:03:58.660 --> 00:04:02.150 align:start position:0%
and see yes the answer is 9 now what if
I<00:03:58.810><c> want</c><00:03:59.109><c> Excel</c><00:03:59.650><c> to</c><00:03:59.680><c> add</c><00:04:00.040><c> 3</c><00:04:00.760><c> plus</c><00:04:01.060><c> 3</c><00:04:01.389><c> together</c>

00:04:02.150 --> 00:04:02.160 align:start position:0%
I want Excel to add 3 plus 3 together
 

00:04:02.160 --> 00:04:05.550 align:start position:0%
I want Excel to add 3 plus 3 together
before<00:04:03.160><c> multiplying</c><00:04:03.959><c> let's</c><00:04:04.959><c> recite</c><00:04:05.380><c> the</c>

00:04:05.550 --> 00:04:05.560 align:start position:0%
before multiplying let's recite the
 

00:04:05.560 --> 00:04:09.449 align:start position:0%
before multiplying let's recite the
formula<00:04:06.100><c> and</c><00:04:06.750><c> add</c><00:04:07.750><c> parentheses</c><00:04:08.109><c> around</c><00:04:08.680><c> 3</c>

00:04:09.449 --> 00:04:09.459 align:start position:0%
formula and add parentheses around 3
 

00:04:09.459 --> 00:04:14.160 align:start position:0%
formula and add parentheses around 3
plus<00:04:09.700><c> 3</c><00:04:11.760><c> following</c><00:04:12.760><c> the</c><00:04:13.090><c> order</c><00:04:13.359><c> of</c><00:04:13.480><c> operations</c>

00:04:14.160 --> 00:04:14.170 align:start position:0%
plus 3 following the order of operations
 

00:04:14.170 --> 00:04:16.289 align:start position:0%
plus 3 following the order of operations
Excel<00:04:14.920><c> will</c><00:04:15.190><c> add</c><00:04:15.400><c> the</c><00:04:15.639><c> numbers</c><00:04:16.090><c> and</c>

00:04:16.289 --> 00:04:16.299 align:start position:0%
Excel will add the numbers and
 

00:04:16.299 --> 00:04:19.379 align:start position:0%
Excel will add the numbers and
parentheses<00:04:16.870><c> first</c><00:04:17.579><c> so</c><00:04:18.579><c> we</c><00:04:18.729><c> could</c><00:04:18.880><c> have</c><00:04:19.090><c> 3</c>

00:04:19.379 --> 00:04:19.389 align:start position:0%
parentheses first so we could have 3
 

00:04:19.389 --> 00:04:22.830 align:start position:0%
parentheses first so we could have 3
plus<00:04:19.660><c> 3</c><00:04:19.900><c> equals</c><00:04:20.019><c> 6</c><00:04:20.680><c> and</c><00:04:21.240><c> then</c><00:04:22.240><c> multiply</c><00:04:22.780><c> the</c>

00:04:22.830 --> 00:04:22.840 align:start position:0%
plus 3 equals 6 and then multiply the
 

00:04:22.840 --> 00:04:27.390 align:start position:0%
plus 3 equals 6 and then multiply the
number<00:04:23.320><c> times</c><00:04:23.590><c> 2</c><00:04:23.979><c> to</c><00:04:24.880><c> equal</c><00:04:25.060><c> 12</c><00:04:25.539><c> let's</c><00:04:26.530><c> check</c>

00:04:27.390 --> 00:04:27.400 align:start position:0%
number times 2 to equal 12 let's check
 

00:04:27.400 --> 00:04:31.450 align:start position:0%
number times 2 to equal 12 let's check
and<00:04:28.750><c> we</c><00:04:29.750><c> can</c><00:04:29.930><c> see</c><00:04:30.169><c> that</c><00:04:30.380><c> Excel</c><00:04:30.530><c> followed</c><00:04:31.340><c> the</c>

00:04:31.450 --> 00:04:31.460 align:start position:0%
and we can see that Excel followed the
 

00:04:31.460 --> 00:04:36.430 align:start position:0%
and we can see that Excel followed the
order<00:04:31.729><c> of</c><00:04:31.820><c> operations</c><00:04:34.900><c> before</c><00:04:35.900><c> moving</c><00:04:36.139><c> on</c>

00:04:36.430 --> 00:04:36.440 align:start position:0%
order of operations before moving on
 

00:04:36.440 --> 00:04:38.740 align:start position:0%
order of operations before moving on
let's<00:04:36.800><c> take</c><00:04:37.340><c> a</c><00:04:37.400><c> look</c><00:04:37.729><c> at</c><00:04:37.850><c> some</c><00:04:38.000><c> formulas</c><00:04:38.539><c> to</c>

00:04:38.740 --> 00:04:38.750 align:start position:0%
let's take a look at some formulas to
 

00:04:38.750 --> 00:04:40.600 align:start position:0%
let's take a look at some formulas to
make<00:04:38.930><c> sure</c><00:04:39.259><c> you</c><00:04:39.500><c> really</c><00:04:39.860><c> understand</c><00:04:40.490><c> the</c>

00:04:40.600 --> 00:04:40.610 align:start position:0%
make sure you really understand the
 

00:04:40.610 --> 00:04:43.480 align:start position:0%
make sure you really understand the
order<00:04:40.940><c> of</c><00:04:41.030><c> operations</c><00:04:41.660><c> which</c><00:04:42.470><c> Excel</c><00:04:42.919><c> uses</c><00:04:43.370><c> to</c>

00:04:43.480 --> 00:04:43.490 align:start position:0%
order of operations which Excel uses to
 

00:04:43.490 --> 00:04:46.570 align:start position:0%
order of operations which Excel uses to
calculate<00:04:43.699><c> answers</c><00:04:44.710><c> you</c><00:04:45.710><c> really</c><00:04:46.070><c> do</c><00:04:46.280><c> have</c><00:04:46.520><c> to</c>

00:04:46.570 --> 00:04:46.580 align:start position:0%
calculate answers you really do have to
 

00:04:46.580 --> 00:04:48.310 align:start position:0%
calculate answers you really do have to
understand<00:04:47.300><c> this</c><00:04:47.509><c> so</c><00:04:47.690><c> that</c><00:04:47.840><c> you</c><00:04:47.990><c> can</c><00:04:48.020><c> write</c>

00:04:48.310 --> 00:04:48.320 align:start position:0%
understand this so that you can write
 

00:04:48.320 --> 00:04:52.450 align:start position:0%
understand this so that you can write
formulas<00:04:48.830><c> correctly</c><00:04:49.750><c> we</c><00:04:50.750><c> will</c><00:04:50.960><c> multiply</c><00:04:51.460><c> four</c>

00:04:52.450 --> 00:04:52.460 align:start position:0%
formulas correctly we will multiply four
 

00:04:52.460 --> 00:04:55.870 align:start position:0%
formulas correctly we will multiply four
times<00:04:52.699><c> two</c><00:04:53.560><c> before</c><00:04:54.560><c> performing</c><00:04:55.220><c> the</c><00:04:55.340><c> division</c>

00:04:55.870 --> 00:04:55.880 align:start position:0%
times two before performing the division
 

00:04:55.880 --> 00:04:57.969 align:start position:0%
times two before performing the division
operation<00:04:56.380><c> because</c><00:04:57.380><c> the</c><00:04:57.530><c> multiplication</c>

00:04:57.969 --> 00:04:57.979 align:start position:0%
operation because the multiplication
 

00:04:57.979 --> 00:05:03.779 align:start position:0%
operation because the multiplication
sign<00:04:58.610><c> it</c><00:04:59.030><c> comes</c><00:04:59.300><c> before</c><00:04:59.570><c> the</c><00:05:00.350><c> division</c><00:05:00.680><c> sign</c>

00:05:03.779 --> 00:05:03.789 align:start position:0%
 
 

00:05:03.789 --> 00:05:08.260 align:start position:0%
 
the<00:05:04.789><c> answer</c><00:05:05.000><c> is</c><00:05:05.479><c> two</c><00:05:06.460><c> what</c><00:05:07.460><c> about</c><00:05:07.580><c> this</c><00:05:07.850><c> one</c>

00:05:08.260 --> 00:05:08.270 align:start position:0%
the answer is two what about this one
 

00:05:08.270 --> 00:05:13.270 align:start position:0%
the answer is two what about this one
we'll<00:05:08.990><c> divide</c><00:05:09.380><c> 4</c><00:05:10.160><c> by</c><00:05:10.430><c> two</c><00:05:11.650><c> before</c><00:05:12.650><c> performing</c>

00:05:13.270 --> 00:05:13.280 align:start position:0%
we'll divide 4 by two before performing
 

00:05:13.280 --> 00:05:15.580 align:start position:0%
we'll divide 4 by two before performing
the<00:05:13.430><c> multiplication</c><00:05:13.750><c> operation</c><00:05:14.750><c> because</c><00:05:15.560><c> the</c>

00:05:15.580 --> 00:05:15.590 align:start position:0%
the multiplication operation because the
 

00:05:15.590 --> 00:05:17.560 align:start position:0%
the multiplication operation because the
division<00:05:16.190><c> sign</c><00:05:16.370><c> comes</c><00:05:16.970><c> before</c><00:05:17.449><c> the</c>

00:05:17.560 --> 00:05:17.570 align:start position:0%
division sign comes before the
 

00:05:17.570 --> 00:05:23.850 align:start position:0%
division sign comes before the
multiplication<00:05:17.840><c> sign</c><00:05:19.360><c> the</c><00:05:20.360><c> answer</c><00:05:20.570><c> is</c><00:05:21.139><c> eight</c>

00:05:23.850 --> 00:05:23.860 align:start position:0%
 
 

00:05:23.860 --> 00:05:26.650 align:start position:0%
 
now<00:05:24.860><c> let's</c><00:05:25.190><c> add</c><00:05:25.370><c> parentheses</c><00:05:25.669><c> and</c><00:05:26.360><c> see</c><00:05:26.509><c> how</c>

00:05:26.650 --> 00:05:26.660 align:start position:0%
now let's add parentheses and see how
 

00:05:26.660 --> 00:05:29.529 align:start position:0%
now let's add parentheses and see how
that<00:05:26.840><c> changes</c><00:05:27.199><c> the</c><00:05:27.349><c> problem</c><00:05:28.120><c> we'll</c><00:05:29.120><c> need</c><00:05:29.360><c> to</c>

00:05:29.529 --> 00:05:29.539 align:start position:0%
that changes the problem we'll need to
 

00:05:29.539 --> 00:05:32.020 align:start position:0%
that changes the problem we'll need to
perform<00:05:29.960><c> the</c><00:05:30.080><c> operation</c><00:05:30.680><c> in</c><00:05:30.740><c> parentheses</c><00:05:31.430><c> two</c>

00:05:32.020 --> 00:05:32.030 align:start position:0%
perform the operation in parentheses two
 

00:05:32.030 --> 00:05:36.400 align:start position:0%
perform the operation in parentheses two
times<00:05:32.389><c> four</c><00:05:32.919><c> first</c><00:05:33.919><c> and</c><00:05:34.280><c> divide</c><00:05:35.120><c> four</c><00:05:35.810><c> by</c><00:05:36.349><c> this</c>

00:05:36.400 --> 00:05:36.410 align:start position:0%
times four first and divide four by this
 

00:05:36.410 --> 00:05:38.100 align:start position:0%
times four first and divide four by this
result

00:05:38.100 --> 00:05:38.110 align:start position:0%
result
 

00:05:38.110 --> 00:05:44.129 align:start position:0%
result
the<00:05:39.110><c> answer</c><00:05:39.530><c> is</c><00:05:39.740><c> 0.5</c><00:05:41.889><c> what</c><00:05:42.889><c> about</c><00:05:43.099><c> this</c><00:05:43.280><c> one</c>

00:05:44.129 --> 00:05:44.139 align:start position:0%
the answer is 0.5 what about this one
 

00:05:44.139 --> 00:05:47.649 align:start position:0%
the answer is 0.5 what about this one
multiply<00:05:45.139><c> two</c><00:05:45.560><c> times</c><00:05:45.889><c> four</c><00:05:46.659><c> before</c>

00:05:47.649 --> 00:05:47.659 align:start position:0%
multiply two times four before
 

00:05:47.659 --> 00:05:49.719 align:start position:0%
multiply two times four before
performing<00:05:48.320><c> the</c><00:05:48.349><c> subtraction</c><00:05:48.919><c> operation</c>

00:05:49.719 --> 00:05:49.729 align:start position:0%
performing the subtraction operation
 

00:05:49.729 --> 00:05:52.750 align:start position:0%
performing the subtraction operation
because<00:05:50.570><c> a</c><00:05:50.599><c> multiplication</c><00:05:51.409><c> sign</c><00:05:51.860><c> is</c><00:05:52.310><c> of</c><00:05:52.639><c> a</c>

00:05:52.750 --> 00:05:52.760 align:start position:0%
because a multiplication sign is of a
 

00:05:52.760 --> 00:05:56.010 align:start position:0%
because a multiplication sign is of a
higher<00:05:53.060><c> order</c><00:05:53.539><c> than</c><00:05:53.900><c> the</c><00:05:54.289><c> subtraction</c><00:05:54.889><c> sign</c>

00:05:56.010 --> 00:05:56.020 align:start position:0%
higher order than the subtraction sign
 

00:05:56.020 --> 00:06:03.279 align:start position:0%
higher order than the subtraction sign
the<00:05:57.020><c> answer</c><00:05:57.229><c> is</c><00:05:57.620><c> negative</c><00:05:58.159><c> four</c><00:06:02.080><c> now</c><00:06:03.080><c> that</c>

00:06:03.279 --> 00:06:03.289 align:start position:0%
the answer is negative four now that
 

00:06:03.289 --> 00:06:04.960 align:start position:0%
the answer is negative four now that
we've<00:06:03.409><c> covered</c><00:06:03.680><c> the</c><00:06:03.919><c> order</c><00:06:04.220><c> of</c><00:06:04.310><c> operations</c>

00:06:04.960 --> 00:06:04.970 align:start position:0%
we've covered the order of operations
 

00:06:04.970 --> 00:06:07.689 align:start position:0%
we've covered the order of operations
and<00:06:05.240><c> written</c><00:06:05.810><c> a</c><00:06:05.900><c> few</c><00:06:06.050><c> formulas</c><00:06:06.620><c> let's</c><00:06:07.250><c> see</c><00:06:07.550><c> how</c>

00:06:07.689 --> 00:06:07.699 align:start position:0%
and written a few formulas let's see how
 

00:06:07.699 --> 00:06:09.930 align:start position:0%
and written a few formulas let's see how
it<00:06:07.849><c> works</c><00:06:08.180><c> in</c><00:06:08.360><c> a</c><00:06:08.419><c> spreadsheet</c><00:06:08.780><c> using</c><00:06:09.530><c> cell</c>

00:06:09.930 --> 00:06:09.940 align:start position:0%
it works in a spreadsheet using cell
 

00:06:09.940 --> 00:06:16.000 align:start position:0%
it works in a spreadsheet using cell
references<00:06:10.940><c> instead</c><00:06:11.840><c> of</c><00:06:11.990><c> numbers</c><00:06:12.380><c> a</c><00:06:15.010><c> cell</c>

00:06:16.000 --> 00:06:16.010 align:start position:0%
references instead of numbers a cell
 

00:06:16.010 --> 00:06:19.089 align:start position:0%
references instead of numbers a cell
reference<00:06:16.370><c> or</c><00:06:16.909><c> cell</c><00:06:17.539><c> address</c><00:06:18.139><c> is</c><00:06:18.380><c> the</c><00:06:18.830><c> name</c><00:06:19.070><c> of</c>

00:06:19.089 --> 00:06:19.099 align:start position:0%
reference or cell address is the name of
 

00:06:19.099 --> 00:06:22.480 align:start position:0%
reference or cell address is the name of
the<00:06:19.400><c> cell</c><00:06:19.639><c> based</c><00:06:20.150><c> on</c><00:06:20.360><c> its</c><00:06:20.570><c> location</c><00:06:21.070><c> this</c><00:06:22.070><c> cell</c>

00:06:22.480 --> 00:06:22.490 align:start position:0%
the cell based on its location this cell
 

00:06:22.490 --> 00:06:26.649 align:start position:0%
the cell based on its location this cell
is<00:06:22.729><c> where</c><00:06:22.880><c> column</c><00:06:23.389><c> G</c><00:06:23.900><c> and</c><00:06:24.169><c> row</c><00:06:25.070><c> six</c><00:06:25.659><c> intersect</c>

00:06:26.649 --> 00:06:26.659 align:start position:0%
is where column G and row six intersect
 

00:06:26.659 --> 00:06:29.740 align:start position:0%
is where column G and row six intersect
so<00:06:27.590><c> the</c><00:06:27.740><c> cell</c><00:06:27.979><c> reference</c><00:06:28.550><c> or</c><00:06:28.760><c> cell</c><00:06:29.030><c> address</c><00:06:29.510><c> is</c>

00:06:29.740 --> 00:06:29.750 align:start position:0%
so the cell reference or cell address is
 

00:06:29.750 --> 00:06:34.330 align:start position:0%
so the cell reference or cell address is
G<00:06:30.409><c> six</c><00:06:31.990><c> now</c><00:06:32.990><c> if</c><00:06:33.139><c> you're</c><00:06:33.320><c> ever</c><00:06:33.530><c> unsure</c><00:06:33.860><c> about</c>

00:06:34.330 --> 00:06:34.340 align:start position:0%
G six now if you're ever unsure about
 

00:06:34.340 --> 00:06:36.519 align:start position:0%
G six now if you're ever unsure about
the<00:06:34.580><c> cell</c><00:06:34.820><c> address</c><00:06:35.029><c> you</c><00:06:35.690><c> can</c><00:06:35.840><c> find</c><00:06:36.169><c> it</c><00:06:36.349><c> in</c><00:06:36.440><c> the</c>

00:06:36.519 --> 00:06:36.529 align:start position:0%
the cell address you can find it in the
 

00:06:36.529 --> 00:06:39.159 align:start position:0%
the cell address you can find it in the
name<00:06:36.770><c> box</c><00:06:37.099><c> which</c><00:06:38.000><c> is</c><00:06:38.150><c> to</c><00:06:38.300><c> the</c><00:06:38.330><c> left</c><00:06:38.450><c> of</c><00:06:39.050><c> the</c>

00:06:39.159 --> 00:06:39.169 align:start position:0%
name box which is to the left of the
 

00:06:39.169 --> 00:06:42.839 align:start position:0%
name box which is to the left of the
formula<00:06:39.500><c> bar</c>

00:06:42.839 --> 00:06:42.849 align:start position:0%
 
 

00:06:42.849 --> 00:06:45.820 align:start position:0%
 
let's<00:06:43.849><c> say</c><00:06:44.120><c> we</c><00:06:44.330><c> want</c><00:06:44.569><c> to</c><00:06:44.629><c> calculate</c><00:06:44.900><c> how</c><00:06:45.530><c> much</c>

00:06:45.820 --> 00:06:45.830 align:start position:0%
let's say we want to calculate how much
 

00:06:45.830 --> 00:06:49.059 align:start position:0%
let's say we want to calculate how much
I'm<00:06:46.069><c> spending</c><00:06:46.580><c> per</c><00:06:46.789><c> bowl</c><00:06:47.770><c> let's</c><00:06:48.770><c> write</c><00:06:49.039><c> a</c>

00:06:49.059 --> 00:06:49.069 align:start position:0%
I'm spending per bowl let's write a
 

00:06:49.069 --> 00:06:54.249 align:start position:0%
I'm spending per bowl let's write a
formula<00:06:49.610><c> here</c><00:06:49.639><c> in</c><00:06:50.150><c> h6</c><00:06:51.050><c> and</c><00:06:52.449><c> we'll</c><00:06:53.449><c> just</c><00:06:53.750><c> delete</c>

00:06:54.249 --> 00:06:54.259 align:start position:0%
formula here in h6 and we'll just delete
 

00:06:54.259 --> 00:06:57.610 align:start position:0%
formula here in h6 and we'll just delete
it<00:06:54.289><c> when</c><00:06:54.560><c> we're</c><00:06:54.770><c> done</c><00:06:55.569><c> we'll</c><00:06:56.569><c> insert</c><00:06:57.050><c> an</c><00:06:57.229><c> equal</c>

00:06:57.610 --> 00:06:57.620 align:start position:0%
it when we're done we'll insert an equal
 

00:06:57.620 --> 00:07:01.089 align:start position:0%
it when we're done we'll insert an equal
sign<00:06:57.860><c> to</c><00:06:57.889><c> get</c><00:06:58.220><c> started</c><00:06:58.780><c> now</c><00:06:59.780><c> what</c><00:07:00.590><c> do</c><00:07:00.770><c> we</c><00:07:00.889><c> need</c>

00:07:01.089 --> 00:07:01.099 align:start position:0%
sign to get started now what do we need
 

00:07:01.099 --> 00:07:03.939 align:start position:0%
sign to get started now what do we need
to<00:07:01.280><c> do</c><00:07:01.460><c> to</c><00:07:01.610><c> calculate</c><00:07:01.819><c> this</c><00:07:02.620><c> since</c><00:07:03.620><c> we</c><00:07:03.770><c> only</c>

00:07:03.939 --> 00:07:03.949 align:start position:0%
to do to calculate this since we only
 

00:07:03.949 --> 00:07:07.480 align:start position:0%
to do to calculate this since we only
have<00:07:04.069><c> one</c><00:07:04.310><c> case</c><00:07:05.180><c> each</c><00:07:05.870><c> of</c><00:07:06.409><c> the</c><00:07:06.800><c> small</c><00:07:07.159><c> and</c>

00:07:07.480 --> 00:07:07.490 align:start position:0%
have one case each of the small and
 

00:07:07.490 --> 00:07:10.480 align:start position:0%
have one case each of the small and
regular<00:07:08.389><c> bowls</c><00:07:08.659><c> we</c><00:07:09.470><c> just</c><00:07:09.500><c> need</c><00:07:09.889><c> to</c><00:07:10.039><c> add</c><00:07:10.159><c> the</c>

00:07:10.480 --> 00:07:10.490 align:start position:0%
regular bowls we just need to add the
 

00:07:10.490 --> 00:07:13.210 align:start position:0%
regular bowls we just need to add the
tool<00:07:10.759><c> bowl</c><00:07:11.120><c> amounts</c><00:07:11.659><c> together</c><00:07:12.020><c> to</c><00:07:12.680><c> calculate</c>

00:07:13.210 --> 00:07:13.220 align:start position:0%
tool bowl amounts together to calculate
 

00:07:13.220 --> 00:07:17.230 align:start position:0%
tool bowl amounts together to calculate
how<00:07:13.550><c> much</c><00:07:13.849><c> we've</c><00:07:14.150><c> spent</c><00:07:14.389><c> on</c><00:07:14.840><c> bowls</c><00:07:15.819><c> to</c><00:07:16.819><c> do</c><00:07:17.030><c> this</c>

00:07:17.230 --> 00:07:17.240 align:start position:0%
how much we've spent on bowls to do this
 

00:07:17.240 --> 00:07:22.320 align:start position:0%
how much we've spent on bowls to do this
using<00:07:17.539><c> cell</c><00:07:17.900><c> references</c><00:07:18.560><c> we'll</c><00:07:19.099><c> select</c><00:07:19.340><c> G</c><00:07:20.060><c> 6</c>

00:07:22.320 --> 00:07:22.330 align:start position:0%
using cell references we'll select G 6
 

00:07:22.330 --> 00:07:27.010 align:start position:0%
using cell references we'll select G 6
type<00:07:23.330><c> an</c><00:07:23.539><c> addition</c><00:07:23.990><c> sign</c><00:07:24.199><c> and</c><00:07:24.970><c> then</c><00:07:25.970><c> select</c><00:07:26.479><c> G</c>

00:07:27.010 --> 00:07:27.020 align:start position:0%
type an addition sign and then select G
 

00:07:27.020 --> 00:07:30.790 align:start position:0%
type an addition sign and then select G
7<00:07:27.699><c> to</c><00:07:28.699><c> figure</c><00:07:29.090><c> out</c><00:07:29.300><c> how</c><00:07:29.690><c> much</c><00:07:29.990><c> we</c><00:07:30.199><c> paid</c><00:07:30.440><c> per</c>

00:07:30.790 --> 00:07:30.800 align:start position:0%
7 to figure out how much we paid per
 

00:07:30.800 --> 00:07:35.559 align:start position:0%
7 to figure out how much we paid per
Bowl<00:07:31.039><c> we'll</c><00:07:31.849><c> need</c><00:07:32.060><c> to</c><00:07:32.270><c> divide</c><00:07:34.120><c> by</c><00:07:35.120><c> the</c><00:07:35.180><c> total</c>

00:07:35.559 --> 00:07:35.569 align:start position:0%
Bowl we'll need to divide by the total
 

00:07:35.569 --> 00:07:39.640 align:start position:0%
Bowl we'll need to divide by the total
amount<00:07:36.110><c> of</c><00:07:36.289><c> bowls</c><00:07:36.590><c> that</c><00:07:36.919><c> we</c><00:07:37.069><c> have</c><00:07:38.650><c> to</c>

00:07:39.640 --> 00:07:39.650 align:start position:0%
amount of bowls that we have to
 

00:07:39.650 --> 00:07:42.909 align:start position:0%
amount of bowls that we have to
calculate<00:07:40.219><c> how</c><00:07:40.520><c> many</c><00:07:40.759><c> bowls</c><00:07:41.090><c> we</c><00:07:41.330><c> have</c><00:07:41.919><c> we'll</c>

00:07:42.909 --> 00:07:42.919 align:start position:0%
calculate how many bowls we have we'll
 

00:07:42.919 --> 00:07:51.640 align:start position:0%
calculate how many bowls we have we'll
need<00:07:43.219><c> to</c><00:07:43.430><c> add</c><00:07:43.669><c> cell</c><00:07:44.210><c> d6</c><00:07:44.960><c> and</c><00:07:45.319><c> d7</c><00:07:49.659><c> now</c><00:07:50.659><c> can</c><00:07:51.469><c> you</c>

00:07:51.640 --> 00:07:51.650 align:start position:0%
need to add cell d6 and d7 now can you
 

00:07:51.650 --> 00:07:57.640 align:start position:0%
need to add cell d6 and d7 now can you
see<00:07:51.889><c> a</c><00:07:51.919><c> problem</c><00:07:52.490><c> with</c><00:07:52.639><c> this</c><00:07:52.789><c> formula</c><00:07:56.440><c> we</c><00:07:57.440><c> want</c>

00:07:57.640 --> 00:07:57.650 align:start position:0%
see a problem with this formula we want
 

00:07:57.650 --> 00:07:59.769 align:start position:0%
see a problem with this formula we want
to<00:07:57.860><c> divide</c><00:07:58.099><c> the</c><00:07:58.340><c> total</c><00:07:58.759><c> dollar</c><00:07:59.029><c> amount</c><00:07:59.539><c> we</c>

00:07:59.769 --> 00:07:59.779 align:start position:0%
to divide the total dollar amount we
 

00:07:59.779 --> 00:08:03.070 align:start position:0%
to divide the total dollar amount we
spent<00:08:00.229><c> by</c><00:08:00.919><c> the</c><00:08:00.979><c> total</c><00:08:01.550><c> number</c><00:08:01.969><c> of</c><00:08:02.000><c> bowls</c><00:08:02.449><c> so</c>

00:08:03.070 --> 00:08:03.080 align:start position:0%
spent by the total number of bowls so
 

00:08:03.080 --> 00:08:05.529 align:start position:0%
spent by the total number of bowls so
that<00:08:03.259><c> we</c><00:08:03.469><c> can</c><00:08:03.650><c> calculate</c><00:08:03.860><c> how</c><00:08:04.430><c> much</c><00:08:05.270><c> we're</c>

00:08:05.529 --> 00:08:05.539 align:start position:0%
that we can calculate how much we're
 

00:08:05.539 --> 00:08:08.290 align:start position:0%
that we can calculate how much we're
spending<00:08:05.569><c> per</c><00:08:06.229><c> bowl</c><00:08:06.469><c> does</c><00:08:07.400><c> this</c><00:08:07.610><c> formula</c><00:08:07.940><c> do</c>

00:08:08.290 --> 00:08:08.300 align:start position:0%
spending per bowl does this formula do
 

00:08:08.300 --> 00:08:12.249 align:start position:0%
spending per bowl does this formula do
that<00:08:08.479><c> for</c><00:08:08.719><c> us</c><00:08:09.190><c> no</c><00:08:10.190><c> it</c><00:08:10.610><c> really</c><00:08:10.759><c> doesn't</c><00:08:11.120><c> you</c><00:08:11.990><c> see</c>

00:08:12.249 --> 00:08:12.259 align:start position:0%
that for us no it really doesn't you see
 

00:08:12.259 --> 00:08:14.320 align:start position:0%
that for us no it really doesn't you see
with<00:08:12.650><c> the</c><00:08:12.800><c> way</c><00:08:12.979><c> the</c><00:08:13.190><c> formula</c><00:08:13.550><c> is</c><00:08:13.880><c> currently</c>

00:08:14.320 --> 00:08:14.330 align:start position:0%
with the way the formula is currently
 

00:08:14.330 --> 00:08:16.510 align:start position:0%
with the way the formula is currently
written<00:08:14.569><c> Excel</c><00:08:15.500><c> will</c><00:08:15.710><c> divide</c>

00:08:16.510 --> 00:08:16.520 align:start position:0%
written Excel will divide
 

00:08:16.520 --> 00:08:22.180 align:start position:0%
written Excel will divide
g7<00:08:17.479><c> by</c><00:08:18.250><c> d6</c><00:08:19.990><c> since</c><00:08:20.990><c> the</c><00:08:21.169><c> vision</c><00:08:21.529><c> is</c><00:08:21.650><c> completed</c>

00:08:22.180 --> 00:08:22.190 align:start position:0%
g7 by d6 since the vision is completed
 

00:08:22.190 --> 00:08:26.589 align:start position:0%
g7 by d6 since the vision is completed
before<00:08:22.449><c> addition</c><00:08:24.699><c> this</c><00:08:25.699><c> will</c><00:08:25.969><c> give</c><00:08:26.210><c> us</c><00:08:26.240><c> some</c>

00:08:26.589 --> 00:08:26.599 align:start position:0%
before addition this will give us some
 

00:08:26.599 --> 00:08:29.140 align:start position:0%
before addition this will give us some
big<00:08:27.440><c> number</c><00:08:27.889><c> that</c><00:08:28.099><c> clearly</c><00:08:28.460><c> doesn't</c><00:08:28.789><c> indicate</c>

00:08:29.140 --> 00:08:29.150 align:start position:0%
big number that clearly doesn't indicate
 

00:08:29.150 --> 00:08:34.029 align:start position:0%
big number that clearly doesn't indicate
how<00:08:29.389><c> much</c><00:08:29.930><c> we're</c><00:08:30.139><c> paying</c><00:08:30.169><c> per</c><00:08:30.680><c> bowl</c><00:08:32.770><c> let's</c><00:08:33.770><c> add</c>

00:08:34.029 --> 00:08:34.039 align:start position:0%
how much we're paying per bowl let's add
 

00:08:34.039 --> 00:08:35.949 align:start position:0%
how much we're paying per bowl let's add
some<00:08:34.310><c> parentheses</c><00:08:34.880><c> to</c><00:08:35.149><c> the</c><00:08:35.270><c> formula</c><00:08:35.750><c> so</c><00:08:35.930><c> that</c>

00:08:35.949 --> 00:08:35.959 align:start position:0%
some parentheses to the formula so that
 

00:08:35.959 --> 00:08:37.569 align:start position:0%
some parentheses to the formula so that
Excel<00:08:36.469><c> knows</c><00:08:36.770><c> to</c><00:08:36.950><c> perform</c><00:08:37.339><c> the</c><00:08:37.490><c> addition</c>

00:08:37.569 --> 00:08:37.579 align:start position:0%
Excel knows to perform the addition
 

00:08:37.579 --> 00:08:44.860 align:start position:0%
Excel knows to perform the addition
operations<00:08:38.570><c> before</c><00:08:38.810><c> it</c><00:08:39.260><c> divides</c><00:08:41.950><c> and</c><00:08:43.810><c> now</c><00:08:44.810><c> we</c>

00:08:44.860 --> 00:08:44.870 align:start position:0%
operations before it divides and now we
 

00:08:44.870 --> 00:08:47.410 align:start position:0%
operations before it divides and now we
can<00:08:45.200><c> see</c><00:08:45.410><c> that</c><00:08:45.589><c> we're</c><00:08:45.770><c> paying</c><00:08:45.980><c> about</c><00:08:46.220><c> 13</c><00:08:46.970><c> cents</c>

00:08:47.410 --> 00:08:47.420 align:start position:0%
can see that we're paying about 13 cents
 

00:08:47.420 --> 00:08:50.050 align:start position:0%
can see that we're paying about 13 cents
per<00:08:47.630><c> bowl</c><00:08:47.870><c> if</c><00:08:48.260><c> you</c><00:08:48.980><c> want</c><00:08:49.220><c> to</c><00:08:49.370><c> show</c><00:08:49.579><c> fewer</c>

00:08:50.050 --> 00:08:50.060 align:start position:0%
per bowl if you want to show fewer
 

00:08:50.060 --> 00:08:52.660 align:start position:0%
per bowl if you want to show fewer
decimal<00:08:50.720><c> places</c><00:08:50.990><c> you</c><00:08:51.770><c> can</c><00:08:51.949><c> just</c><00:08:52.160><c> click</c><00:08:52.459><c> the</c>

00:08:52.660 --> 00:08:52.670 align:start position:0%
decimal places you can just click the
 

00:08:52.670 --> 00:08:54.340 align:start position:0%
decimal places you can just click the
decrease<00:08:53.180><c> decimal</c><00:08:53.660><c> place</c><00:08:53.870><c> command</c>

00:08:54.340 --> 00:08:54.350 align:start position:0%
decrease decimal place command
 

00:08:54.350 --> 00:08:58.930 align:start position:0%
decrease decimal place command
on<00:08:54.590><c> the</c><00:08:54.710><c> Home</c><00:08:54.890><c> tab</c><00:08:54.920><c> I</c><00:08:57.520><c> think</c><00:08:58.520><c> we've</c><00:08:58.700><c> covered</c>

00:08:58.930 --> 00:08:58.940 align:start position:0%
on the Home tab I think we've covered
 

00:08:58.940 --> 00:09:01.030 align:start position:0%
on the Home tab I think we've covered
complex<00:08:59.600><c> formulas</c><00:09:00.230><c> using</c><00:09:00.620><c> the</c><00:09:00.710><c> order</c><00:09:01.010><c> of</c>

00:09:01.030 --> 00:09:01.040 align:start position:0%
complex formulas using the order of
 

00:09:01.040 --> 00:09:03.310 align:start position:0%
complex formulas using the order of
operations<00:09:01.220><c> pretty</c><00:09:02.060><c> well</c><00:09:02.300><c> so</c><00:09:02.930><c> let's</c><00:09:03.110><c> talk</c>

00:09:03.310 --> 00:09:03.320 align:start position:0%
operations pretty well so let's talk
 

00:09:03.320 --> 00:09:05.520 align:start position:0%
operations pretty well so let's talk
about<00:09:03.590><c> two</c><00:09:03.860><c> types</c><00:09:03.890><c> of</c><00:09:04.370><c> cell</c><00:09:04.640><c> references</c>

00:09:05.520 --> 00:09:05.530 align:start position:0%
about two types of cell references
 

00:09:05.530 --> 00:09:10.420 align:start position:0%
about two types of cell references
relative<00:09:06.530><c> and</c><00:09:06.800><c> absolute</c><00:09:07.540><c> references</c><00:09:09.430><c> the</c>

00:09:10.420 --> 00:09:10.430 align:start position:0%
relative and absolute references the
 

00:09:10.430 --> 00:09:15.670 align:start position:0%
relative and absolute references the
formula<00:09:11.030><c> in</c><00:09:11.210><c> this</c><00:09:11.450><c> cell</c><00:09:13.960><c> takes</c><00:09:14.960><c> the</c><00:09:15.200><c> number</c>

00:09:15.670 --> 00:09:15.680 align:start position:0%
formula in this cell takes the number
 

00:09:15.680 --> 00:09:19.540 align:start position:0%
formula in this cell takes the number
and<00:09:15.860><c> f2</c><00:09:16.670><c> and</c><00:09:17.440><c> multiplies</c><00:09:18.440><c> it</c><00:09:18.470><c> by</c><00:09:18.740><c> the</c><00:09:18.920><c> number</c>

00:09:19.540 --> 00:09:19.550 align:start position:0%
and f2 and multiplies it by the number
 

00:09:19.550 --> 00:09:24.430 align:start position:0%
and f2 and multiplies it by the number
in<00:09:19.730><c> situ</c><00:09:21.670><c> but</c><00:09:22.670><c> what</c><00:09:23.060><c> the</c><00:09:23.240><c> Excel</c><00:09:23.600><c> program</c><00:09:23.630><c> sees</c>

00:09:24.430 --> 00:09:24.440 align:start position:0%
in situ but what the Excel program sees
 

00:09:24.440 --> 00:09:26.560 align:start position:0%
in situ but what the Excel program sees
when<00:09:24.680><c> it</c><00:09:24.770><c> reads</c><00:09:25.040><c> this</c><00:09:25.280><c> formula</c><00:09:25.820><c> is</c><00:09:26.000><c> that</c><00:09:26.300><c> it</c>

00:09:26.560 --> 00:09:26.570 align:start position:0%
when it reads this formula is that it
 

00:09:26.570 --> 00:09:28.180 align:start position:0%
when it reads this formula is that it
should<00:09:26.720><c> multiply</c><00:09:27.200><c> the</c><00:09:27.260><c> value</c><00:09:27.890><c> that</c><00:09:28.040><c> appears</c>

00:09:28.180 --> 00:09:28.190 align:start position:0%
should multiply the value that appears
 

00:09:28.190 --> 00:09:32.020 align:start position:0%
should multiply the value that appears
in<00:09:28.880><c> one</c><00:09:29.120><c> cell</c><00:09:29.480><c> to</c><00:09:30.320><c> the</c><00:09:30.350><c> left</c><00:09:30.860><c> by</c><00:09:31.430><c> the</c><00:09:31.490><c> value</c>

00:09:32.020 --> 00:09:32.030 align:start position:0%
in one cell to the left by the value
 

00:09:32.030 --> 00:09:34.890 align:start position:0%
in one cell to the left by the value
that<00:09:32.210><c> appears</c><00:09:32.360><c> and</c><00:09:33.080><c> for</c><00:09:33.500><c> cells</c><00:09:33.890><c> to</c><00:09:34.520><c> the</c><00:09:34.670><c> left</c>

00:09:34.890 --> 00:09:34.900 align:start position:0%
that appears and for cells to the left
 

00:09:34.900 --> 00:09:39.880 align:start position:0%
that appears and for cells to the left
from<00:09:35.900><c> where</c><00:09:36.200><c> the</c><00:09:36.440><c> formula</c><00:09:36.920><c> appears</c><00:09:38.710><c> this</c><00:09:39.710><c> is</c>

00:09:39.880 --> 00:09:39.890 align:start position:0%
from where the formula appears this is
 

00:09:39.890 --> 00:09:43.120 align:start position:0%
from where the formula appears this is
called<00:09:40.160><c> a</c><00:09:40.370><c> relative</c><00:09:40.640><c> cell</c><00:09:41.210><c> reference</c><00:09:42.130><c> when</c>

00:09:43.120 --> 00:09:43.130 align:start position:0%
called a relative cell reference when
 

00:09:43.130 --> 00:09:45.550 align:start position:0%
called a relative cell reference when
you<00:09:43.250><c> copy</c><00:09:43.580><c> a</c><00:09:43.730><c> formula</c><00:09:44.090><c> containing</c><00:09:44.930><c> relative</c>

00:09:45.550 --> 00:09:45.560 align:start position:0%
you copy a formula containing relative
 

00:09:45.560 --> 00:09:48.220 align:start position:0%
you copy a formula containing relative
references<00:09:46.250><c> to</c><00:09:46.430><c> another</c><00:09:46.670><c> cell</c><00:09:47.000><c> the</c><00:09:47.570><c> relative</c>

00:09:48.220 --> 00:09:48.230 align:start position:0%
references to another cell the relative
 

00:09:48.230 --> 00:09:52.270 align:start position:0%
references to another cell the relative
references<00:09:48.920><c> automatically</c><00:09:49.850><c> change</c><00:09:50.770><c> so</c><00:09:51.770><c> when</c>

00:09:52.270 --> 00:09:52.280 align:start position:0%
references automatically change so when
 

00:09:52.280 --> 00:09:55.300 align:start position:0%
references automatically change so when
I<00:09:52.310><c> drag</c><00:09:52.760><c> this</c><00:09:53.210><c> formula</c><00:09:53.630><c> down</c><00:09:53.930><c> and</c><00:09:54.650><c> fill</c><00:09:55.070><c> the</c>

00:09:55.300 --> 00:09:55.310 align:start position:0%
I drag this formula down and fill the
 

00:09:55.310 --> 00:10:00.910 align:start position:0%
I drag this formula down and fill the
other<00:09:55.490><c> cells</c><00:09:55.850><c> with</c><00:09:56.210><c> it</c><00:09:58.660><c> you</c><00:09:59.660><c> won't</c><00:09:59.930><c> see</c><00:10:00.320><c> F</c><00:10:00.590><c> 2</c>

00:10:00.910 --> 00:10:00.920 align:start position:0%
other cells with it you won't see F 2
 

00:10:00.920 --> 00:10:04.660 align:start position:0%
other cells with it you won't see F 2
times<00:10:01.400><c> C</c><00:10:02.000><c> 2</c><00:10:02.260><c> you'll</c><00:10:03.260><c> see</c><00:10:03.500><c> the</c><00:10:03.650><c> new</c><00:10:03.920><c> relative</c>

00:10:04.660 --> 00:10:04.670 align:start position:0%
times C 2 you'll see the new relative
 

00:10:04.670 --> 00:10:08.290 align:start position:0%
times C 2 you'll see the new relative
references<00:10:05.300><c> so</c><00:10:06.290><c> here</c><00:10:06.680><c> in</c><00:10:06.830><c> G</c><00:10:07.100><c> 3</c><00:10:07.490><c> the</c><00:10:07.790><c> formula</c>

00:10:08.290 --> 00:10:08.300 align:start position:0%
references so here in G 3 the formula
 

00:10:08.300 --> 00:10:10.450 align:start position:0%
references so here in G 3 the formula
reads<00:10:08.570><c> the</c><00:10:08.810><c> value</c><00:10:09.230><c> in</c><00:10:09.410><c> one</c><00:10:09.680><c> cell</c><00:10:10.040><c> to</c><00:10:10.310><c> the</c><00:10:10.340><c> left</c>

00:10:10.450 --> 00:10:10.460 align:start position:0%
reads the value in one cell to the left
 

00:10:10.460 --> 00:10:13.720 align:start position:0%
reads the value in one cell to the left
times<00:10:11.450><c> a</c><00:10:11.660><c> value</c><00:10:12.080><c> that</c><00:10:12.200><c> appears</c><00:10:12.320><c> in</c><00:10:12.980><c> four</c><00:10:13.400><c> cells</c>

00:10:13.720 --> 00:10:13.730 align:start position:0%
times a value that appears in four cells
 

00:10:13.730 --> 00:10:19.060 align:start position:0%
times a value that appears in four cells
to<00:10:14.000><c> the</c><00:10:14.090><c> left</c><00:10:14.120><c> or</c><00:10:14.600><c> F</c><00:10:15.530><c> 3</c><00:10:15.980><c> times</c><00:10:16.220><c> C</c><00:10:16.670><c> 3</c><00:10:16.940><c> and</c><00:10:17.890><c> you</c><00:10:18.890><c> can</c>

00:10:19.060 --> 00:10:19.070 align:start position:0%
to the left or F 3 times C 3 and you can
 

00:10:19.070 --> 00:10:21.990 align:start position:0%
to the left or F 3 times C 3 and you can
see<00:10:19.370><c> the</c><00:10:19.580><c> same</c><00:10:19.850><c> thing</c><00:10:20.240><c> in</c><00:10:20.270><c> these</c><00:10:20.750><c> other</c><00:10:20.960><c> cells</c>

00:10:21.990 --> 00:10:22.000 align:start position:0%
see the same thing in these other cells
 

00:10:22.000 --> 00:10:24.820 align:start position:0%
see the same thing in these other cells
the<00:10:23.000><c> other</c><00:10:23.240><c> type</c><00:10:23.660><c> of</c><00:10:23.690><c> reference</c><00:10:24.050><c> is</c><00:10:24.380><c> called</c><00:10:24.650><c> an</c>

00:10:24.820 --> 00:10:24.830 align:start position:0%
the other type of reference is called an
 

00:10:24.830 --> 00:10:28.540 align:start position:0%
the other type of reference is called an
absolute<00:10:25.550><c> cell</c><00:10:26.090><c> reference</c><00:10:26.600><c> if</c><00:10:26.870><c> a</c><00:10:27.860><c> formula</c><00:10:28.430><c> is</c>

00:10:28.540 --> 00:10:28.550 align:start position:0%
absolute cell reference if a formula is
 

00:10:28.550 --> 00:10:30.910 align:start position:0%
absolute cell reference if a formula is
copied<00:10:28.790><c> to</c><00:10:29.030><c> a</c><00:10:29.180><c> different</c><00:10:29.720><c> location</c><00:10:29.930><c> the</c>

00:10:30.910 --> 00:10:30.920 align:start position:0%
copied to a different location the
 

00:10:30.920 --> 00:10:36.570 align:start position:0%
copied to a different location the
absolute<00:10:31.640><c> reference</c><00:10:32.000><c> remains</c><00:10:32.810><c> the</c><00:10:33.230><c> same</c><00:10:34.390><c> an</c>

00:10:36.570 --> 00:10:36.580 align:start position:0%
absolute reference remains the same an
 

00:10:36.580 --> 00:10:39.250 align:start position:0%
absolute reference remains the same an
absolute<00:10:37.580><c> reference</c><00:10:37.910><c> is</c><00:10:38.360><c> designated</c><00:10:39.110><c> in</c><00:10:39.230><c> the</c>

00:10:39.250 --> 00:10:39.260 align:start position:0%
absolute reference is designated in the
 

00:10:39.260 --> 00:10:42.240 align:start position:0%
absolute reference is designated in the
formula<00:10:39.950><c> by</c><00:10:40.490><c> the</c><00:10:40.550><c> addition</c><00:10:41.300><c> of</c><00:10:41.450><c> a</c><00:10:41.630><c> dollar</c><00:10:41.930><c> sign</c>

00:10:42.240 --> 00:10:42.250 align:start position:0%
formula by the addition of a dollar sign
 

00:10:42.250 --> 00:10:46.150 align:start position:0%
formula by the addition of a dollar sign
it<00:10:43.250><c> can</c><00:10:44.150><c> proceed</c><00:10:44.390><c> the</c><00:10:44.900><c> column</c><00:10:45.350><c> reference</c><00:10:45.920><c> or</c>

00:10:46.150 --> 00:10:46.160 align:start position:0%
it can proceed the column reference or
 

00:10:46.160 --> 00:10:50.260 align:start position:0%
it can proceed the column reference or
the<00:10:46.550><c> row</c><00:10:46.730><c> reference</c><00:10:47.000><c> or</c><00:10:47.570><c> both</c><00:10:47.960><c> in</c><00:10:49.270><c> this</c>

00:10:50.260 --> 00:10:50.270 align:start position:0%
the row reference or both in this
 

00:10:50.270 --> 00:10:54.910 align:start position:0%
the row reference or both in this
example<00:10:51.910><c> the</c><00:10:52.910><c> column</c><00:10:53.510><c> and</c><00:10:53.720><c> the</c><00:10:54.110><c> row</c><00:10:54.350><c> do</c><00:10:54.740><c> not</c>

00:10:54.910 --> 00:10:54.920 align:start position:0%
example the column and the row do not
 

00:10:54.920 --> 00:10:59.320 align:start position:0%
example the column and the row do not
change<00:10:55.340><c> when</c><00:10:55.760><c> copied</c><00:10:56.270><c> in</c><00:10:57.160><c> this</c><00:10:58.160><c> example</c><00:10:58.730><c> the</c>

00:10:59.320 --> 00:10:59.330 align:start position:0%
change when copied in this example the
 

00:10:59.330 --> 00:11:02.590 align:start position:0%
change when copied in this example the
row<00:10:59.720><c> does</c><00:11:00.170><c> not</c><00:11:00.380><c> change</c><00:11:00.800><c> when</c><00:11:01.220><c> copied</c><00:11:01.700><c> in</c><00:11:01.940><c> this</c>

00:11:02.590 --> 00:11:02.600 align:start position:0%
row does not change when copied in this
 

00:11:02.600 --> 00:11:05.770 align:start position:0%
row does not change when copied in this
example<00:11:03.170><c> the</c><00:11:04.070><c> column</c><00:11:04.640><c> does</c><00:11:04.850><c> not</c><00:11:05.030><c> change</c><00:11:05.330><c> when</c>

00:11:05.770 --> 00:11:05.780 align:start position:0%
example the column does not change when
 

00:11:05.780 --> 00:11:08.370 align:start position:0%
example the column does not change when
copied

00:11:08.370 --> 00:11:08.380 align:start position:0%
 
 

00:11:08.380 --> 00:11:10.690 align:start position:0%
 
let's<00:11:09.380><c> see</c><00:11:09.680><c> how</c><00:11:09.830><c> this</c><00:11:10.040><c> might</c><00:11:10.280><c> work</c><00:11:10.310><c> in</c><00:11:10.640><c> a</c>

00:11:10.690 --> 00:11:10.700 align:start position:0%
let's see how this might work in a
 

00:11:10.700 --> 00:11:14.080 align:start position:0%
let's see how this might work in a
spreadsheet<00:11:11.080><c> over</c><00:11:12.080><c> here</c><00:11:12.650><c> in</c><00:11:12.800><c> h2</c><00:11:13.340><c> let's</c><00:11:13.850><c> write</c>

00:11:14.080 --> 00:11:14.090 align:start position:0%
spreadsheet over here in h2 let's write
 

00:11:14.090 --> 00:11:16.240 align:start position:0%
spreadsheet over here in h2 let's write
a<00:11:14.120><c> formula</c><00:11:14.540><c> that</c><00:11:14.720><c> multiplies</c><00:11:14.990><c> the</c><00:11:15.680><c> inventory</c>

00:11:16.240 --> 00:11:16.250 align:start position:0%
a formula that multiplies the inventory
 

00:11:16.250 --> 00:11:19.810 align:start position:0%
a formula that multiplies the inventory
number<00:11:16.730><c> c2</c><00:11:17.600><c> if</c><00:11:17.870><c> you</c><00:11:18.770><c> want</c><00:11:19.040><c> to</c><00:11:19.190><c> create</c><00:11:19.430><c> an</c>

00:11:19.810 --> 00:11:19.820 align:start position:0%
number c2 if you want to create an
 

00:11:19.820 --> 00:11:22.150 align:start position:0%
number c2 if you want to create an
absolute<00:11:20.390><c> reference</c><00:11:20.720><c> we'll</c><00:11:21.470><c> just</c><00:11:21.710><c> add</c><00:11:21.920><c> our</c>

00:11:22.150 --> 00:11:22.160 align:start position:0%
absolute reference we'll just add our
 

00:11:22.160 --> 00:11:25.510 align:start position:0%
absolute reference we'll just add our
dollar<00:11:22.550><c> signs</c><00:11:22.970><c> before</c><00:11:23.630><c> the</c><00:11:23.780><c> C</c><00:11:24.050><c> and</c><00:11:24.370><c> before</c><00:11:25.370><c> the</c>

00:11:25.510 --> 00:11:25.520 align:start position:0%
dollar signs before the C and before the
 

00:11:25.520 --> 00:11:30.040 align:start position:0%
dollar signs before the C and before the
two<00:11:25.760><c> and</c><00:11:26.380><c> then</c><00:11:27.380><c> press</c><00:11:27.680><c> ENTER</c><00:11:28.160><c> and</c><00:11:28.600><c> we</c><00:11:29.600><c> can</c><00:11:29.780><c> see</c>

00:11:30.040 --> 00:11:30.050 align:start position:0%
two and then press ENTER and we can see
 

00:11:30.050 --> 00:11:32.620 align:start position:0%
two and then press ENTER and we can see
that<00:11:30.200><c> the</c><00:11:30.350><c> amounts</c><00:11:30.830><c> in</c><00:11:30.920><c> G</c><00:11:31.190><c> 2</c><00:11:31.370><c> and</c><00:11:31.400><c> H</c><00:11:31.880><c> 2</c><00:11:31.910><c> are</c><00:11:32.240><c> the</c>

00:11:32.620 --> 00:11:32.630 align:start position:0%
that the amounts in G 2 and H 2 are the
 

00:11:32.630 --> 00:11:35.200 align:start position:0%
that the amounts in G 2 and H 2 are the
same<00:11:32.930><c> even</c><00:11:33.470><c> though</c><00:11:33.590><c> H</c><00:11:33.830><c> 2</c><00:11:34.130><c> uses</c><00:11:34.550><c> an</c><00:11:34.670><c> absolute</c>

00:11:35.200 --> 00:11:35.210 align:start position:0%
same even though H 2 uses an absolute
 

00:11:35.210 --> 00:11:39.430 align:start position:0%
same even though H 2 uses an absolute
reference<00:11:36.220><c> so</c><00:11:37.220><c> when</c><00:11:37.790><c> I</c><00:11:37.820><c> fill</c><00:11:38.240><c> this</c><00:11:38.540><c> formula</c><00:11:39.080><c> in</c>

00:11:39.430 --> 00:11:39.440 align:start position:0%
reference so when I fill this formula in
 

00:11:39.440 --> 00:11:42.430 align:start position:0%
reference so when I fill this formula in
to<00:11:39.950><c> three</c><00:11:40.280><c> additional</c><00:11:40.760><c> cells</c><00:11:41.090><c> I</c><00:11:41.450><c> can</c><00:11:42.110><c> see</c><00:11:42.320><c> that</c>

00:11:42.430 --> 00:11:42.440 align:start position:0%
to three additional cells I can see that
 

00:11:42.440 --> 00:11:44.590 align:start position:0%
to three additional cells I can see that
the<00:11:42.590><c> numbers</c><00:11:43.130><c> don't</c><00:11:43.490><c> match</c><00:11:43.790><c> up</c><00:11:43.820><c> with</c><00:11:44.120><c> what</c>

00:11:44.590 --> 00:11:44.600 align:start position:0%
the numbers don't match up with what
 

00:11:44.600 --> 00:11:50.740 align:start position:0%
the numbers don't match up with what
appears<00:11:45.050><c> in</c><00:11:45.290><c> G</c><00:11:45.560><c> 3</c><00:11:45.890><c> 4</c><00:11:46.430><c> and</c><00:11:46.820><c> 5</c><00:11:49.060><c> this</c><00:11:50.060><c> formula</c>

00:11:50.740 --> 00:11:50.750 align:start position:0%
appears in G 3 4 and 5 this formula
 

00:11:50.750 --> 00:11:53.890 align:start position:0%
appears in G 3 4 and 5 this formula
takes<00:11:51.230><c> a</c><00:11:51.410><c> number</c><00:11:51.830><c> in</c><00:11:51.980><c> F</c><00:11:52.220><c> 3</c><00:11:52.640><c> and</c><00:11:52.870><c> multiplies</c><00:11:53.870><c> it</c>

00:11:53.890 --> 00:11:53.900 align:start position:0%
takes a number in F 3 and multiplies it
 

00:11:53.900 --> 00:11:58.000 align:start position:0%
takes a number in F 3 and multiplies it
by<00:11:54.080><c> the</c><00:11:54.230><c> number</c><00:11:54.710><c> in</c><00:11:54.740><c> C</c><00:11:55.220><c> to</c><00:11:55.810><c> the</c><00:11:56.810><c> C</c><00:11:56.840><c> 2</c><00:11:57.500><c> will</c><00:11:57.770><c> stay</c>

00:11:58.000 --> 00:11:58.010 align:start position:0%
by the number in C to the C 2 will stay
 

00:11:58.010 --> 00:12:00.610 align:start position:0%
by the number in C to the C 2 will stay
constant<00:11:58.660><c> because</c><00:11:59.660><c> of</c><00:11:59.690><c> the</c><00:11:59.930><c> dollar</c><00:12:00.230><c> signs</c>

00:12:00.610 --> 00:12:00.620 align:start position:0%
constant because of the dollar signs
 

00:12:00.620 --> 00:12:06.880 align:start position:0%
constant because of the dollar signs
which<00:12:01.490><c> make</c><00:12:01.850><c> it</c><00:12:02.000><c> an</c><00:12:02.120><c> absolute</c><00:12:02.330><c> reference</c><00:12:05.890><c> this</c>

00:12:06.880 --> 00:12:06.890 align:start position:0%
which make it an absolute reference this
 

00:12:06.890 --> 00:12:09.100 align:start position:0%
which make it an absolute reference this
spreadsheet<00:12:07.490><c> doesn't</c><00:12:08.180><c> need</c><00:12:08.360><c> these</c><00:12:08.570><c> formulas</c>

00:12:09.100 --> 00:12:09.110 align:start position:0%
spreadsheet doesn't need these formulas
 

00:12:09.110 --> 00:12:12.850 align:start position:0%
spreadsheet doesn't need these formulas
so<00:12:09.410><c> let's</c><00:12:09.950><c> just</c><00:12:10.250><c> delete</c><00:12:10.430><c> them</c><00:12:10.760><c> as</c><00:12:11.500><c> you</c><00:12:12.500><c> can</c><00:12:12.680><c> see</c>

00:12:12.850 --> 00:12:12.860 align:start position:0%
so let's just delete them as you can see
 

00:12:12.860 --> 00:12:15.460 align:start position:0%
so let's just delete them as you can see
the<00:12:13.040><c> order</c><00:12:13.250><c> of</c><00:12:13.490><c> operations</c><00:12:14.120><c> and</c><00:12:14.330><c> relative</c><00:12:15.230><c> and</c>

00:12:15.460 --> 00:12:15.470 align:start position:0%
the order of operations and relative and
 

00:12:15.470 --> 00:12:17.470 align:start position:0%
the order of operations and relative and
absolute<00:12:15.680><c> references</c><00:12:16.310><c> are</c><00:12:16.910><c> important</c><00:12:17.420><c> to</c>

00:12:17.470 --> 00:12:17.480 align:start position:0%
absolute references are important to
 

00:12:17.480 --> 00:12:20.020 align:start position:0%
absolute references are important to
understand<00:12:17.990><c> if</c><00:12:18.260><c> you</c><00:12:18.770><c> plan</c><00:12:19.010><c> on</c><00:12:19.040><c> using</c><00:12:19.190><c> formulas</c>

00:12:20.020 --> 00:12:20.030 align:start position:0%
understand if you plan on using formulas
 

00:12:20.030 --> 00:12:23.140 align:start position:0%
understand if you plan on using formulas
in<00:12:20.180><c> your</c><00:12:20.300><c> spreadsheet</c><00:12:21.760><c> spend</c><00:12:22.760><c> some</c><00:12:22.940><c> time</c>

00:12:23.140 --> 00:12:23.150 align:start position:0%
in your spreadsheet spend some time
 

00:12:23.150 --> 00:12:27.100 align:start position:0%
in your spreadsheet spend some time
writing<00:12:23.480><c> formulas</c><00:12:24.080><c> and</c><00:12:24.260><c> see</c><00:12:24.560><c> how</c><00:12:24.710><c> they</c><00:12:24.860><c> work</c>