WEBVTT
Kind: captions
Language: en-US
00:00:00.260 --> 00:00:04.300
In this video, you will complete the data
tables in your new sheets with functions.
00:00:04.300 --> 00:00:07.830
Functions are pre-set formulas used to make
calculations in Google Sheets. Instead of
00:00:07.830 --> 00:00:12.080
manually adding or multiplying a row of numbers,
functions do the work for you.
00:00:12.080 --> 00:00:16.780
You will use the MULTIPLY and SUM functions
to calculate the totals in the cost and profit
00:00:16.780 --> 00:00:20.800
tables. Then, you will summarize that data,
and find the revenue, in the profit summary.
00:00:20.800 --> 00:00:24.680
The cost, revenue, and profit will help you
determine how much money was spent buying
00:00:24.680 --> 00:00:30.160
materials versus how much your community earned
from sales. For example, you may think you
00:00:30.160 --> 00:00:34.670
made five hundred dollars selling shirts,
but if you spent two hundred dollars on materials,
00:00:34.670 --> 00:00:39.199
then you really only earned three hundred
dollars. This information is laid out in tables,
00:00:39.199 --> 00:00:43.940
which shows the data in rows and columns.
To start, use the MULTIPLY function to find
00:00:43.940 --> 00:00:47.699
the cost of each shirt type. The “cost”
is the amount the fundraising committee spent
00:00:47.699 --> 00:00:52.319
to buy supplies. In this case, it’s the
shirts, which are also the units. You will
00:00:52.319 --> 00:00:57.019
multiply the cost per unit, or the amount
of each shirt at wholesale cost, by the number
00:00:57.019 --> 00:01:00.609
of units purchased.
In the “cost” column of the Cost table,
00:01:00.609 --> 00:01:06.040
type an equals sign, then begin typing the
word “multiply.” Select MULTIPLY from
00:01:06.040 --> 00:01:07.900
the menu.
00:01:10.360 --> 00:01:14.860
Click into the cell of the first number in
your multiplication problem.
00:01:14.860 --> 00:01:19.220
Type a comma, then click into the next cell
you want to multiply.
00:01:19.220 --> 00:01:24.610
Close the parenthesis, and press enter to
complete the function.
00:01:24.610 --> 00:01:28.880
Nice work! You calculated the total cost of
stocking crewneck t-shirts.
00:01:28.880 --> 00:01:33.000
If you see an error message, that’s okay.
Check your function and make sure it matches
00:01:33.000 --> 00:01:36.820
what’s on screen exactly.
Then, change the number format, if it is not
00:01:36.820 --> 00:01:43.300
set to “currency” already, to make sure
it reflects the correct type of data.
00:01:45.770 --> 00:01:49.800
You could repeat these steps for the rest
of the items in this table by using the multiplication
00:01:49.810 --> 00:01:52.500
functions.
But to save time, click then handle of the
00:01:52.500 --> 00:01:57.700
cell with your function and drag down to populate
the rest of the cells in the cost column.
00:01:59.450 --> 00:02:03.920
This applies the function to other cells relative
to the rows and columns around it. Now you
00:02:03.920 --> 00:02:07.630
know how much your fundraising committee spent
to purchase each type of shirt.
00:02:07.630 --> 00:02:12.120
Finally, use the SUM function to calculate
the total units purchased and total overall
00:02:12.120 --> 00:02:16.011
costs. These numbers tell you the total amount
of the upfront costs for the fundraiser, or
00:02:16.020 --> 00:02:19.480
how much the group spent on stocking t-shirts.
00:02:21.620 --> 00:02:23.031
Now that you’ve determined the costs for
00:02:23.031 --> 00:02:27.349
supplying the shirts, you can calculate how
much money the fundraiser actually earned.
00:02:27.349 --> 00:02:32.540
Use the SUM function to find the actual number
of shirts sold in the Current Sales table.
00:02:34.200 --> 00:02:38.590
Great work! In the future, if you need to
complete a particular calculation, consult
00:02:38.590 --> 00:02:42.220
the Function List. You might want to
divide numbers to complete a budget,
00:02:42.220 --> 00:02:46.959
count rows of guests when writing invitations,
or substitute one place name with another
00:02:46.960 --> 00:02:49.640
when changing plans for an upcoming trip.
00:03:05.900 --> 00:03:10.100
Now, it’s your turn:
Use the MULTIPLY function to calculate costs,
00:03:10.109 --> 00:03:14.169
Change the number format to Currency,
Use the SUM function to total your calculations
00:03:14.169 --> 00:03:18.239
and determine your current sales.
And if you need to complete a particular calculation,
00:03:18.240 --> 00:03:20.280
you can consult the Function List.