New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.
Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Quiz
Quiz

Celdas absolutas y referencias en Excel

Integrate it into your platform
G. Classroom M. Teams
You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Get Academic Plan

Celdas absolutas y referencias en Excel

Quiz

Played 30
Create copy

About this activity

Quiz sobre referencias absolutas

Created by

Erika Perla
Erika Perla
El Salvador

Download the paper version to play

Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game
Make challenge

Top Games

 %
Anonymous
Anonymous
 %
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Print your game
Celdas absolutas y referencias en Excel
 

Celdas absolutas y referencias en ExcelOnline version

Quiz sobre referencias absolutas

by Erika Perla
1

¿Qué significa una referencia con dos signos de dólar como $A$1?

2

¿Qué es una referencia mixta en Excel?

3

¿Qué ocurre al copiar una fórmula con A1 a la derecha si es A1 sin signos de dólar?

4

¿Qué representa la referencia absoluta en una fórmula como $B$3?

5

Si en una fórmula tienes $C3 y la copias hacia abajo, ¿qué pasa con la columna y la fila?

6

¿Qué tipo de referencia usar para fijar solo la fila al copiar horizontalmente?

7

Si escribes =$D$5 + E$5 en una fila y copias hacia abajo, ¿qué pasa con E$5?

8

¿Cuál es la ventaja principal de usar referencias absolutas en Excel?

9

¿Qué referencia usar para fijar la columna pero permitir que la fila cambie al copiar verticalmente?

10

¿Qué símbolo se usa para fijar tanto columna como fila en Excel?

Explicación

Una referencia $A$1 es fija tanto columna como fila al copiarla.

Puede fijar columna (A$1) o fila ($A1).

Las referencias relativas se desplazan según la nueva posición.

Ambas componentes están fijadas: columna y fila.

La columna está fijada por el símbolo $, la fila se ajusta al desplazamiento.

Columna se ajusta si no va con $. Fijar fila usa $ en la fila.

E$5 conserva la fila 5 al copiar verticalmente.

Permiten mantener constantes ciertas celdas en cálculos.

Columna fija con $, fila sin $ permite cambio de fila.

El símbolo $ ante la columna y la fila indica absoluta.

 
Are you sure you want to leave the page?

If you leave the page, you will lose your game progress.