ĵ - רҵдķϷվ
ҳ > ѧ >  > 800 >

【重庆专升本 文科】Excel专项练习(含答? - 百度文库

ʱ䣺 ղ ҪͶ

쿪ʤ 1.ExcelExcelԶһΪ___C__Ĺ

Aĵ1 BSheet1 CBook1 DEXCEL1

2.ExcelУһ¹Ĭ___C__

A1 B10 C3 D5 3.ExcelУ ______D_______ɡ

A65535к255 B65536к255 C65535к256 D65536

к256

4.ExcelУڱʾͬһڲͬеĵԪʱ뵥Ԫ֮Ӧʹ_____A____ֿ

A ! B : C , D ; 5.ExcelУSheet2!C2еSheet2ʾ_____A_____

A B C Ԫ D ʽ 6.Ҫرչ˳ExcelԵ__A___

Aļ˵еġرա Bļ˵еġ˳

CرExcelڵİť

7ʹExcelӱ___D__ڱ湤˳Excel AҶExcel97ڵĹرհťx

BExcel ڵĿƲ˵ť ѡСرա CݼAlt+F4 DݼCtrl+S

8ExcelĵԪҪַʽ绰ʱӦַ_D

1

Dڡ˵еġء

·

쿪ʤ A:ðţ B, ţ C = Ⱥţ D ' Ʋţ

9.ExcelУѡȡԪʱ ָΪ___B__

A Bʮֹ Cͷ Dȷ

10.ڵԪA2__B___ʹʾ0.4

A2/5 B=2/5 C=\ D\11.ExcelÿԪУ____A_____ַ A32000 B256 C2000 D2400 12. ExcelУûڹڣ___D______ʽڸʽ

A10-01-99 B01-OCT-99 C1999/10/01 D10/01/99 13.Excelļ͵___D__

Aֻ.XLS Bֻ.XLT Cֻ.XLW D.XLS.XLT.XLW

14.Excel½ǵĵԪĵַ ___D__

AIV65535 BIU65535 CIU65536 DIV65536

15.ExcelĹѡȡĵԪķ_____A____

Aסctrlţѡ Bסshiftţѡ Cסshift굥½ǵԪ Dֱ϶

16.ExcelУͬʱѡڵĹڰס__C___ͬʱεıǩ

ATab BAlt CShift DCtrl 17.ExcelУɴ___D__

A254 B256 C16 D255

2

·

쿪ʤ 18___C__뵽ExcelĵԪС

A=\ B3,7.5 C=3,7.5 D=Sheet1!B1+7.5 19.ExcelA2Ԫ롰=56>=57ʾΪ__D__

A56<57 B=56<57 CTRUE DFALSE 20.ExcelĹA2ԪУ롰=5^2ʾΪ___C_____ A10 B#NAME? C25 D5^2 21Excel԰ѹתWebҳ___A__ʽ

AHTML BTXT CBAT DEXE 22.ExcelУڹĵԪСӢĵݣԪ__D___ Aı Bı Cı֡߼ֵ Dı֡߼ֵֵ

23.ExcelУ_____D___ܽһԪ롣 Aس BTab C༭еġ̡ť Dո Eƶ

24.ExcelУA1 Ԫʽ趨䡰ַࡱΪٷֱȡ롰49ʱʾΪB

A49 B49% C4900% D0.49% 25.ExcelУбʾΪ___B__

A1 2 3 BA B C Cףң DI IIIII 26.ExcelУǰԪֵʱĬΪ__C___

A B CҶ D 27.ExcelУǰԪֻ___A__

AԪָѡһ Bѡеһ Cѡеһ Dѡе 28.ExcelУA1Ԫ趨ָʽΪ롰33.51ʱʾΪ_C____ A33.51 B33 C34 DERROR

3

·

【重庆专升本 文科】Excel专项练习(含答? - 百度文库

쿪ʤ1.ExcelExcelԶһΪ___C__ĹAĵ1BSheet1CBook1DEXCEL12.ExcelУһ¹Ĭ___C__A1B10
Ƽȣ
ĵĵΪdocʽ

ѡͼ

71ebo1rorc0ne2d1fovz9epjx24qp9012si
ȡ

΢ɨȡ

΢ɨ