Skip to main content

Administrativo del Estado

Topic 37: Hoja de cálculo Microsoft Excel: fórmulas, funciones y gráficos

5 questions on topic 37 of Administrativo del Estado. Every answer is explained and cites the article or syllabus section it is based on.

Rules in this topic

Topic 37

1. ¿Cuál es la función de la tecla F4 al editar una fórmula en Excel?

Topic 37

2. ¿Qué herramienta de Excel permite automatizar tareas repetitivas?

Topic 37

3. ¿Qué ficha de la cinta de opciones contiene herramientas para ordenar y filtrar datos?

Topic 37

4. ¿Qué función se usa para realizar una búsqueda vertical en un rango y devolver un valor de la misma fila?

Topic 37

5. ¿Qué función de Excel se utiliza para sumar productos elemento a elemento de rangos?

Continue with the full syllabus

Tests for every topic with explanation and citation, timed mock exams and a tutor that opens the article. 7 days of Pro on signup, no card.

Create a free account

Frequently asked questions

Where do these questions come from?

From the Oposilab topic tests for Administrativo del Estado, generated from the consolidated text of the syllabus laws and reviewed by block. Every question cites the article or section it is based on.

Is this the real exam format?

No. It is a short sample to see how the questions, the explanation and the citation work. The official exam structure is on the exam page, with the source and the verification date.

How many questions does Oposilab have?

The updated figure is shown on the home page and comes straight from the database. Every exam has topic tests and an AI-generated test whenever you need one.