1 00:00:00,560 --> 00:00:07,360 This exercise is for reviewing for the exam. First of all, open Excel in your book in blank. 2 00:00:16,660 --> 00:00:28,589 Exercise one in the first sheet. Copy this table. You can copy it and paste. 3 00:00:28,589 --> 00:00:48,539 First, add a column with the exam's average here, exam's average, and the average can 4 00:00:48,539 --> 00:00:58,320 be calculated using this formula, that is, promedio, devuelve el promedio media aritmética 5 00:00:58,320 --> 00:01:06,939 de los argumentos serían estos dos. O, si tú sabes que es la suma y la divides entre 6 00:01:06,939 --> 00:01:23,299 dos, igual, paréntesis, suma, sorry, suma, estos dos y lo divides entre dos. Si son 7 00:01:23,299 --> 00:01:28,299 Let's do it, axioms average. 8 00:01:35,700 --> 00:01:40,700 So I'm going to use promedio of these two. 9 00:01:41,719 --> 00:01:47,989 Okay, I'm going to copy the formula here. 10 00:01:47,989 --> 00:01:48,829 That's it. 11 00:01:50,090 --> 00:01:52,989 And it says in the second, add a column 12 00:01:52,989 --> 00:01:57,390 and calculate the notebook and presentation average. 13 00:01:57,390 --> 00:02:09,229 this one I'm going to name it as exercises average and again what I'm going to do it in the other way 14 00:02:10,509 --> 00:02:23,099 that's the addition of these two sorry two packets addition of these two sorry these two 15 00:02:23,099 --> 00:02:32,300 notebook and presentation and divided by two okay both are okay and number three calculate the total 16 00:02:32,300 --> 00:02:42,460 mark exams are 75 percent so uh what i'm going to do is i'm going to copy this exams 17 00:02:44,699 --> 00:02:57,340 it's uh 75 percent and exercises are 25 percent i'm going to do it because i'm going to use the 18 00:02:57,340 --> 00:03:22,639 absolute reference so the final mark is equal to 75 but with the dollar symbols by the 19 00:03:22,639 --> 00:03:37,620 accents average plus the 25% by the exercise average that is here in this 20 00:03:37,620 --> 00:03:52,479 corner I'm improving there and you can see it here exercise for well the point 21 00:03:52,479 --> 00:03:57,280 number four says the final mark should have only one decimal figure so I mark 22 00:03:57,280 --> 00:04:07,280 it and i go to this number formats this is to reduce and i want only one okay and it says use 23 00:04:07,280 --> 00:04:13,599 the conditional format here you have a video link to watch it but it's here that format 24 00:04:13,599 --> 00:04:20,040 condicional, resaltar cedlas que, es menor que y me dicen que sea menor que 5 y que lo resalte 25 00:04:20,040 --> 00:04:29,180 por relleno rojo. I can see it. And number six, represent the graphic in columns with the final 26 00:04:29,180 --> 00:04:39,540 marks. So my recommendation is to copy this and to copy this, be careful to paste only the values. 27 00:04:39,540 --> 00:05:03,600 Here I have this, I'm going to separate this, check these values and insert a graphic that is in columns, so columns, it's here, no, it's here, fantastic, you can change the colors and this is finished. 28 00:05:03,600 --> 00:05:30,259 Second exercise, exercise two. It's a climograph. You have to copy it, ctrl plus c, ctrl v, and they are asking you to represent in one of the graphs, I'm going to make it bigger, sorry. 29 00:05:31,060 --> 00:05:38,259 in one of the graphs the temperature and the month so i signal this go to insert and 30 00:05:39,139 --> 00:05:50,420 this one that's it and the second click on the control button of your keyboard and insert 31 00:05:51,699 --> 00:05:59,980 columns sorry it's not this is this one here we are okay 32 00:05:59,980 --> 00:06:11,019 if you want to represent them both at the same time it's more complicated let's see 33 00:06:11,019 --> 00:06:25,870 it's here cuadro combinado aquí lo tenemos título gráfico bueno sería climograma this is a 34 00:06:25,870 --> 00:06:46,600 I repeat this is we can change it this is a linear a linear graph these are 35 00:06:46,600 --> 00:06:52,779 columns and this is a combination one well I don't like it because normally 36 00:06:52,779 --> 00:07:04,300 it's represented in the other way so let's see how to change this let's change the type of graphic 37 00:07:05,819 --> 00:07:15,189 here column no this is linear and this is columns in vertical that's it 38 00:07:16,069 --> 00:07:22,230 but it's better if we change the colors because normally 39 00:07:24,149 --> 00:07:32,920 cambiar los colores cambiar de colores 40 00:07:32,920 --> 00:07:50,360 bueno podéis intentarlo este me gusta and i leave you the question of which is this it's this is a 41 00:07:50,360 --> 00:07:58,399 city or the clear or the weather which is this weather that is represented here during the summer 42 00:07:58,399 --> 00:08:15,120 There is a peak of temperatures, the winter is really cold and the most important thing is that the pluviosity is streamed during the spring and in the autumn. We will talk about it in the class.