|
Nome:
|
|
|
Professor: Márcio Adriano
|
CONCATENAR / &
=CONCATENAR(REF1;REF2) Ou
=CONCATENAR(REF1&REF2) Ou =REF1&REF2
|
LISTA
DE IPS
|
|||
|
Estação
|
Prefixo
|
IP
|
Endereço
IP
|
|
DIR-01
|
192.168.0.
|
101
|
=CONCATENAR(B2;C2)
|
|
DIR-02
|
192.168.0.
|
102
|
192.168.0.102
|
|
COOD
|
192.168.0.
|
103
|
192.168.0.103
|
|
COMERCIAL
|
192.168.0.
|
104
|
192.168.0.104
|
|
RECEP
|
192.168.0.
|
105
|
192.168.0.105
|
|
TLMK
|
192.168.0.
|
106
|
192.168.0.106
|
|
VIP01
|
192.168.0.
|
107
|
192.168.0.107
|
|
VIP02
|
192.168.0.
|
108
|
192.168.0.108
|
|
RESERVADO
|
192.168.0.
|
109
|
192.168.0.109
|
|
RESERVADO
|
192.168.0.
|
110
|
192.168.0.110
|
|
LAB01-01
|
192.168.0.
|
111
|
192.168.0.111
|
|
LAB01-02
|
192.168.0.
|
112
|
192.168.0.112
|
|
LAB01-03
|
192.168.0.
|
113
|
192.168.0.113
|
|
LAB01-04
|
192.168.0.
|
114
|
192.168.0.114
|
|
LAB01-05
|
192.168.0.
|
115
|
192.168.0.115
|
|
LAB01-06
|
192.168.0.
|
116
|
192.168.0.116
|
|
LAB01-07
|
192.168.0.
|
117
|
192.168.0.117
|
|
LAB01-08
|
192.168.0.
|
118
|
192.168.0.118
|
|
LAB01-09
|
192.168.0.
|
119
|
192.168.0.119
|
|
LAB01-10
|
192.168.0.
|
120
|
192.168.0.120
|
|
LAB02-01
|
192.168.0.
|
121
|
192.168.0.121
|
|
LAB02-02
|
192.168.0.
|
122
|
192.168.0.122
|
|
LAB02-03
|
192.168.0.
|
123
|
192.168.0.123
|
|
LAB02-04
|
192.168.0.
|
124
|
192.168.0.124
|
|
LAB02-05
|
192.168.0.
|
125
|
192.168.0.125
|
|
LAB02-06
|
192.168.0.
|
126
|
192.168.0.126
|
|
LAB02-07
|
192.168.0.
|
127
|
192.168.0.127
|
|
LAB02-08
|
192.168.0.
|
128
|
192.168.0.128
|
|
LAB02-09
|
192.168.0.
|
129
|
192.168.0.129
|
|
LAB02-10
|
192.168.0.
|
130
|
192.168.0.130
|
|
DNS
|
208.67.222.222
|
||
|
208.67.220.220
|
|||
|
GATEWAY
|
192.168.0.1
|
||
Nenhum comentário:
Postar um comentário