![Page 1: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/1.jpg)
FEP-UP © Luís Torgo
DATA, SORT
![Page 2: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/2.jpg)
FEP-UP © Luís Torgo
Selecção de registos (filtragem)
![Page 3: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/3.jpg)
FEP-UP © Luís Torgo
Filtragem avançada (DATA, ADVANCED FILTER)
![Page 4: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/4.jpg)
FEP-UP © Luís Torgo
![Page 5: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/5.jpg)
FEP-UP © Luís Torgo
![Page 6: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/6.jpg)
FEP-UP © Luís Torgo
Funções de Bases de Dados
<Função>(RangeDaBD,NomeDoCampo,RangeDoCritério)
Exemplo :
Funções :DSUM, DVARDCOUNT, DSTDEVDAVERAGE, DMINDMAX
![Page 7: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/7.jpg)
FEP-UP © Luís Torgo
Funções de Procura - VLOOKUP e HLOOKUP
VLOOKUP(Valor;Tabela;ColunaPretendida)
Exemplo :
![Page 8: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/8.jpg)
FEP-UP © Luís Torgo
Procurar valores numér icos
Se um valor não éencontrado, é usado omaior valor, menor ouigual ao valor a pocurar.
< 0 dá erro[0..7,5[ dá “REPROVADO”[7,5..9,5[ dá “ORAL”>= 9,5 dá “APROVADO”
![Page 9: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/9.jpg)
FEP-UP © Luís Torgo
Gráficos
![Page 10: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/10.jpg)
FEP-UP © Luís Torgo
![Page 11: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/11.jpg)
FEP-UP © Luís Torgo
![Page 12: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/12.jpg)
FEP-UP © Luís Torgo
![Page 13: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/13.jpg)
FEP-UP © Luís Torgo
Distribuição de Vendas por Clientes
XYZ16%
KKK12%
DDD17%
DAD47%
JLF8%
![Page 14: DATA, SORT - DCCltorgo/Ensino/FEP/Acetatos/ea.pdfAdvanced Filteí Action Filter the list, in-place Cgpy to another location t range: iteria range: Advanced Filter Action 'DADE Cancel](https://reader036.vdocuments.us/reader036/viewer/2022090715/60ef1d00c122ee4f8a0dd3c3/html5/thumbnails/14.jpg)
FEP-UP © Luís Torgo
Funções FinanceirasFV(Taxa,N.Períodos,Renda,ValorInicial,Tipo)Valor futuro de um depósito fixo feito durante N períodos a uma determinada taxa de juro por período, tendo sido depositado um determinado valor inicial. Tipo igual a 0 se o depósito é feito no fim de cada período, ou 1 se é feito no início.
PV(Taxa,N.Períodos,Renda,ValorInicial,Tipo)Semelhante para saber o valor presente.