Excel

Question 1

macros

Answer 1

sub

Question 2

sumar

Answer 2

function

Question 3

into mode PROGRAMADOR

Answer 3

ALT + F11

Question 4

what is the format ??
-sheet
-macro

Answer 4

xlsx
xlsm

Question 5

contar con intervalos

Answer 5

=+CONTAR.SI(todo;A10)
=+CONTAR.SI(todo;”>=”&A10)
=+CONTAR.SI.CONJUNTO(todo;”>=”&A10;todo;”<”&B10)

Question 6

concat strings

Answer 6

a1=”one”
b1=”two”

=a1&b1 => onetwo

Question 7

Jj

Answer 7

Jjjj

Question 8

select spaces

Answer 8

F5

Question 8

buscar v

Answer 8

=BUSCARV(“Producto A”, A:B, 2, FALSO)
falso=search the value exact

Question 8

desabilitar bloqueos de macro

Answer 8

change the extension of XSML to RAR

search; DPB=”sadhjf”
change with; DPX=”asdjfklñ”