ATAJOS Flashcards

1
Q

COPIAR

A

CTRL + C

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

PEGAR

A

CTRL + V

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

SELECCIONAR TODOS LOS DATOS

A

CTRL + E

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

NEGRITA

A

CTRL + N

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

RELLENAR

A

CTRL + D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

BUSCAR

A

CTRL + B

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

GUARDAR

A

CTRL + G

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

IMPRIMIR

A

CTRL + P

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

SUBRAYAR

A

CTRL + S

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

DESHACER

A

CTRL + Z

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

SELECCIONA E INSERTA COLUMNAS

A

CTRL + ESPACIO Y LUEGO CTRL “+”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

SELECCIONA Y ELIMINA COLUMNAS

A

CRTL + ESPACIO Y LUEGO CTRL “-“

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

INSERTAR SOLO CELDAS

A

CTRL + “+”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

ELIMINAR CELDAS

A

CTRL + “-“

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

INSERTAR FILAS

A

SHIFT + ESPACIO Y LUEGO CONTROL “+”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

ELIMINAR FILAS

A

SHIFT + ESPACIO Y LUEGO CTRL “-“

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

SALTAR A LA SIGUIENTE PESTAÑA

A

CTRL + AVPag

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

REGRESAR A LA PESTAÑA ANTERIOR

A

CTRL + REpag

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

DESPLAZARTE HACIA EL FINAL

A

CTRL + FLECHA DE DESPLAZAMIENTO

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

SELECCIONA TODA UNA COLUMNA CON DATOS

A

CTRL + SHIFT + ABAJO/ARRIBA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

SELECCIONA TODA UNA FILA CON DATOS

A

CTRL + SHIFT + DERECHA O IZQUIERDA

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

DAR FORMATO DE PESOS A UN NÚMERO

A

CTRL + SHIFT + 4

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

DAR FORMATO DE % A UN NUMERO

A

CTRL + SHIFT + 5

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

CORTAR

A

CTRL + X

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

REHACER ACCION QUE FUE DESECHA PREVIAMENTE CON CTRL + Z

A

CTRL + Y

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
26
Q

INSERTAR HORA ACTUAL

A

CTRL + “:”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
27
Q

INSERTAR FECHA ACTUAL

A

CTRL + “;”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
28
Q

NUEVO LIBRO DE TRABAJO

29
Q

EDITAR COMENTARIO DE CELDA

A

SHIFT + F2

30
Q

BUSCAR

A

MAYÚS + F5

31
Q

PANEL ANTERIOR

A

MAYÚS + F6

32
Q

AÑADIR A LA SELECCION

A

MAYÚS + F8

33
Q

CALCULAR LA HOJA DE CALCULO ACTIVA

A

SHIFT + F9

34
Q

VISUALIZACION DEL MENÚ EMERGENTE

A

SHIFT + F10

35
Q

NUEVA HOJA DE CALCULO

A

SHIFT + F11

36
Q

CERRAR

37
Q

FORMATO GENERAL

A

CTRL + SHIFT + ~

38
Q

FORMATO DE COMA

A

CTRL + SHIFT + !

39
Q

FORMATO DE HORA

A

CTRL + SHIFT + @

40
Q

FORMATO DE FECHA

A

CTRL + SHIFT + #

41
Q

FORMATO DE MONEDA

A

CTRL + SHIFT + $

42
Q

FORMATO DE PORCENTAJE

A

CTRL + SHIFT + %

43
Q

OCULTAR LINEAS

44
Q

OCULTAR COLUMNAS

45
Q

COPIA UNA FORMULA SOBRE HACIA LA DERECHA DEL RANGO SELECCIONADO

46
Q

COPIA UNA FORMULA HACIA ABAJO SOBRE EL RANGO SELECCIONADO

47
Q

CURSIVA

48
Q

TACHADO

49
Q

INSERTAR UN GRAFICO

50
Q

ABRE EL CUADRO DE DIALOGO MACRO

51
Q

COPIA EL CONTENIDO DE LA CELDA SUPERIOR

A

CTRL + MAYÚS + “

52
Q

ACTIVA O DESACTIVA LOS FILTROS DE UN RANGO

A

CTRL + MAYÚS+ L

53
Q

SELECCIONA LAS CELDAS CON COMENTARIOS

A

CTRL + MAYÚS + O

54
Q

EXPANDE LA BARRA DE FORMULAS

A

CTRL + MAYÚS + O

55
Q

ABRIR EL EDITOR DE MICROSOFT VISUAL BASIC

56
Q

COPIA LA FORMULA DE LA CELDA SUPERIOR

A

CTRL + ‘

57
Q

COPIA VALOR DE LA CELDA SUPERIOR

A

CTRL + “

58
Q

AGREGAR HIPERVÍNCULO

A

CTRL + ALT + K

59
Q

MOSTRAR LISTA DE AUTOCOMPLETAR

A

ALT + ⬇️

60
Q

ABRIR CUADRO DE DIALOGO INSERTAR FUNCION

A

SHIFT + F4

61
Q

AUTOSUMA DE CELDAS SELECCIONADAS

62
Q

ACTIVAR O DESACTIVAR FORMULAS

A

CTRL + ’ (tecla de acento)

63
Q

MOSTRAR COLUMNA OCULTADA

A

CONTROL + SHIFT + 0

64
Q

MOSTRAR FILA OCULTADA

A

CTRL + SHIFT + 9

65
Q

AGRUPAR COLUMNAS O FILAS

A

ALT + SHIFT + ➡️

66
Q

DESAGRUPAR COLUMNAS O FILAS

A

ALT + SHIFT + ⬅️

67
Q

SELECCIONAR TODA LA FILA

A

SHIFT + ESPACIO

68
Q

SELECCIONAR TODA LA COLUMNA

A

CTRL + ESPACIO

69
Q

DIRIGIRSE HACIA LA ULTIMA CELDA QUE CONTIENE DATOS

A

CTRL + ⬇️