Saltar navegación

Activa JavaScript para disfrutar de los vídeos de la Mediateca.

3ºESO EXCEL LEVEL 3 - Contenido educativo

Ajuste de pantalla

El ajuste de pantalla se aprecia al ver el vídeo en pantalla completa. Elige la presentación que más te guste:

Subido el 17 de octubre de 2023 por Beatriz T.

90 visualizaciones

Review for the exam

Más información Transcripción

Descargar la transcripción

This exercise is for reviewing for the exam. First of all, open Excel in your book in blank. 00:00:00
Exercise one in the first sheet. Copy this table. You can copy it and paste. 00:00:16
First, add a column with the exam's average here, exam's average, and the average can 00:00:28
be calculated using this formula, that is, promedio, devuelve el promedio media aritmética 00:00:48
de los argumentos serían estos dos. O, si tú sabes que es la suma y la divides entre 00:00:58
dos, igual, paréntesis, suma, sorry, suma, estos dos y lo divides entre dos. Si son 00:01:06
Let's do it, axioms average. 00:01:23
So I'm going to use promedio of these two. 00:01:35
Okay, I'm going to copy the formula here. 00:01:41
That's it. 00:01:47
And it says in the second, add a column 00:01:50
and calculate the notebook and presentation average. 00:01:52
this one I'm going to name it as exercises average and again what I'm going to do it in the other way 00:01:57
that's the addition of these two sorry two packets addition of these two sorry these two 00:02:10
notebook and presentation and divided by two okay both are okay and number three calculate the total 00:02:23
mark exams are 75 percent so uh what i'm going to do is i'm going to copy this exams 00:02:32
it's uh 75 percent and exercises are 25 percent i'm going to do it because i'm going to use the 00:02:44
absolute reference so the final mark is equal to 75 but with the dollar symbols by the 00:02:57
accents average plus the 25% by the exercise average that is here in this 00:03:22
corner I'm improving there and you can see it here exercise for well the point 00:03:37
number four says the final mark should have only one decimal figure so I mark 00:03:52
it and i go to this number formats this is to reduce and i want only one okay and it says use 00:03:57
the conditional format here you have a video link to watch it but it's here that format 00:04:07
condicional, resaltar cedlas que, es menor que y me dicen que sea menor que 5 y que lo resalte 00:04:13
por relleno rojo. I can see it. And number six, represent the graphic in columns with the final 00:04:20
marks. So my recommendation is to copy this and to copy this, be careful to paste only the values. 00:04:29
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. 00:04:39
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. 00:05:03
in one of the graphs the temperature and the month so i signal this go to insert and 00:05:31
this one that's it and the second click on the control button of your keyboard and insert 00:05:39
columns sorry it's not this is this one here we are okay 00:05:51
if you want to represent them both at the same time it's more complicated let's see 00:05:59
it's here cuadro combinado aquí lo tenemos título gráfico bueno sería climograma this is a 00:06:11
I repeat this is we can change it this is a linear a linear graph these are 00:06:25
columns and this is a combination one well I don't like it because normally 00:06:46
it's represented in the other way so let's see how to change this let's change the type of graphic 00:06:52
here column no this is linear and this is columns in vertical that's it 00:07:05
but it's better if we change the colors because normally 00:07:16
cambiar los colores cambiar de colores 00:07:24
bueno podéis intentarlo este me gusta and i leave you the question of which is this it's this is a 00:07:32
city or the clear or the weather which is this weather that is represented here during the summer 00:07:50
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. 00:07:58
Autor/es:
BEATRIZ TORREJON
Subido por:
Beatriz T.
Licencia:
Reconocimiento - No comercial - Sin obra derivada
Visualizaciones:
90
Fecha:
17 de octubre de 2023 - 14:11
Visibilidad:
Público
Centro:
IES CERVANTES
Duración:
08′ 16″
Relación de aspecto:
1.78:1
Resolución:
1280x720 píxeles
Tamaño:
111.94 MBytes

Del mismo autor…

Ver más del mismo autor

EducaMadrid, Plataforma Educativa de la Comunidad de Madrid

Plataforma Educativa EducaMadrid