WEBVTT
Kind: captions
Language: en

00:00:01.159 --> 00:00:03.739 align:start position:0%
 
Goodwill<00:00:02.159><c> Community</c><00:00:02.639><c> Foundation</c><00:00:03.300><c> creating</c>

00:00:03.739 --> 00:00:03.749 align:start position:0%
Goodwill Community Foundation creating
 

00:00:03.749 --> 00:00:09.860 align:start position:0%
Goodwill Community Foundation creating
opportunities<00:00:04.350><c> for</c><00:00:04.560><c> a</c><00:00:04.620><c> better</c><00:00:04.649><c> life</c><00:00:08.690><c> say</c><00:00:09.690><c> I'm</c>

00:00:09.860 --> 00:00:09.870 align:start position:0%
opportunities for a better life say I'm
 

00:00:09.870 --> 00:00:11.810 align:start position:0%
opportunities for a better life say I'm
taking<00:00:10.080><c> a</c><00:00:10.320><c> class</c><00:00:10.500><c> in</c><00:00:10.769><c> school</c><00:00:10.889><c> and</c><00:00:11.280><c> I'm</c><00:00:11.670><c> not</c>

00:00:11.810 --> 00:00:11.820 align:start position:0%
taking a class in school and I'm not
 

00:00:11.820 --> 00:00:13.299 align:start position:0%
taking a class in school and I'm not
doing<00:00:12.150><c> very</c><00:00:12.299><c> well</c><00:00:12.389><c> so</c><00:00:12.540><c> far</c>

00:00:13.299 --> 00:00:13.309 align:start position:0%
doing very well so far
 

00:00:13.309 --> 00:00:15.799 align:start position:0%
doing very well so far
luckily<00:00:14.309><c> if</c><00:00:14.490><c> I</c><00:00:14.730><c> get</c><00:00:14.910><c> a</c><00:00:14.940><c> high</c><00:00:15.179><c> enough</c><00:00:15.210><c> grade</c><00:00:15.660><c> on</c>

00:00:15.799 --> 00:00:15.809 align:start position:0%
luckily if I get a high enough grade on
 

00:00:15.809 --> 00:00:17.779 align:start position:0%
luckily if I get a high enough grade on
the<00:00:15.900><c> final</c><00:00:16.200><c> exam</c><00:00:16.320><c> there's</c><00:00:17.010><c> a</c><00:00:17.100><c> chance</c><00:00:17.400><c> I</c><00:00:17.550><c> may</c><00:00:17.730><c> be</c>

00:00:17.779 --> 00:00:17.789 align:start position:0%
the final exam there's a chance I may be
 

00:00:17.789 --> 00:00:20.599 align:start position:0%
the final exam there's a chance I may be
able<00:00:18.000><c> to</c><00:00:18.210><c> pass</c><00:00:18.390><c> the</c><00:00:18.600><c> class</c><00:00:18.980><c> the</c><00:00:19.980><c> question</c><00:00:20.430><c> is</c>

00:00:20.599 --> 00:00:20.609 align:start position:0%
able to pass the class the question is
 

00:00:20.609 --> 00:00:22.849 align:start position:0%
able to pass the class the question is
what<00:00:21.150><c> grade</c><00:00:21.390><c> do</c><00:00:21.570><c> I</c><00:00:21.630><c> need</c><00:00:21.840><c> to</c><00:00:21.990><c> get</c><00:00:22.140><c> on</c><00:00:22.350><c> the</c><00:00:22.470><c> exam</c>

00:00:22.849 --> 00:00:22.859 align:start position:0%
what grade do I need to get on the exam
 

00:00:22.859 --> 00:00:26.210 align:start position:0%
what grade do I need to get on the exam
to<00:00:23.250><c> raise</c><00:00:23.490><c> my</c><00:00:23.699><c> average</c><00:00:24.119><c> to</c><00:00:24.330><c> at</c><00:00:24.449><c> least</c><00:00:24.689><c> a</c><00:00:24.869><c> 70</c><00:00:25.289><c> we</c>

00:00:26.210 --> 00:00:26.220 align:start position:0%
to raise my average to at least a 70 we
 

00:00:26.220 --> 00:00:27.800 align:start position:0%
to raise my average to at least a 70 we
can<00:00:26.400><c> find</c><00:00:26.670><c> out</c><00:00:26.880><c> using</c><00:00:27.269><c> a</c><00:00:27.449><c> feature</c><00:00:27.660><c> called</c>

00:00:27.800 --> 00:00:27.810 align:start position:0%
can find out using a feature called
 

00:00:27.810 --> 00:00:30.140 align:start position:0%
can find out using a feature called
what-if<00:00:28.500><c> analysis</c><00:00:28.650><c> which</c><00:00:29.640><c> allows</c><00:00:29.939><c> you</c><00:00:30.119><c> to</c>

00:00:30.140 --> 00:00:30.150 align:start position:0%
what-if analysis which allows you to
 

00:00:30.150 --> 00:00:32.120 align:start position:0%
what-if analysis which allows you to
fill<00:00:30.420><c> in</c><00:00:30.570><c> missing</c><00:00:30.900><c> information</c><00:00:31.050><c> based</c><00:00:31.859><c> on</c><00:00:32.070><c> the</c>

00:00:32.120 --> 00:00:32.130 align:start position:0%
fill in missing information based on the
 

00:00:32.130 --> 00:00:35.900 align:start position:0%
fill in missing information based on the
data<00:00:32.370><c> you</c><00:00:32.550><c> already</c><00:00:32.910><c> have</c><00:00:34.310><c> right</c><00:00:35.310><c> now</c><00:00:35.370><c> all</c><00:00:35.850><c> I</c>

00:00:35.900 --> 00:00:35.910 align:start position:0%
data you already have right now all I
 

00:00:35.910 --> 00:00:37.670 align:start position:0%
data you already have right now all I
know<00:00:36.330><c> are</c><00:00:36.420><c> the</c><00:00:36.570><c> grades</c><00:00:36.810><c> I</c><00:00:36.990><c> got</c><00:00:37.200><c> on</c><00:00:37.380><c> the</c><00:00:37.500><c> first</c>

00:00:37.670 --> 00:00:37.680 align:start position:0%
know are the grades I got on the first
 

00:00:37.680 --> 00:00:43.400 align:start position:0%
know are the grades I got on the first
four<00:00:38.040><c> assignments</c><00:00:38.600><c> 58</c><00:00:39.600><c> 70</c><00:00:40.530><c> 72</c><00:00:41.310><c> and</c><00:00:41.790><c> 60</c><00:00:42.410><c> before</c>

00:00:43.400 --> 00:00:43.410 align:start position:0%
four assignments 58 70 72 and 60 before
 

00:00:43.410 --> 00:00:45.590 align:start position:0%
four assignments 58 70 72 and 60 before
we<00:00:43.740><c> do</c><00:00:43.860><c> our</c><00:00:44.010><c> analysis</c><00:00:44.580><c> we</c><00:00:45.000><c> need</c><00:00:45.150><c> to</c><00:00:45.270><c> figure</c><00:00:45.450><c> out</c>

00:00:45.590 --> 00:00:45.600 align:start position:0%
we do our analysis we need to figure out
 

00:00:45.600 --> 00:00:47.810 align:start position:0%
we do our analysis we need to figure out
my<00:00:45.900><c> current</c><00:00:46.260><c> average</c><00:00:46.620><c> by</c><00:00:46.980><c> adding</c><00:00:47.310><c> a</c><00:00:47.400><c> formula</c>

00:00:47.810 --> 00:00:47.820 align:start position:0%
my current average by adding a formula
 

00:00:47.820 --> 00:00:51.560 align:start position:0%
my current average by adding a formula
or<00:00:47.940><c> function</c><00:00:48.210><c> in</c><00:00:48.630><c> this</c><00:00:48.840><c> cell</c><00:00:49.140><c> in</c><00:00:50.270><c> this</c><00:00:51.270><c> case</c>

00:00:51.560 --> 00:00:51.570 align:start position:0%
or function in this cell in this case
 

00:00:51.570 --> 00:00:53.960 align:start position:0%
or function in this cell in this case
each<00:00:51.990><c> assignment</c><00:00:52.500><c> is</c><00:00:52.710><c> weighted</c><00:00:53.070><c> equally</c><00:00:53.430><c> so</c>

00:00:53.960 --> 00:00:53.970 align:start position:0%
each assignment is weighted equally so
 

00:00:53.970 --> 00:00:55.310 align:start position:0%
each assignment is weighted equally so
we<00:00:54.090><c> can</c><00:00:54.270><c> calculate</c><00:00:54.480><c> the</c><00:00:54.900><c> number</c><00:00:55.020><c> we</c><00:00:55.290><c> need</c>

00:00:55.310 --> 00:00:55.320 align:start position:0%
we can calculate the number we need
 

00:00:55.320 --> 00:00:58.280 align:start position:0%
we can calculate the number we need
using<00:00:55.830><c> the</c><00:00:56.130><c> average</c><00:00:56.310><c> function</c><00:00:56.990><c> to</c><00:00:57.990><c> get</c><00:00:58.140><c> the</c>

00:00:58.280 --> 00:00:58.290 align:start position:0%
using the average function to get the
 

00:00:58.290 --> 00:01:00.320 align:start position:0%
using the average function to get the
most<00:00:58.440><c> out</c><00:00:58.680><c> of</c><00:00:58.710><c> what</c><00:00:58.830><c> if</c><00:00:59.010><c> analysis</c><00:00:59.550><c> you</c><00:00:59.940><c> do</c><00:01:00.150><c> need</c>

00:01:00.320 --> 00:01:00.330 align:start position:0%
most out of what if analysis you do need
 

00:01:00.330 --> 00:01:01.910 align:start position:0%
most out of what if analysis you do need
to<00:01:00.420><c> be</c><00:01:00.540><c> fairly</c><00:01:00.780><c> comfortable</c><00:01:01.080><c> with</c><00:01:01.380><c> formulas</c>

00:01:01.910 --> 00:01:01.920 align:start position:0%
to be fairly comfortable with formulas
 

00:01:01.920 --> 00:01:04.070 align:start position:0%
to be fairly comfortable with formulas
and<00:01:02.100><c> functions</c><00:01:02.390><c> luckily</c><00:01:03.390><c> this</c><00:01:03.570><c> one</c><00:01:03.780><c> is</c><00:01:03.900><c> pretty</c>

00:01:04.070 --> 00:01:04.080 align:start position:0%
and functions luckily this one is pretty
 

00:01:04.080 --> 00:01:07.010 align:start position:0%
and functions luckily this one is pretty
simple<00:01:04.580><c> we'll</c><00:01:05.580><c> just</c><00:01:05.820><c> type</c><00:01:06.030><c> an</c><00:01:06.180><c> equal</c><00:01:06.510><c> sign</c><00:01:06.780><c> and</c>

00:01:07.010 --> 00:01:07.020 align:start position:0%
simple we'll just type an equal sign and
 

00:01:07.020 --> 00:01:12.890 align:start position:0%
simple we'll just type an equal sign and
then<00:01:07.650><c> average</c><00:01:10.970><c> next</c><00:01:11.970><c> we</c><00:01:12.090><c> need</c><00:01:12.240><c> to</c><00:01:12.390><c> select</c><00:01:12.510><c> all</c>

00:01:12.890 --> 00:01:12.900 align:start position:0%
then average next we need to select all
 

00:01:12.900 --> 00:01:15.200 align:start position:0%
then average next we need to select all
the<00:01:13.230><c> cells</c><00:01:13.470><c> even</c><00:01:13.950><c> the</c><00:01:14.280><c> empty</c><00:01:14.640><c> cell</c><00:01:14.850><c> for</c><00:01:15.150><c> the</c>

00:01:15.200 --> 00:01:15.210 align:start position:0%
the cells even the empty cell for the
 

00:01:15.210 --> 00:01:18.080 align:start position:0%
the cells even the empty cell for the
final<00:01:15.540><c> exam</c><00:01:15.870><c> grade</c><00:01:16.140><c> if</c><00:01:16.350><c> we</c><00:01:17.250><c> don't</c><00:01:17.520><c> it</c><00:01:17.760><c> won't</c>

00:01:18.080 --> 00:01:18.090 align:start position:0%
final exam grade if we don't it won't
 

00:01:18.090 --> 00:01:19.940 align:start position:0%
final exam grade if we don't it won't
calculate<00:01:18.660><c> the</c><00:01:18.810><c> average</c><00:01:19.230><c> for</c><00:01:19.500><c> all</c><00:01:19.530><c> five</c>

00:01:19.940 --> 00:01:19.950 align:start position:0%
calculate the average for all five
 

00:01:19.950 --> 00:01:24.050 align:start position:0%
calculate the average for all five
assignments<00:01:21.980><c> looks</c><00:01:22.980><c> like</c><00:01:23.160><c> we're</c><00:01:23.370><c> done</c><00:01:23.520><c> so</c><00:01:23.940><c> I'm</c>

00:01:24.050 --> 00:01:24.060 align:start position:0%
assignments looks like we're done so I'm
 

00:01:24.060 --> 00:01:27.020 align:start position:0%
assignments looks like we're done so I'm
just<00:01:24.240><c> going</c><00:01:24.420><c> to</c><00:01:24.450><c> press</c><00:01:24.660><c> ENTER</c><00:01:25.080><c> and</c><00:01:25.290><c> now</c><00:01:25.820><c> we</c><00:01:26.820><c> can</c>

00:01:27.020 --> 00:01:27.030 align:start position:0%
just going to press ENTER and now we can
 

00:01:27.030 --> 00:01:30.260 align:start position:0%
just going to press ENTER and now we can
see<00:01:27.210><c> my</c><00:01:27.390><c> current</c><00:01:27.420><c> average</c><00:01:29.270><c> unfortunately</c>

00:01:30.260 --> 00:01:30.270 align:start position:0%
see my current average unfortunately
 

00:01:30.270 --> 00:01:31.730 align:start position:0%
see my current average unfortunately
it's<00:01:30.390><c> not</c><00:01:30.570><c> high</c><00:01:30.810><c> enough</c><00:01:30.840><c> but</c><00:01:31.470><c> we</c><00:01:31.590><c> knew</c><00:01:31.710><c> that</c>

00:01:31.730 --> 00:01:31.740 align:start position:0%
it's not high enough but we knew that
 

00:01:31.740 --> 00:01:34.130 align:start position:0%
it's not high enough but we knew that
was<00:01:32.010><c> going</c><00:01:32.070><c> to</c><00:01:32.220><c> happen</c><00:01:32.540><c> now</c><00:01:33.540><c> we</c><00:01:33.600><c> can</c><00:01:33.840><c> move</c><00:01:33.960><c> on</c>

00:01:34.130 --> 00:01:34.140 align:start position:0%
was going to happen now we can move on
 

00:01:34.140 --> 00:01:36.260 align:start position:0%
was going to happen now we can move on
to<00:01:34.230><c> the</c><00:01:34.320><c> next</c><00:01:34.680><c> step</c><00:01:34.860><c> using</c><00:01:35.520><c> a</c><00:01:35.730><c> feature</c><00:01:35.940><c> called</c>

00:01:36.260 --> 00:01:36.270 align:start position:0%
to the next step using a feature called
 

00:01:36.270 --> 00:01:38.330 align:start position:0%
to the next step using a feature called
goal<00:01:36.630><c> seek</c><00:01:36.659><c> to</c><00:01:37.320><c> figure</c><00:01:37.590><c> out</c><00:01:37.740><c> what</c><00:01:37.890><c> we</c><00:01:38.010><c> need</c><00:01:38.220><c> on</c>

00:01:38.330 --> 00:01:38.340 align:start position:0%
goal seek to figure out what we need on
 

00:01:38.340 --> 00:01:41.480 align:start position:0%
goal seek to figure out what we need on
the<00:01:38.460><c> final</c><00:01:38.760><c> exam</c><00:01:39.620><c> goal</c><00:01:40.620><c> seek</c><00:01:40.890><c> is</c><00:01:41.100><c> a</c><00:01:41.130><c> type</c><00:01:41.460><c> of</c>

00:01:41.480 --> 00:01:41.490 align:start position:0%
the final exam goal seek is a type of
 

00:01:41.490 --> 00:01:43.610 align:start position:0%
the final exam goal seek is a type of
what-if<00:01:41.880><c> analysis</c><00:01:42.450><c> that</c><00:01:42.810><c> basically</c><00:01:43.320><c> lets</c><00:01:43.530><c> you</c>

00:01:43.610 --> 00:01:43.620 align:start position:0%
what-if analysis that basically lets you
 

00:01:43.620 --> 00:01:45.440 align:start position:0%
what-if analysis that basically lets you
work<00:01:43.830><c> backwards</c><00:01:44.370><c> in</c><00:01:44.580><c> order</c><00:01:44.820><c> to</c><00:01:45.060><c> find</c><00:01:45.300><c> a</c>

00:01:45.440 --> 00:01:45.450 align:start position:0%
work backwards in order to find a
 

00:01:45.450 --> 00:01:47.990 align:start position:0%
work backwards in order to find a
missing<00:01:45.750><c> value</c><00:01:45.979><c> it</c><00:01:46.979><c> starts</c><00:01:47.400><c> with</c><00:01:47.580><c> the</c><00:01:47.670><c> result</c>

00:01:47.990 --> 00:01:48.000 align:start position:0%
missing value it starts with the result
 

00:01:48.000 --> 00:01:49.850 align:start position:0%
missing value it starts with the result
you<00:01:48.150><c> want</c><00:01:48.180><c> then</c><00:01:48.870><c> it</c><00:01:49.020><c> calculates</c><00:01:49.229><c> whatever</c>

00:01:49.850 --> 00:01:49.860 align:start position:0%
you want then it calculates whatever
 

00:01:49.860 --> 00:01:54.469 align:start position:0%
you want then it calculates whatever
input<00:01:50.310><c> is</c><00:01:50.430><c> needed</c><00:01:50.580><c> to</c><00:01:50.909><c> get</c><00:01:51.060><c> you</c><00:01:51.150><c> there</c><00:01:53.479><c> to</c>

00:01:54.469 --> 00:01:54.479 align:start position:0%
input is needed to get you there to
 

00:01:54.479 --> 00:01:56.600 align:start position:0%
input is needed to get you there to
begin<00:01:54.630><c> select</c><00:01:55.470><c> the</c><00:01:55.680><c> cell</c><00:01:55.890><c> that</c><00:01:56.010><c> contains</c><00:01:56.070><c> your</c>

00:01:56.600 --> 00:01:56.610 align:start position:0%
begin select the cell that contains your
 

00:01:56.610 --> 00:02:00.800 align:start position:0%
begin select the cell that contains your
formula<00:01:57.090><c> or</c><00:01:57.240><c> function</c><00:01:57.479><c> in</c><00:01:57.870><c> our</c><00:01:58.320><c> case</c><00:01:58.590><c> b7</c>

00:02:00.800 --> 00:02:00.810 align:start position:0%
formula or function in our case b7
 

00:02:00.810 --> 00:02:05.610 align:start position:0%
formula or function in our case b7
then<00:02:01.810><c> go</c><00:02:02.020><c> to</c><00:02:02.080><c> the</c><00:02:02.320><c> data</c><00:02:02.440><c> tab</c><00:02:02.800><c> and</c><00:02:04.590><c> click</c><00:02:05.590><c> the</c>

00:02:05.610 --> 00:02:05.620 align:start position:0%
then go to the data tab and click the
 

00:02:05.620 --> 00:02:09.180 align:start position:0%
then go to the data tab and click the
what-if<00:02:06.010><c> analysis</c><00:02:06.610><c> command</c><00:02:08.070><c> there</c><00:02:09.070><c> are</c>

00:02:09.180 --> 00:02:09.190 align:start position:0%
what-if analysis command there are
 

00:02:09.190 --> 00:02:10.710 align:start position:0%
what-if analysis command there are
actually<00:02:09.610><c> several</c><00:02:09.880><c> different</c><00:02:10.330><c> types</c><00:02:10.509><c> of</c>

00:02:10.710 --> 00:02:10.720 align:start position:0%
actually several different types of
 

00:02:10.720 --> 00:02:12.810 align:start position:0%
actually several different types of
what-if<00:02:10.990><c> analysis</c><00:02:11.560><c> including</c><00:02:12.340><c> scenario</c>

00:02:12.810 --> 00:02:12.820 align:start position:0%
what-if analysis including scenario
 

00:02:12.820 --> 00:02:15.750 align:start position:0%
what-if analysis including scenario
manager<00:02:13.030><c> and</c><00:02:13.450><c> data</c><00:02:13.810><c> table</c><00:02:14.200><c> but</c><00:02:15.160><c> in</c><00:02:15.340><c> this</c><00:02:15.520><c> case</c>

00:02:15.750 --> 00:02:15.760 align:start position:0%
manager and data table but in this case
 

00:02:15.760 --> 00:02:20.040 align:start position:0%
manager and data table but in this case
we're<00:02:16.180><c> going</c><00:02:16.390><c> to</c><00:02:16.450><c> use</c><00:02:16.540><c> goal</c><00:02:16.990><c> seek</c><00:02:17.020><c> a</c><00:02:19.050><c> dialog</c>

00:02:20.040 --> 00:02:20.050 align:start position:0%
we're going to use goal seek a dialog
 

00:02:20.050 --> 00:02:21.660 align:start position:0%
we're going to use goal seek a dialog
box<00:02:20.290><c> will</c><00:02:20.530><c> appear</c><00:02:20.650><c> where</c><00:02:21.130><c> you</c><00:02:21.190><c> can</c><00:02:21.310><c> set</c><00:02:21.640><c> the</c>

00:02:21.660 --> 00:02:21.670 align:start position:0%
box will appear where you can set the
 

00:02:21.670 --> 00:02:23.580 align:start position:0%
box will appear where you can set the
parameters<00:02:21.940><c> for</c><00:02:22.570><c> the</c><00:02:22.630><c> information</c><00:02:23.230><c> you</c><00:02:23.380><c> need</c>

00:02:23.580 --> 00:02:23.590 align:start position:0%
parameters for the information you need
 

00:02:23.590 --> 00:02:27.450 align:start position:0%
parameters for the information you need
in<00:02:24.060><c> our</c><00:02:25.060><c> example</c><00:02:25.600><c> we</c><00:02:26.020><c> want</c><00:02:26.260><c> to</c><00:02:26.320><c> set</c><00:02:26.530><c> cell</c><00:02:26.890><c> b7</c>

00:02:27.450 --> 00:02:27.460 align:start position:0%
in our example we want to set cell b7
 

00:02:27.460 --> 00:02:31.050 align:start position:0%
in our example we want to set cell b7
that's<00:02:28.030><c> our</c><00:02:28.270><c> selected</c><00:02:28.780><c> cell</c><00:02:29.280><c> to</c><00:02:30.280><c> a</c><00:02:30.310><c> value</c><00:02:30.820><c> of</c>

00:02:31.050 --> 00:02:31.060 align:start position:0%
that's our selected cell to a value of
 

00:02:31.060 --> 00:02:34.590 align:start position:0%
that's our selected cell to a value of
70<00:02:32.250><c> by</c><00:02:33.250><c> changing</c><00:02:33.760><c> the</c><00:02:33.880><c> cell</c><00:02:34.150><c> that</c><00:02:34.450><c> contains</c>

00:02:34.590 --> 00:02:34.600 align:start position:0%
70 by changing the cell that contains
 

00:02:34.600 --> 00:02:37.740 align:start position:0%
70 by changing the cell that contains
our<00:02:35.020><c> missing</c><00:02:35.410><c> value</c><00:02:35.740><c> and</c><00:02:36.300><c> that's</c><00:02:37.300><c> going</c><00:02:37.540><c> to</c><00:02:37.600><c> be</c>

00:02:37.740 --> 00:02:37.750 align:start position:0%
our missing value and that's going to be
 

00:02:37.750 --> 00:02:44.400 align:start position:0%
our missing value and that's going to be
b6<00:02:40.440><c> when</c><00:02:41.440><c> you're</c><00:02:41.590><c> done</c><00:02:41.800><c> click</c><00:02:42.220><c> OK</c><00:02:42.610><c> and</c><00:02:43.410><c> goal</c>

00:02:44.400 --> 00:02:44.410 align:start position:0%
b6 when you're done click OK and goal
 

00:02:44.410 --> 00:02:46.050 align:start position:0%
b6 when you're done click OK and goal
seek<00:02:44.590><c> will</c><00:02:44.800><c> take</c><00:02:44.980><c> a</c><00:02:45.010><c> minute</c><00:02:45.340><c> to</c><00:02:45.520><c> see</c><00:02:45.700><c> if</c><00:02:45.790><c> it</c><00:02:45.940><c> can</c>

00:02:46.050 --> 00:02:46.060 align:start position:0%
seek will take a minute to see if it can
 

00:02:46.060 --> 00:02:50.580 align:start position:0%
seek will take a minute to see if it can
find<00:02:46.240><c> a</c><00:02:46.390><c> solution</c><00:02:48.959><c> based</c><00:02:49.959><c> on</c><00:02:50.140><c> the</c><00:02:50.200><c> message</c>

00:02:50.580 --> 00:02:50.590 align:start position:0%
find a solution based on the message
 

00:02:50.590 --> 00:02:53.460 align:start position:0%
find a solution based on the message
here<00:02:50.920><c> it</c><00:02:51.100><c> looks</c><00:02:51.400><c> like</c><00:02:51.459><c> we</c><00:02:51.580><c> were</c><00:02:51.820><c> successful</c><00:02:52.470><c> so</c>

00:02:53.460 --> 00:02:53.470 align:start position:0%
here it looks like we were successful so
 

00:02:53.470 --> 00:02:56.460 align:start position:0%
here it looks like we were successful so
we're<00:02:53.680><c> going</c><00:02:53.770><c> to</c><00:02:53.830><c> click</c><00:02:54.010><c> OK</c><00:02:54.190><c> and</c><00:02:55.200><c> now</c><00:02:56.200><c> we</c><00:02:56.230><c> can</c>

00:02:56.460 --> 00:02:56.470 align:start position:0%
we're going to click OK and now we can
 

00:02:56.470 --> 00:02:58.080 align:start position:0%
we're going to click OK and now we can
see<00:02:56.650><c> the</c><00:02:56.770><c> result</c><00:02:57.100><c> we</c><00:02:57.160><c> were</c><00:02:57.370><c> looking</c><00:02:57.640><c> for</c><00:02:57.880><c> in</c>

00:02:58.080 --> 00:02:58.090 align:start position:0%
see the result we were looking for in
 

00:02:58.090 --> 00:03:01.650 align:start position:0%
see the result we were looking for in
the<00:02:58.240><c> final</c><00:02:58.570><c> exam</c><00:02:58.720><c> cell</c><00:02:59.850><c> so</c><00:03:00.850><c> I</c><00:03:00.880><c> guess</c><00:03:01.300><c> I</c><00:03:01.450><c> need</c><00:03:01.630><c> to</c>

00:03:01.650 --> 00:03:01.660 align:start position:0%
the final exam cell so I guess I need to
 

00:03:01.660 --> 00:03:03.780 align:start position:0%
the final exam cell so I guess I need to
make<00:03:01.900><c> a</c><00:03:01.930><c> 90</c><00:03:02.410><c> on</c><00:03:02.440><c> the</c><00:03:02.650><c> exam</c><00:03:02.980><c> in</c><00:03:03.160><c> order</c><00:03:03.340><c> to</c><00:03:03.490><c> pass</c>

00:03:03.780 --> 00:03:03.790 align:start position:0%
make a 90 on the exam in order to pass
 

00:03:03.790 --> 00:03:06.240 align:start position:0%
make a 90 on the exam in order to pass
the<00:03:04.000><c> class</c><00:03:04.120><c> it's</c><00:03:05.080><c> going</c><00:03:05.290><c> to</c><00:03:05.350><c> be</c><00:03:05.470><c> tough</c><00:03:05.739><c> but</c><00:03:06.190><c> I</c>

00:03:06.240 --> 00:03:06.250 align:start position:0%
the class it's going to be tough but I
 

00:03:06.250 --> 00:03:08.580 align:start position:0%
the class it's going to be tough but I
think<00:03:06.340><c> I</c><00:03:06.610><c> can</c><00:03:06.760><c> do</c><00:03:06.880><c> it</c><00:03:06.910><c> at</c><00:03:07.239><c> least</c><00:03:08.170><c> now</c><00:03:08.410><c> I</c><00:03:08.440><c> know</c>

00:03:08.580 --> 00:03:08.590 align:start position:0%
think I can do it at least now I know
 

00:03:08.590 --> 00:03:10.680 align:start position:0%
think I can do it at least now I know
thanks<00:03:09.370><c> to</c><00:03:09.400><c> the</c><00:03:09.550><c> work</c><00:03:09.730><c> we</c><00:03:09.910><c> did</c><00:03:10.060><c> with</c><00:03:10.300><c> what-if</c>

00:03:10.680 --> 00:03:10.690 align:start position:0%
thanks to the work we did with what-if
 

00:03:10.690 --> 00:03:13.380 align:start position:0%
thanks to the work we did with what-if
analysis<00:03:11.040><c> it</c><00:03:12.040><c> might</c><00:03:12.340><c> take</c><00:03:12.550><c> some</c><00:03:12.730><c> practice</c><00:03:12.940><c> to</c>

00:03:13.380 --> 00:03:13.390 align:start position:0%
analysis it might take some practice to
 

00:03:13.390 --> 00:03:14.790 align:start position:0%
analysis it might take some practice to
get<00:03:13.480><c> the</c><00:03:13.540><c> hang</c><00:03:13.810><c> of</c><00:03:13.900><c> the</c><00:03:14.019><c> feature</c><00:03:14.230><c> on</c><00:03:14.470><c> your</c><00:03:14.620><c> own</c>

00:03:14.790 --> 00:03:14.800 align:start position:0%
get the hang of the feature on your own
 

00:03:14.800 --> 00:03:16.410 align:start position:0%
get the hang of the feature on your own
but<00:03:15.250><c> it's</c><00:03:15.400><c> a</c><00:03:15.519><c> great</c><00:03:15.700><c> way</c><00:03:15.880><c> to</c><00:03:15.910><c> figure</c><00:03:16.180><c> out</c>

00:03:16.410 --> 00:03:16.420 align:start position:0%
but it's a great way to figure out
 

00:03:16.420 --> 00:03:19.120 align:start position:0%
but it's a great way to figure out
unknown<00:03:16.840><c> values</c><00:03:17.290><c> in</c><00:03:17.500><c> your</c><00:03:17.620><c> worksheet</c>

00:03:19.120 --> 00:03:19.130 align:start position:0%
unknown values in your worksheet
 

00:03:19.130 --> 00:03:21.190 align:start position:0%
unknown values in your worksheet
you