???? ??

Select the product you need help with

Excel 2010 SP1 ?? ???-????????? ????????? ??? ????????? ??????? ???

???? ID: 2551525 - ?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.

??? ?? ??????? ???? | ??? ?? ??????? ????

????? ??????? ??????, ??????? ????? ???? ???? ???? ??????????? ?? ???? ??????????? ?? ???? ???? ????? ?? ????? ???? ???? ??????? ??? ?????? ???? ?? ???, Microsoft Excel 2010, Microsoft Excel Services 2010 ?? Microsoft Excel Web App 2010 ?? ??????? ????????? ??? ??? Excel ??????? ?? ???????, ?????????? ?? ????? ???

(http://office.microsoft.com/hi-in/excel-help/what-s-new-changes-made-to-excel-functions-HA010355760.aspx)

.

???? ??????, ??? �?????� ???? ??? ?? ??????? ?? 10 ????? ?????? (???, ?????, ??, ??????, ??????????, ?????????, ?????????-????????, ???????, ??????? ?? ??????) ??? ????-?????????? ???? ???. ???? ?????? Excel 2010 ??? ??????? ??????? ??? ?? ???? ?????? Microsoft Excel 2007 ??????? ???�???? ??? ???? ?? #NAME? ?????? ???? ??. ?? ?? Excel ?? ????? ????????? ?? ?????? ??? ???? Excel 2010, Excel Services 2010 ?? Excel ??? ??? ?????? ??? ??? ????????????? ????? ???, ?? ??????? ??????? ??? ????????? ???? ??.

?????? ??????????? ?? ????, Microsoft ??�??�?????�???? ??? ???? ???? ??????? ?? ???? ???? Excel 2007 ?????????? ????? ??? ?????? ?? ?????? ???? ??. ??????? ????? ?? ???? 2007 ????? ??? ?????? ?? ???, Microsoft Office 2010 Service Pack 1 ??????? ????.

??????

???????? ???? ??? VLOOKUP ??????? ?? ??? Excel 2007 ?? ??????? BUSCARV ??. ???????, Excel 2010 ??? ??????? ??? CONSULTAV ??? ????????? ?? ???? ???. ??? ?? Excel 2010 ?????-SP1 ??? BUSCARV ?? ???? CONSULTAV ???? ???? ???, ?? ???? ?? #NAME? ?????? ??????? ????.

?? ??????? ?? ??????????? ???? ?? ???, Excel 2010 ?? ??????? ??????? ??? ?? ????? ?? ???? ????:

?? ?? Excel ????????????? ?????.
???? A1 ??? 1 ????? ?? ??? ???? A2 ??? 2 ?????.
???? B1 ??? a ????? ?? ??? ???? B2 ??? b ?????.
???? D1 ??? 1 ????? ?? ??? ???? D2 ??? =BUSCARV(D1,A1:B2,2) ?????.

??? ???? Service Pack 1 ??????? ???? ???? ??, ?? ???? ?????? Excel 2010 ??? =BUSCARV(D1,A1:B2,2) ???? ???? ?? ???? ??????�#�NOMBRE?�??????? ????. ???? ?????-SP1 Excel ??????? ??? ???? ???? ?? ??? ??? ??????? =CONSULTAV(D1,A1:B2,2) ??.

???????,�?? ??�Service Pack 1 ??????? ??????, ?? ????�??????�#�NOMBRE? ??????? ???? ??? ??�Excel 2010 ??? =CONSULTAV(D1,A1:B2,2) ???? ???? ???.�???? ?????-SP1 Excel 2010 ??????? ??? ???? ???? ?? ??? ??? ???????�=BUSCARV(D1,A1:B2,2) ??.

????? ?? ???? ???? | ??????????? ???

???? ???????

?????? ??? 1 ??????? ?? ???? ?? ???, ?????-SP1 Excel 2010 ??????????????? ???? Excel ?? ????? ????????? ??? ???? ?? ??? ????????????? ???????? ??? ?? ??????? ??????? ??? ????????? ???? ???. ??????? ????? ?? ????? ?? ??? ??????? ?? ???? ???? ???? ???? ????? ??.

Office 2010 SP1 ??????? ??? ??????? ???? ?? ???, Microsoft ????? ??? ???? ?? ????:

2460049 - Office 2010 SP1

(http://support.microsoft.com/kb/2460049/hi)

?? ?????

??????????? ???????? ?? ???, ???? ?????? ?? ???? ?? ????? ?? ???? ?? ??? Microsoft ????? ??? ???? ?? ????:

2460043 - Office 2010 ???? ??? SP1

(http://support.microsoft.com/kb/2460043/hi)

?? ?????
2460073 - Office ??? ????????? SP1

(http://support.microsoft.com/kb/2460073/hi)

?? ?????
2460056 - Office Servers 2010 ???? ??? SP1

(http://support.microsoft.com/kb/2460056/hi)

?? ?????
2460044 - Office ???? ???????? ??? 2010 SP1

(http://support.microsoft.com/kb/2460044/hi)

?? ?????
2460045 - SharePoint Server 2010 SP1

(http://support.microsoft.com/kb/2460045/hi)

?? ?????
2460047 - SharePoint and Project Server 2010 SP1

(http://support.microsoft.com/kb/2460047/hi)

?? ?????

??????? ?? ???? ????????

????? ?????? ?????? ??? 1 ?????? ??????? ?????? ?? ??????? ?????? ???? ??.

???
????? ?????? �?? ??? ?????????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
IFERROR	CHYBHODN	IFERROR
LEFT	VLEVO	ZLEVA
NOT	NEN�	NE
RIGHT	VPRAVO	ZPRAVA
TEXT	TEXT	HODNOTA.NA.TEXT

?????
????? ??????�?? ????? ?????????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
AVERAGE	GENNEMSNIT	MIDDEL
AVERAGEIF	GENNEMSNIT.HVIS	MIDDEL.HVIS
AVERAGEIFS	GENNEMSNIT.HVISS	MIDDEL.HVISER
COUNTIFS	T�L.HVISS	T�L.HVISER
CUBEKPIMEMBER	KUBEKPIMEDLEM	KUBE.KPI.MEDLEM
CUBEMEMBERPROPERTY	KUBEMEDLEMSEGENSKAB	KUBEMEDLEM.EGENSKAB
CUBERANKEDMEMBER	KUBERANGERETMEDLEM	KUBERANGERET.MEDLEM
CUBESET	KUBE.ANGIV	KUBES�T
CUBESETCOUNT	KUBE.ANGIV.ANTAL	KUBES�T.ANTAL
DAVERAGE	DGENNEMSNIT	DMIDDEL
DOLLAR	VALUTA	KR
FLOOR	GULV	AFRUND.GULV
GCD	F�LLES.DIVISOR	ST�RSTE.F�LLES.DIVISOR
HYPERLINK	LINK	HYPERLINK
IFERROR	HVISFEJL	HVIS.FEJL
INT	HEL	HELTAL
ISERR	ER.FE	ER.FJL
LOOKUP	OPSLAG	SL�.OP
MODE	TILSTAND	HYPPIGST
N	N	TAL
OCT2DEC	OCT.TIL.DEC	OKT.TIL.DEC
RECEIVED	MODTAGET	MODTAGET.VED.UDL�B
RIGHTB	H�JRE_B	H�JREB
SUMIFS	SUM.HVISS	SUM.HVISER

????? ??????�?? ????? ?????? ????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
RESET.TOOLBAR	NULSTIL.V�RKT�JSLINJE	GENDAN.V�RKT�JSLINJE
TEXT.BOX	TEKSTFELT	TEKSTBOKS

??
????? ??????�?? ?? ?????????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
CHOOSE	KIES	KIEZEN
CLEAN	SCHOON	WISSEN.CONTROL
DAVERAGE	DGEMIDDELDE	DBGEMIDDELDE
DAYS360	D360	DAGEN360
DCOUNT	DAANTAL	DBAANTAL
DGET	DHAAL	DBLEZEN
DOLLAR	VALUTA	EURO
DSTDEV	DSTDEV	DBSTDEV
DSUM	DSOM	DBSOM
FIND	VINDEN.ALLES	VIND.ALLES
LOOKUP	OPZOEKEN	ZOEKEN
LOWER	KLEINELETT	KLEINE.LETTERS
MID	MIDDEN	DEEL
NPV	HNW	NHW
PMT	AFLOSSING	BET
PROPER	BEGINKAP	BEGINLETTERS
REPLACE	VERVANG	VERVANGEN
ROUND	AFRONDING	AFRONDEN
SLN	RAA	LIN.AFSCHR
SQRT	VWORTEL	WORTEL
UPPER	HOOFDLETT	HOOFDLETTERS
VALUE	GETAL	WAARDE
VDB	VAP	VDB

????? ??????�?? ?? ?????? ????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
BREAK	EINDE	ONDERBREKEN
FOR	VOOR	VAN
GOTO	GANAAR	GA.NAAR
GROUP	GROEP	GROEPEREN
NOTE	OPMERKING	NOTITIE
RESTART	OPNIEUW	OPNIEUW.STARTEN

??????
????? ??????�?? ?????????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
FIND	RICER	TROVA
MINUTE	MINUTI	MINUTO
SECOND	SECONDI	SECONDO

??????????
????? ??????�?? ?????????? ?????????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
CHAR	TEGN	TEGNKODE
CLEAN	RYDD	RENSK
IPMT	RANNUITET	RAVDRAG
ISPMT	ER.ANNUITET	ER.AVDRAG
MAX	MAKS	ST�RST
PMT	ANNUITET	AVDRAG

????? ??????�?? ?????????? ?????? ????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
NEXT	NEXT	NESTE

?????????
????? ??????�?? ????????? ?????????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
FIXED	FIXO	FIXA
NA	ND	N�O.DISP
USDOLLAR	MOEDA2	MOEDA.EUA

????????? - ????????
????? ??????�?? ????????? - ???????? ?????????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
COLUMN	COLUNA	COL
FACT	FATO	FATORIAL
FIXED	FIXO	DEF.N�M.DEC
FREQUENCY	FREQU�NCIA	FREQ��NCIA
MIN	M�N	M�NIMO
PRODUCT	PRODUTO	MULT
RECEIVED	RECEBIDO	RECEBER
SEARCH	PESQUISAR	LOCALIZAR
SERIESSUM	SOMAS�RIE	SOMASEQ��NCIA
STDEV	DESVPAD.N	DESVPAD
TRUNC	TRUNC	TRUNCAR
VAR	VAREST	VAR

????? ??????�?? ????????? - ???????? ?????? ????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
DATE.STRING	CADEIA.DATA	DATA.S�RIE
ENABLE.COMMAND	HABILITAR.COMANDO	ATIVAR.COMANDO
ENABLE.TOOL	HABILITAR.FERRAMENTA	ATIVAR.FERRAMENTA
EXECUTE	EXECUTAR	EXECUTE
FCLOSE	ARQ.FECHAR	ARQN.FECHAR
GET.WORKSPACE	INFO.ESPA�O.TRABALHO	INFO.�REA.TRABALHO
LINKS	LINKS	V�NCULOS
NUMBER.STRING	CADEIA.N�MERO	SEQ��NCIA.N�MERO
REGISTER	REGISTRAR	REGISTRO
RESUME	CONINTUAR	REINIC

???????
????? ??????�?? ??????? ?????????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
CHAR	CAR	CARACTER
CONVERT	CONVERT	CONVERTIR
DATEVALUE	VALFECHA	FECHANUMERO
DAYS360	D�AS360	DIAS360
DCOUNT	BDCUENTA	BDCONTAR
HLOOKUP	CONSULTAH	BUSCARH
IFERROR	SIERROR	SI.ERROR
MID	MED	EXTRAE
MOD	RESTO	RESIDUO
MODE	MODO	MODA
NA	ND	NOD
SQRT	RCUAD	RAIZ
TBILLEQ	LETRA.DE.TES.EQV.A.BONO	LETRA.DE.TEST.EQV.A.BONO
TIME	TIEMPO	NSHORA
TIMEVALUE	VALHORA	HORANUMERO
TRIM	RECORTAR	ESPACIOS
VLOOKUP	CONSULTAV	BUSCARV

????? ?????? ??�??????? ?????? ????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
GOTO	IR	IR.A
NEXT	SIGUIENTE	SALIR.BUCLE
RETURN	DEVOLVER	VOLVER

???????
????? ??????�?? ??????? ?????????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
CLEAN	RENSA	ST�DA
DAYS360	D360	DAGAR360
DDB	DFAV	DEGAVSKR
FALSE	FALSK	FALSKT
HLOOKUP	HTS�K	LETAKOLUMN
HOUR	TIM	TIMME
ISNA	�RET	�RSAKNAD
ISNUMBER	�RNUM	�RTAL
ISTHAIDIGIT	?RTHAISIFFRA	ISTHAIDIGIT
LEFT	V�NSTERPIL	V�NSTER
LOWER	SM�	GEMENER
MID	MITT	EXTEXT
MODE	L�GE	TYPV�RDE
N	I	N
NA	ET	SAKNAS
NPV	NVLF	NETNUV�RDE
PMT	AVBET	BETALNING
PV	NV	NUV�RDE
RATE	PRS	R�NTA
RIGHT	H�GERPIL	H�GER
SLN	LNA	LINAVSKR
SYD	�ATP	�RSAVSKR
TRIM	ST�DA	RENSA
TRUE	SANN	SANT
UPPER	STORA	VERSALER
VLOOKUP	VTS�K	LETARAD

??????
????? ?????? ?? ?????? ?????????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
SUM	TOPLAM	TOPLA

????? ??????�?? ?????? ?????? ????? ??????? ?? ???????? ???? ?? ??????? Service Pack 1 ??? ????????? ?? ???? ???:

?? ?????? ?? ??????? ?????? ?????? ?? ??????? ????

???????? 2010 ???????	Excel 2010	Excel 2010 SP1
GET.MOVIE	AL.FILM	GET.MOVIE
MOVIE.COMMAND	FILM.KOMUT	MOVIE.COMMAND

????? ?? ???? ???? | ??????????? ???

Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use

(http://go.microsoft.com/fwlink/?LinkId=151500)

for other considerations.

????? ?? ???? ???? | ??????????? ???