BASIC EXCEL - 7

Function that returns the value found in the middle of a set of numbers or values

• Fashion

• Half

• Median

• Variance

In the following image, we are looking at the use of the COUNT function. What will be the value that should appear in cell E5?

• 8

• 3

• 7

• 5

In the following image, we are looking at the use of the COUNTA function. What will be the value that should appear in cell B7?

• 3

• 7

• 0

• Ninguno

It is one of the functions that allows me to count the elements with a condition so that it can be executed correctly.

• Count

• COUNT SET

• COUNT IF

• COUNTBLANK

In the following image, we are looking at the use of the COUNTBLANK function. What will be the value that should appear in cell D1?

• 0

• 9

• 6

• 3

It is part of the logical functions and allows us to evaluate a condition to determine if it is true or false.

• And

• IF

• OR

• Concatenate

In the following figure using the IF function to place those conditions, which of the following is correct?

• =SI(A2 > 18, "Menor de edad", SI(A2 <> 65, "Mayor de edad", "Tercera edad"))

• =SI(A2 < 18, "Menor de edad", SI(A2 < 65, "Mayor de edad", "Tercera edad"))

• =SI(A2 < 18, "Menor de edad", SI(A2 < 65, "Mayor de edad", "Mayor de 18 años"))

• =SI(A2 < 18, "Menor de edad", SIA2 < 65, "Mayor de edad", "Tercera edad")

The COUNTIF: IF function gives us the opportunity to count the number of cells or a range of cells fulfilling a criterion. Which syntax is correct?

• =CONTAR.SI(A2:A10,"Fresas"

• =CONTARA.SI(A2;A10,"Fresas")

• =CONTAR.SI(A2:A10,"Fresas")

• =CONTAR,SI(A2:A10;"Fresas")

What is the correct setting when using the SUMIF function in the image?

• =SUMAR.S(A2:A10,F1,C2:C10)

• =SUMAR.SI(A2:A10,F1,C2:C10)

• =SUMAR.SI(A2:A10,C2:C10)

• =SUMAR.SI(A2:A10,F1,C2:C2)

Es una de las herramientas mas útiles para analizar datos ya que son representaciones de datos numéricos.

• Diagrams

• Graphics

• Tables

• Database