WEBVTT Kind: captions Language: en 00:00:00.240 --> 00:00:04.240 In this video, you will complete the data tables in your new sheets with functions. 00:00:08.000 --> 00:00:12.880 Instead of manually adding or multiplying a row of numbers, functions do the work for you. 00:00:12.880 --> 00:00:15.120 You will use the MULTIPLY and SUM functions 00:00:15.120 --> 00:00:17.680 to calculate the totals in the cost and profit tables. 00:00:18.640 --> 00:00:22.000 Then, you will summarize that data, and find the revenue, in the profit summary. 00:00:24.400 --> 00:00:27.600 The cost, revenue, and profit will help you determine how much money 00:00:27.600 --> 00:00:31.520 was spent buying materials versus how much your community earned from sales. 00:00:31.520 --> 00:00:35.040 For example, you may think you made \$500 dollars selling shirts, 00:00:35.040 --> 00:00:39.760 but if you spent \$200 dollars on materials, then you really only earned \$300 dollars. 00:00:39.760 --> 00:00:44.960 This information is laid out in tables, which shows the data in rows and columns. 00:00:44.960 --> 00:00:49.040 To start, use the MULTIPLY function to find the cost of each shirt type. 00:00:49.040 --> 00:00:52.640 The cost is the amount the fundraising committee spent to buy supplies. 00:00:52.640 --> 00:00:56.240 In this case, it’s the shirts, which are also the units. 00:00:56.240 --> 00:01:00.880 You will multiply the cost per unit, or the amount of each shirt at wholesale cost, 00:01:00.880 --> 00:01:02.639 by the number of units purchased. 00:01:04.080 --> 00:01:08.059 In the cost column of the Cost table, type an equals sign... 00:01:10.240 --> 00:01:12.160 then begin typing the word “multiply.” 00:01:13.120 --> 00:01:14.800 Select MULTIPLY from the menu. 00:01:17.760 --> 00:01:20.911 Click into the cell of the first number in your multiplication problem. 00:01:24.640 --> 00:01:28.880 Type a comma, then click into the next cell you want to multiply. 00:01:32.080 --> 00:01:33.785 Close the parenthesis... 00:01:34.575 --> 00:01:36.720 and press enter to complete the function. 00:01:36.720 --> 00:01:41.120 Nice work! You calculated the total cost of stocking crewneck t-shirts. 00:01:41.120 --> 00:01:43.760 If you see an error message, that’s okay. 00:01:43.760 --> 00:01:47.120 Check your function and make sure it matches what’s on screen exactly. 00:01:48.720 --> 00:01:52.240 Then, change the number format, if it is not set to currency already, 00:01:52.240 --> 00:01:54.400 to make sure it reflects the correct type of data. 00:02:03.600 --> 00:02:05.680 You could repeat these steps for the rest of the items in 00:02:05.680 --> 00:02:07.840 this table by using the multiplication functions. 00:02:12.880 --> 00:02:15.920 But to save time, click the handle of the cell with your function... 00:02:19.680 --> 00:02:23.668 and drag down to populate the rest of the cells in the cost column. 00:02:37.920 --> 00:02:42.560 This applies the function to other cells relative to the rows and columns around it. 00:02:42.560 --> 00:02:46.734 Now you know how much your fundraising committee spent to purchase each type of shirt. 00:02:46.734 --> 00:02:50.450 Finally, use the SUM function to calculate the total units purchased... 00:03:02.880 --> 00:03:04.782 and total overall costs. 00:03:25.840 --> 00:03:29.280 These numbers tell you the total amount of the upfront costs for the fundraiser, 00:03:29.280 --> 00:03:32.320 or how much the group spent on stocking t-shirts. 00:03:32.320 --> 00:03:34.880 Now that you’ve determined the costs for supplying the shirts, 00:03:34.880 --> 00:03:38.240 you can calculate how much money the fundraiser actually earned. 00:03:38.240 --> 00:03:42.778 Use the SUM function to find the actual number of shirts sold in the Current Sales table. 00:03:56.960 --> 00:04:01.120 Great work! In the future, if you need to complete a particular calculation, 00:04:01.120 --> 00:04:03.144 consult the Function List. 00:04:18.480 --> 00:04:19.120 You might want to: 00:04:19.120 --> 00:04:21.520 Divide numbers to complete a budget... 00:04:31.680 --> 00:04:34.686 Count rows of guests when writing invitations... 00:04:53.200 --> 00:04:57.627 Or substitute one place name with another when changing plans for an upcoming trip.