Tài liệu đề cương ôn tập thi tuyển viên chức giáo dục môn tin học văn phòng

UBND TiNH QUANG NAM HO BONG Till TUYEN HEN cHirc NGANH CIAO DUC NAM 2017 BE CCONG (Kern L CONG Hem Li HO CHU NGHIA VItT NAM Dec lep - Tv do - Hanh pink N STEN CH15'C GIAO DI,JC NAM 2017 VAN PHONG (Mon didu kien) 6: 27/TB-HD77' ngay 19/10/2017) DIEU HANH Cau 1. Trong Windows, A. Control System C. Control Panel cric tham sO thong, ta chpn chat rang: B. Control Desktop D. Control Windows Can 2. Di Nit hoc tit thanh c8ng cy trong cfra se Windows, thao tac nao duti day la Wing thing? Nhay chuet phai vao vang tong tren thanh bang chgn hoc thanh cong cii, sau do then ten thanh cling cp. Chpn View, chgn Toolbar, sau d6 dice ten thanh cong cp. Nhan Alt + V + T, sau d6 chgn ten thanh cling cp. Chgn Insert, chgn Toolbar, sau d6 chgn ten thanh c8ng cp. flu 3. Trong Windows, khi thpc hien thao tic x6a dOi tuvng (thy my; tep tin) duvc chip ma kheng gift phim Shift thi:‘ Mgi doi tugng bi x6a deu dugc din vao Recycle Bin. Doi liming bi xga së 'thong dugc din vao Recycle Bin. CM c6 cac tap tin khi bi xoa m6i duqc din vao Recycle Bin con thu mpc thi Ichong. D6i tuqng hi xga dugc dua vao Recycle Bin (trir khi d8i tugng chfra trong dia mem, thiEt bi Flash,...). Cilu 4. Trong cam so Windows, a sip xep cfic did tuvng theo ten, ta chpn: A. View 4 Arrange Icons by 3 Size B. View 4 Arrange Icons by 3 Type C. View 4 Arrange Icons 4 Sort by 3 Name D. View 3 Arrange Icons by 3 Name Cau 5. Trong Windows, de chop cac dei tuvng Wing lien tip nhau, ta si dung thao tfic nio dtiti day? Chgn den tugng dâu, gift phim Shift, dung cat phim mui ten dE di chuyen &En doi tuvng Click tren dei tugng du, gift phim CM, click tren timg doi Urging can chgn. Click tren doi tugug Au, gift phim Shift, click tren timg dei tucmg can chgn.. , Chop dOi tagng dau, gift phim Oil, ding cac phim mai ten de di chuyen den doi tugng Can 6. Trong cfra sO Windows, de chpn cac dti hroyng lien tip nhau, ta sir dung thao tác nit° trong cfic thao tac sau: Click tren Mi tucmg Mu, gift phim Shift, click tren doi Urging cuoi Click hen d4i tugng Mu, gift phim Ctrl, click tren dei tuqng cu6i Click tren doi tugug dau, gift phim Alt, click tren doi tucmg cu4i Chpn dal tugng dau, gift phim Alt, dfmg cac phim mid ten de di chuyen dEn Jai tugng A• CUM flu 7. Phat bleu nio duel day 11 khong dung? A. Caz bieu tuong dm Shortcut co hinh E a goc &rot ben trai. De chuyen Mi cira só lam viec, ta nhay chuOt vao bieu tuyng tuang frng tren thanh cling viec. De chuy'en den cüa sO lam viec ta nhin giu phim Ctrl va an phim Tab nhieu Ian cho toi 'chi chucmg trinh ttrcmg üng duce dong lchung. De Mo Shortcut cho Mi Wang: Nhay gift chuOt phai tren doi Wong, keo vã tha den nai can too Shortcut, r6i nhay ch9n Creat Shortcuts Here trong bang chgn vira xufit hien. Cfiu 8. 'Chi met del twqng trong Windows (File, Folder, shortcut) dang dirge chyn, thao Mc go phim F2 cho phip ta: A. Xod doi ttryng. B. Doi ten dol. tucmg. C. Khong co Mc dung gi ca. D. Tao meri doi tuqng. Cfiu 9. Trong Windows, thao tic nao clang di chuyen Mi tulyng (tep, thu myc)? Nhay chuOt len d6i tucmg, gift phim Ctrl tong thad keo va tha chuOt tit vi tri ngution tai vj tri dich. Choc' doi tuong nguOn, nhAn Ctrl+X, mô thu mu° hoc dia muon di chuyen den, nhan Ctrl+P. Nhay gift chuOt len d6i tming, kdo va tha chu)t tir vi tri ngu6n teri vi tri dich. Ch9n d6i tuyng can di chuyen, nhan Ctrl+C, Si thu mac hoac dia nai muOn di chuyen den, nhAn Ctrl+V. a Cau 10. Trong Windows, trong cfra se Customize Regional Option, ta co' the thiet (tat ks, hieu phfin cich phAn nguyen va phan thap phan (kieu Number) & dau? A. Trang Number, trong Decimal symbol. B. Trang Number, trong Negative sign symbol. C. Trang Number, trong List Sepatator. D. Trang Number, trong Digit grouping symbol. am, a Cfiu 11. Trong Windows, trinh bay cic dei timing trong met cfra se duel clang chi tit, sau khi chyn lenh View ta chyn myc nao dtrii dfiy? A. Details B. Large Icons C. List D. Small Icons Can 12. Trong cic del tuvni chrii dfiy, Mi twqng nao chira the tep hoar thtr myc da xoti nhumg chwa bi x6a han, ea the phyc hei bang chi dinh Restore this (the selected / all) items? A. Recycle Bin B. My Computer C. My Briefcase D. Network Neighborhood Cfiu 13. Trong Windows, de tao folder mei, ta dung thao tic nao trong cac thao tac d u day? Chyn File New 9 chcon Folder. Click tren vung trOng dlla nai chin folder mot chon New 3 chyn Shortcut. Right Click tren vimg tons dm nth chira folder mei, ch9n New 9 chop Folder. Double Click tren vfmg tong cim nai chfra folder moi, ch9n New -> chqn Folder. Cau 14. Thao tic nao dung M sao chip del trying (tip, thu myc)? Nhay chuOt len doi tugng, gift phim Shift d6ng thth kdo va tha chuOt tir vi tri ngu6n tai vi tri &ch. Ch9n doi tugng nguOn, nhAn Ctrl+C, Si thu muc hoc dTa nai dat ban sao, nhAn Ctrl+V. Nhay chuOt len dOi tuyng, keo va tha chuOt tit vi tri nguon ten vj tri &ch. Chip doi tucmg nguon, nhan Ctrl+X, mer thu 'nue hoc cta nai dat ban sao, nhan Ctrl+V. Can 15; Chic nang cfia trinh *rig dyng Windows Explorer? ling dung dO h9a trong Windows Cac img ding ye xfr 1ST van ban dm Windows Quan l va khai tit& tai nguyen trong may firth nhu: 0 di-a, Folder, File,... Quail lY va Ichai thac tai nguyen tren mang Internet 2 .3 Cau 16. Trong Windows, ta co the clang thanh Task Bar de: Truy cap nhanh den cac trinh img dung hen dang sir dung. Tao cac Folders. Tao cac Shortcut. Tao cac cia so. IL PLANG MAY TiNH (14 cau) Ulu 17. Cfic may tinh trong Internet hoat gong vi trao del veri nhau dime 11 do chug cling sfir thing: A. be giao thirc truyen th8ng TCP/IP B. phucmg thirc truyen thong TIP/CP. C. be giao thirc IP/TCP. D. be giao thirc truyen thong TCP. Can 18. Phat bieu nao dual day khong thing? May lam viec vei dia chi IF clang so can ngued clang chi lam viec vai dia chi IP dang North ding co the lain viec vth tha chi IP clang so. Ngtrth dung co the lam viec voi dia chi IF clang Icy qr. May chit DNS chuyen doi dia chi clang k9 nr sang dang so de xir 12 dugc. Can 19. Trang Web tinh la trang Web: Chi c6 van ban va hinh arth, khong co hinh anh d'Ong va am thanh. CO nOi dung co thnh, Ichting the tuY bien theo you cau tir phia may khach. Chi c6 van ban, Am thanh vi hinh alt tinh. NOi dung !thong có san tren may phvc vg. Cau 20. Tim phat bleu sal v cac dich vy dine 118 try bid myng LAN trong die phat bleu neu direi day? A. Ding chung cac phan ' mem ling chmg. B. Dung chung cac thiet bi ngoai vi. C. Ming chung der lieu vi truyen tep. D. Cho phop ged va nhan thu then tir tren than cAu. Cmu 21. He thAng VVWW dirge cAu thinh tir cac trang Web vi duvc xay thyng chya train giao that truyen tin sieu van ban - WWW11 tir vat tit cüa cym tir nao dm% day? A. World Wide Web. B. World Wireless Web. C. Windows Wide Web. D. Wide Wireless Web. Can 22. HTTP 11 gi? giao that de truyen cac tep tin sieu van ban. ngon,ngd de tax) cac tep tin sieu van ban. qui lac de viet dia chi cilia mOt trang Web. qui Me phai tuthi tha khi giri va /Ibsen thu dien tfi. Can 23. NgOn riga. nho 11 nein net ding a 4.0 cfic thi lieu sieu van ban xem dirge bang trinh duyet web? A. HTTP B. URL C. HTML D. Java Can 24. Phil bleu nao trong clic phat bieu sau ire mang may tinh là khong dung? Mang khong day khong chi ket noi cac may tinh ma con cho phop ket nei cac dien thoai di dOng. Mang khting day ket nOi az may tinh bang song radi8, h&c xa heng ngoai, s6ng truyen qua ye tinh. Mang c6 day ket noi cac may tinh bang cap. Mang c6 day c6 the '14 cap den bat cir dia diem vi khong gian nao. Can 25. De ket nei mang khong day dot gifin: 3 A,. Chi can c6 diem truy cap khong day WAP. Chi can lap dat them Modem vao may tinh. Chi can lap dat them vi mang khemg day vao may tinh. Can co diem truy cap khong day WAY va mei may tinh tham gia mang phai c6 vi mang khong day. Cau 26. Meng tin tren Internet thuimg dirge tO chit diroi clang: A. van ban. B. am thanh. C. hinh anh. D. sieu van ban. Cruz 27. flu nio trong cic eau sau cho dinh nghia chinh xic nhit ve mang Internet? La mang sir dvng chung cho mei ngtreri, nguon da lieu da clang, phong pha. La mang din Ong c6 quy mo toan eau haat deng dua ten giao thirc TCP/IP. La mang cüa cac mang, c6 quy me toan cau. La moi tnrang truyen thong than cau dua tren ky thuat may glib. flu 28. Phit bleu nio du& day ve trang Web deng la dung nhAt? La trang Web cung cap kha nang tim hem thong tin hieu suat cao. La trang Web c6 nei dung dugc thuang xuyen cap nhat. C La trang Web c6 chin hinh anh va am thanh. D. La trang Web c6 kha nang Wang tac vei ngueri dung. Cau 29. Mang may tinh tap hop cac may tinh. Mang LAN. tap hop cac may tinh ducic n6i vai nhau bang cac thiet bi mang va tuan thit theo met quy u6c truyen thong. Mang INTERNET. Can 30. Trang Trang Web dau tien mer ra khi truy cap met Website. Trang Web ciia ca nhan. Trang Web hueng dan sir dung met Website. Din chi chinh thirc dm met Website. IA MICROSOFT WORD (60 alu) Can 31. Trong Word, de thay döi khoing cich le cila doan van bin trong van bin, sau khi chat' don vin bin do, ta that hien thao tic nio dm% day? Chen Edit 3 Chen Paragraph... rei xac dinh cac thiet dat trong muc Spacing trong hp tho0 Paragraph. Chen Spacing... trong bang ellen Format va thiet dat a moc Indentation. Chen Format 3 Chen Paragraph... rei xac dinh the thiet dat trong mix Indentation trong hep thoai Paragraph. Nhay nut Paragraph Spacing... tren thanh &Ong cu chuan. Cau 32. Trong Word, khi thao tic vOl bang, de dip nhieu ô duct chip thinh met 6, ta that hien thao tic lenh nio drill day? A. Format 4 Table 4 Split Cells... B. Table 3 Merge Cells. C. Format 4 Cells 4 Merge D. Table 3 Insert 4 Merge Cells. Cau 33. Chic ning chinh cila Microsoft Word le gi? A. Soan thao van ban. B. Tinh toan va lap bang bieu. C. Chu cac chucmg trinh ling chmg khac. D. Tao cac tep de Ilea. flu 34. Trong Word, main di hutng yin bin trong Text box, sau khi chop Text box, ta chip lenh: 4 A. Insert 4 Text Box... C. Format 4 Change Case... B. Format 4 Background... D. Format 4 Text Direction... Cau 35. Hay chyn phuxrng in ghep dung. De tyo chit cii Ion dAu doyn van trong Word, ta chyn: A. Format 4 Characters 4 Drop Cap... B. Tools 4 Drop Cap... C. Format 4 Drop Cap... D. Insert 4 Drop Cap... Cfiu 36. Trong Microsoft Word, khi soyn thao, nu di go het &mg nhtmg chin xong doyn van ban (Paragraph), an 'thing thing gO tip mid dung con lyi, ta thoc hien thao tac nao &rid day? An phim Enter Barn to hop phim Shift + Enter Bgm tO hop phim Ctrl + Enter Khong phai thao tic gi ca (Word ngat (long Iv dung). a a Can 37. Trong Word, phit bleu nao v viec dung phim di chuyen con tr6 van bin nhu dyed day lit kheing ding? A. End: dat con he van ban 6 cu6i &mg hien tai. B. Home: dat con tro van ban a &au clang hien tai. C. Shift + End: dit con fro van ban a ell& van ban. D. Ctrl + Home: dfit con tra van ban a du van ban. Can 38. Trong Word, hay chop phat bleu ding? Dinh clang kieu danh sach khong cho phep dung kieu ki tu in hoa A, B, C va ideu se La MA I, II, III,... Vic chen/x6a mOt hang dm bang dugc thgc hien tuong tut nhu chen/xOa mOt dang trong van ban. C..Khong co gi phan biet khi ding nut lenh Print tren thanh cOng cu va khi chgn File 0 Print de in van ban. D. CO the thiet dit ch'e dO in de in mOt hoac vai trang eta vAn ban. a Can 39. Trong Word, trong phat bieu die phat bieu duti dfiy, phat bieu nao dung? }Chi tim Idem va thay the tit (hay ctun tit) trong van ban, Word lain phan biet chit hoa vai chit throng. Khong the tim tit tn cUa mOt tit (ctun tit) trong van ban bkng each: Chip Edit 4 Replace. CO the tim vj tri elm mOt tit (hay ctun tit) trong van ban bang each: Chip Edit 4 Find. Khong the tim kiem va thay the mOt tit'(hay mOt cum tit) tieng Via (c6 don). Can 40. Trong Word, de dinh st trang t dng ta thoc hien lenh: A. Edit 4 Numbers Page... B. Insert 4 Numbers. C. Insert 4 Page Numbers... D. Format 4 Page Numbers... Cau 41. Trong Word, khi thao tic voi bang, Op nhieu 8 thanh mett 8, sau khi chyn cic 8 can gap, ta sir dyng cic lenh nhtr dtrai day. Thao tic lenh nao khong dung? Chgn Table 4 Merge Cells. Chop Edit 4 Table 4 Select All. Chip nitt lenh Iii tren thanh cling cu Tables and Borders. Nhay chuOt phai tin d6i tugng (Id chip 3 Chgn Merge Cells. a Can 42. Trong Word, nit lenh oi co tinh ding nao &rid day? Chuyen doi tuong duce chgn vao Clipboard. BO qua lenh Redo vim thi hanh. Chuyen d& tugng dugc chip den vj tri con trO hien thed. B6 qua lenh Undo vita thi hanh. 5 Can 43. Hay chi ra phit bieu sal trong the phat bieu vi viec clang tO hp the phim tit de thvc hien nhanh the thao tic duti day (trong Word)? A. Ctrl + C tacmg duong yeti lenh Copy. B. Ctrl + N dé tao mOt van ban mai. C. Cal + P tuang &rang yeti lenh Paste. D. Ctrl + A de chon toan be van ban. Cau 44. Trong Word, de can chinh nei dung ben trong ciaa fi (trong bang - da dirge chgn) so vsfri dc duirng vim, ta thvc hien thao tic lenh nao duel day? Chon Edit, chon Cell Alignment rai tuSr chon nit lenh tuong Chon Table, chip Cell Alignment rOi tuSr‘ chon nit lenh tucmg ang. Nhay chi* phai, chan Cell Alignment rei tuy chon nit lenh tucmg img. Chon Table, chon Sort rOi tuy chon nut Penh tucmg img. flu 45. Trong Word, de xem van ban trutc khi in, ta thvc hien lenh nao duel dfiy? A. Chon File 4 Print 4 Preview. B. Chon File 4 Print Preview. C. An to hop phim Ctrl + P. D. Choi). Edit 4 Preview Print. Cfiu 46. De to hang, ta thvc hien lenh nao chrfri dfiy? Insert 4 Table... 4 xac dinh so cot, so hang 4 OK Table 4 Insert 4 Select... 4 Xac dinh só cOt, so hang 4 OK. Table 4 Insert 4 Table... 4 Xac dinh so cOt, sá hang 4 OK. Table 4 Select... 4 Xac dinh so cOt, sO hang 4 OK. Cfiu 47. Trong Word, khi nhiy wit tren thanh ding cv chuin, dieu gi se xay ra? A. Doan van ban chira con tre se duce in ra. B. Toan b0 van ban se dugc in ra. C. Phan dang chon se duce in ra. D. Trang hien theri sê duot in ra. Cfiu 48. Trong Word, de hut ho lenh vira ban hitnh, ta thvc hien thao tic lenh nlo dual dfiy? A. An th hgp phim Ctrl + U. B. An ta hgp phim Shift + R. C. Chon Edit 4 Undo... D. Chon Edit 4 Redo... Cfiu 49. Trong Word, tO hp phim tit nao chnfoi dfiy twang ting voi lenh Edit 4 Replace...? A. Ctrl + E B. Ctrl + F C. Ctrl + H D. Ctrl + R Cfiu 50. Trong Word, lenh Table 4 Select 4 Column clang de: A. Chon hang B. Chip cOt C. Chip bang D. Chop Cfiu 51. Trong cac lenh fi• bang chon File (dm phim mini Word) sau dfiy, lenh nit° cho phip ching ta ghi nei dung tep dang son thao vao met tep khic vol ten mei? A. New... B. Print... C. Save As... D. Save Cfiu 52. Trong Word, chit thing curt nit lenh loci% Id tren thanh cling cy? A. Thiet dit kich err chit B. Xac dinh kich c trang in. C. Xac dinh khoang each giita cac doan van ban. Thay ai ti l Men thi van ban. Cfiu 53. Trong the ho phOng chit cho h dim u hanh Windows dirt dfiy, phfing chit. nao Wiling dung ma TCVN3? A. Anal B..VnCourier C..VnTime D..VnArial Can 54. Trong Word, de sao chip met dotal van bin dirge chip vao Clipboard, ta thvc hien thao tic nito dual day? A. Chip lenh Tools - Copy B. Chon menu View - Copy C. Chip lenh Edit - Copy D. Chon lenh File - Copy 6 Chu 55. Trong Word, sa• dyng tit how phim Ctrl + F twang dining veri thao tac lenh nal) duti day? A. Edit 4 Find Next... B. File 4 Find... C. Edit 4 Replace ... D. Edit 4 Find... Chu 56. Trong Word, Olt bieu nao duti day la sal? CO the thiet dat d'e in so trang a dAu trang hoc cuoi trang. Khi soan thao co the thiet ttt che de de Word tv tong danh so trang. De c6 the in met van ban thanh nhieu ban in, chon Penh File 4 Print... hoac nhan to hop phim Ctrl + P... De in toan be van ban thanh rthieu ban chi can nhan nut Print S tren thanh cong cu. Cau 57. Trong Word, khi thao tic Nrofri bang, a tich 8 dirge chyn thanh nhieu 8, ta thyc hien thao tic lenh nao dual diy? A. Table 4 Split Cells... B. Format 4 Table 4 Split Cells... C. Format 4 Cells 4 Merge D. Table 4 Merge Cells. Cau 58. Trong Word, a b4t / tit che do go chi A chiral (VI dy: 02), ta clang t6 hqp phim lenh nho duel dfiy? A. Ctrl + "=" B. Chon Superscript trong hp thoai Font. C. Ctrl va dAu "+" D. Ctrl + flu 59. Trong Word, a chin cfic Icy ty d#t biet, ta thye hien lenh nao dwiri day? Chip Insert 4 chop Symbol ... Chop lenh Edit 4 chip Symbol ... Nhay chuet phai tai vi tri man chen, chan Insert Symbol... Chon lenh Insert 4 chip Special ... Cfiu 60. Trong Word, man tyo diem dirng (Tab Stop), ta sir dyng lenh nit° dtriri day? A. Format 4 Tabs... B. Format 4 Cursor Stop... C. Format 4 Drop Cap... D. Format 4 Borders and Shading... Chu 61. Trong Word, a dang cira se son thio van bin, ta thye hien l'enh nao duti day? A. File 4 Exit. B. File 4 Close. C. Edit 4 Exit. D. Window 4 Exit. flu 62. Trong Word, khi thao tic v61 bang, phat bieu nit° dirCri day khong dfing? Be to bang: Chon Table 4 Insert 4 Table ... 4 Xac dinh s6 cOt, s6 hang 4 OK. CO the six dung nUt lenh Insert Table tren thanh ding cp d to bang. Van ban ben trong 0 dm bang duce dinh clang nhu van ban thong thuang. Khong the tach met 8 (Cell) trong bang thanh nhieu 0. Cfiu 63. Trong Word, a xoti cã cQt trong bing, ta chyn myc nao trong hp thoyi Delete Cells? A. Delete entire column B. Delete entire row C. Shift cells up D. Shift cells left Can 64. Trong Word, phat bleu nio duel day là khang dung? CO the thuc hien viec cher', xod, tach hoc gep cac 0, hang va cet clia bang. Trong bang, ta co the thve hien dirge cac phep firth voi (tit lieu ideu s6. De hien thi thanh c8ng cv Tables and Borders ta ch9n lenh View 4 Toolbars rai chon Tables and Borders. Khong the thuc hien dirge viec sap xep du lieu trong bang. Cau 65. Trong Word, khi thao tic viki bang, thao tic lenh nham de xofi cOt da dirge chyn? A. Nhan phim Delete hoc Backspace. B. Table 4 Delete 4 Columns C. Table 4 Delete 4 Rows D. Format 4 Table 4 Delete 7 Can 66. De tat che d xem yin ban truirc khi in (clang cira sto Preview), ta thyc hien lenh nio dual day? A. Nhay nut close tren thanh dog cy. B. Chop File 4 Exit Chip View 4 Exit D. Chon File 4 Close flu 67. Trong Word, phat bleu nao dual day kh6ng dung? De gych chan met tir/cym tix dugc chon, ta thyc hien l'enh: Ctrl + U De in dam met tirktun tir duce chop, ta thtrc hien lenh: Ctrl + B De in nghieng ruet tir/cym tCr dugc chon, ta thyc hien l'enh: Shift + I De can giaa phan van ban &roc chop, ta thyc hien lenh: Ctrl + E a Cfiu 68. Trong Word, thay di c& chit ctia met nham ki ty di chyn, ta thyc hien lenh Format 4 Font... rOi chip cat chit trong: A. Font B. Small caps C. Font style D. Size Cfiu 69. Trong cac each sip xep trinh fir cling viec dm% day, trinh fly nlo la hgp 11 nhat khi so3n thfio met van ban trong Word? GO van ban 3 In An Chinh sin. 9 Trinh bay. GO van ban 9 Chinh sira 4 Trinh bay 4 man. GO van ban 4 Trinh bay 4 Chinh sira 3 man. GO van ban 9 Trinh bay 4 m an 9 Chiral sin.. tau 70. De mo• hp tho3i Find and Replace nham tim kiem va thay the mat tir hay cym tir nio do, ta thyc hien lenh nao cluti day? A. Chon Edit 4 Find and Replace. B. Nhan to hop phim Ctrl + H. C. Nhan tO hop phim Ctrl + R. D. Chon Insert 4 Replace. Can 71. Trong Word, lenh Table 4 Select 4 Cell dfing de: A. Chip hang B. Chou cet C. Chip 8 D. Chip bang Cfiu 72. Trong Word, phat bieu nlo dtrai day khong dung? Kich chuet vao nut l'n1-1 X tucmg throng vol sir dung tó hop phim Ctrl+C. Kich chuet vao nitt 14'nh S tuang throng vad sir dung t8 hop phim Ctr1+0. Kich chuet vac) mit Itnh L Prong throng voi sir dyng to hop phim Ctrl+V. Kich chuet van nut 14'nh 12 Wang throng vol sir dung to hop phim Ctrl+S. Can 73. Trong Word, cin phfii nhfin gift phim nao trong khi keo thfi chuet (Drag and Drop) nhilm sao chip (lei tirgng dirge chip tir vi tri nay tOl vi tri khac trong van bfin? A. Phim Ctrl. B. Phim Alt. C. Ca hai phim Ctrl va Alt. D. Phim Shift. Can 74. Phat bieu nito dual day II dung? He son thao van ban quan 11 ty &Ong viec xueng clang trong !chi ta gO van ban. He soyn thao van bim ty deng phan cach ode tir trong met cau. Cac h sop thao deu co si.'n phan mem xir 19 chit Viet nen ta có the sop thao van ban chit Viet. Trang man hinh va trang in ra giAy Won có cimg kich thuot. a Can 75. Trong Word, main dfnh clang van ban kiiu danh sich, ta thyt hien lenh: A. Edit - Bullets and Numbering... B. File - Bullets and Numbering... C. Tools - Bullets and Numbering... D. Format - Bullets and Numbering... Can 76. Trong Word, each nio trong cac each sau day cho pile') sir dyng bin phim d mo• bing chip7 Nhan gift dong thed him Shift va Alt rei gra k9 ty duce gych chan trong ten bang chon. Nhan gift phim Alt roi ge k9 ty duce gach than trong ten bang chon. 8 Nhan gift phim Ctrl rki go Icy ty three gach chan trong ten bang chart Nhan gift phim Shift red go Icy tv &rat gach chan trong ten bang chip. Call 77. Trong Word, de xoa phan van ban dugc chyn vi km vito be nit& dm, thao tic lenh nho thrill day khong dung? A. Nhan tO hap pit Ctrl + X. B. Chan Edit 4 Paste. C. Chan Edit 4 Cut. D. Nhay nut A tren thanh cling cp. Can 78. Trong Word, de thyc hien viec tyo tieu a au vi cal cho trang van biin, ta dung lenh nao dirt day? A. Cho View, than Comment. RCnViecclçnHataitjFooter,... C. Chan Insert, chan Header and Footer,... D. Chan Insert, chart Comment. Caul 79. Trong Word, a dinh clang trang van ban, ta thyc hien lenh: A. File 4 Page Setup... B. Insert 4 Page Numbers... C. Edit 4 Page Setup... D. Insert 4 Page Setup... Cau 80. KM thank cling cy tren man hinh wan thao Word bi mat, lam the nal) de hien thi lai chting? Thoat kited chuong trinh Word Icheri dOng lyi. Vao menu View, chgn Toolbars, sau do chgn ten thanh clang en can Men thi. Ch9n file, chgn Properties. Cai dt lyi toanb0 chuong trinh MS-WORD. Cau 81. Trong Word, lenh Edit 4 Cut twang dtricng voi ta" hop phim tit nio dual day? A. Ctrl + V B. Shift + C C. Ctrl + C D. Ctrl + X Cau 82. Trong Word, de xoft ca hang trong bang, ta ch9n myc nio trong hgp thoai Delete Cells? A. Shift cells left B. Delete entire row C. Delete entire column D. Shift cells up Cau 83. Trong Word, lenh File 4 Print Preview dung de: A. In van ban. B. Dinh dung trang van ban. C. Danh den phan van ban se in. D. Xem van ban tnrac khi in. Cau 84. Trong Word, voi kieu go Telex, degO cym tir "Hoc, hgc nfra, hoic each gO nao direi day 11 ding? A. Hocj, hocj nuwar, hjoc maxi! B. Hojc, hojc nwax, hojc mair! C. Hojc, hojc niax, hojc mair! D. Hocj, hocj niax, hocj maix! Cau 85. Trong Word, hihQ phim Ctrl + Enter dung de: Nfat trang tyi vi tri con trO van ban. Ket thee doan van ban, chuyen sang doan mai. Ket thac met doan van ban, !dieing sang don meri. Dinh dau doan van ban hien tai. Cau 86. Trong Word, di Wit / tat chi do go chi sift tren (Vi dy: x2), ta thtyc hien lenh nao dtrii day? A. Nhen t6 hgp phim Ctrl + "- " B. Chan Superscript trong hp thoai Font. C. Chon Strikethrough trong hp thoyi Font. D. Cho Subscript trong hp thoyi Font. Call 87. Trong Word, cic phat bieu sau, phat bieu nao sal? De chcon mOt cgt nao do trong bang, nhay chugt tyi vien tren caa ô tren ding dm 01 do. De chan met hang nao do trong bang, nhay chuet ben trai caa hang do. Del chan toan bang, nhay chuOt tai dinh goo tren ben phai caa bang. De chan met 8 nao do trong bang, nhay chuet tai canh tTai caa 6 do. 9 Cfiu 88. De k'et thee phien lam viec vol Microsoft Word, ta thvc hien lenh nito duiri dfiy? A. File 4 Close. B. File 4 Exit. C. Edit 4 Exit. D. Window 4 Exit. Cfiu 89. Trong Word, minim chin hinh finh, chit nghe thuitt, bieu a... ta chon: A. Format 4 Picture... B. View 4 Picture... C. Insert 4 Picture... D. Edit 4 Picture... Cfiu 90. Trong Word, Oat bieu nio diroi day ve viec sit's dung tto hqp phim a cfin chinh plan vfin ban duqc chon 11 không thing? A. Ctrl + J: can deu theo hai bien trdi ye phai. B. Ctrl + R: can deu bien phai. C. Ctrl + L: can deu bien trai. D. Ctrl + C: can IV. MICROSOFT EXCEL (60 cau) Can 91. Trong bang tinh Excel, de loc dir lieu tv gong, sau khi chip kh6i can ice, ta thtyc hien: A. Data - Filter - AutoFilter B. View - Filter - AutoFilter C. Insert - Filter - AutoFilter D. Format - Filter - AutoFilter Can 92. Trong Excel, t3i 8 A2 ce gia tri la chuld "TINHOC". T3i 8 B2 go cong them = RIGHT(A2,3) thi nhn dirqc ket qua? A. Tinhoc B. HOC C.3 D. TIN Cfiu 93. Gifi sir ngly h thting cim may tinh hien la: 04/10/2017; Trong Excel, ti 8 A2, ta go vao cling fink =Today-1, ket qui nh8n duqc11 gi? A. 03/10/2017 B. #NAME! C. 0 D. #VALUE! Cfiu 94. Trong Excel, bieu thirc = 2^4*2+5*2+(20-10)/2 se frit ve gia tri nao duti d5y? A.138 11.47 C. 271 D. MOt gid tri khac. Can 95. Trong khi lam viec veil Excel, co the chuyen tU Sheet nay sang Sheet khic bang each sir dung the tO hop phim nao dual dfiy? A. Page Up hodc Page Down B. Home hodc End C. Ctrl - Page Up hoc Ctrl - Page Down. D. Ctrl - Home hoc Ctrl - End Can 96. Trong Excel, de co the sira di dir lieu trong mOt 6 tinh phiti nh8p 131 toil' 136), each thao tic nit) duel day Wiling dung? Nhay dup chuOt tai 6 tinh can sira doi Nhay chuOt chip ô tinh can sira dOi, rei An phim INSERT Nhay chuOt chon 0 tinh can sira daft, raj an phim F2 Nhay chuOt Glum ô tinh can sira dal, rai nhay chuOt vao thanh cong thirc. Cfiu 97. Trong Excel, ham Year("20/10/2016") cho ket qua: A. 10 B. 2016 C. 20 D. #VALUE! Cfiu 98. Trong Excel, de chuyen day ky'f tv la cac chir s6 (chit& sts) sang sti ta si dung ham nio trong the him duel day? A. Mid(chuoi so, m, n) B. Right(chuOi so, n) C. Left(chuen sO, n) D. Value(chai s6) Cau 99. Trong Excel, de chin them Sheet mei vio trent Sheet dang chop, ta thvc hien thao tic nito dirai dfiy? A. Edit 9 Move or Copy Sheet ... B. Edit 3 Move or Copy Sheet ... 10 C. Edit 4 Fill D. Insert 4 Worksheet Cau 100. Trong Excel, cling that nio dithi day cho ket qui II 13020000? A. =ROUND(13021976.2011,4) B. =ROUND(13021976.2011,-4) C. =ROUND(13021976.2011,-8) D. =ROUND(13021976.2011,0) Can 101. Trong bang tinh Excel, ti 6 A2 go vao cling unit =MAX(30,10,65,5) thi nhin dirge ket quit la: A.65 11.30 C.5 11.110 Cau 102. Trong Excel, de hien thi cfic mAu tin thofi min dieu kien nio do, ta chop: A. Data 4 Index... B. Data 4 Filter... C. Data 4 Sort... El. Data 4 Form... Can 103. Trong Excel, tfii 8 A2, ta nhip &Ong that =1F(3>5,100,1F(5<6,200,300)) thi kit qua nhin dine ti ô A2 II gi? A.200 11.300 C. 100 D. False Cau 104. Trong Excel, xac dinh gia tri Qua cfic cling Mit nine dirt day, xfic iinh nao IA dung? A. = AND (5 > 1 , 6 < 1) - TRUE B. = AND(7 > 2 , 2 < 4) -FALSE C.=0R(6 <2 ,7>3) - TRUE D. = OR (7 > 2 ,3 > 6) - FALSE Cau 105. Trong Excel, bieu thfrc = SUM( 9, 1, MAX(3, 5,7)) se till v ket qui lit bao nhieu? A.13 B.25 C.15 11.17 Cau 106. Trong Excel, tfii 8 A2 co sin gii tri s6 khong (0); TO 0 B2 ge vlo c8ng that =5/A2 thi nhfin dine ket quit: A. #VALUE! B. 0 C.5 D. #DIV/0! Cau 107. Trong Excel, cling that =AND(3>2,AND(25>15,4<2)) se cho ket qua la gi? A.4<2 B. TRUE C. FALSE D. 25>15 Can 108. Trong Excel, ti 0 115 co sin dit lieu la diy ki tv "happy new year". Tfii o K5, ta ge vito ding that =UPPER(H5) thi ket qua nhin dtrot IA gi? A. Happy new year B. Happy New Year C. HAPPY NEW YEAR D. happy new year Can 109. Trong Excel, bieu that = Counif(A5:C10,"A*") ce tfic &pig: Dem se ô trong vimg A5:C10 chfra dü lieu kg tv va có kg tir clau la "A" hoic "a" Dam se 8 trong vimg A5:C10 chfra da lieu kg t, chi Om 2 kg tv va 0,14 tçdâula "a" Dem so: 8 trong Sheet chfra dit lieu kg ty, chi Om 2 icS, tir va co kg tir diu la "A" boat "a" Dem so o trong \ring A5:C10 chfra (lir lieu kg tv co 2 kg tv dau la "A" va "*" Cau 110. Trong Excel, cfic Co Al, Bl, Cl, D1, El co cac gia tri lin ltnyt 11 2,4, 6,8, 10. Thyme Men ding thtit =1F(OR(AlC1),0,1) se nhin duct ket qui lit: A.0 B. TRUE C. FALSE D. 1 Can 111. Trong Excel, thvc viec Copy Sheet, sau khi nhay chui)t phfii vio ten ctia Sheet cfin sao chep, ta thvc hien tiep cfic thao tfic nfio dirt day? Chon Move... 4 Xac dinh vi tri dt ban sao 4 OK Chon Copy... 4 OK Chon Copy... 4 Danh clau Create a Copy 4 OK a 11 D. Chun Move or Copy... 4 Xac dinh vi tri dat ban sao r6i danh clau Create a Copy 9 OK Cfiu 112. Trong Excel, tali ô A2 co sin dfr lieu la day ki tw "Tin hoc van phong". Tai a B2, ta g8 vAo &mg that =LOWER(A2) thi ket qua nhen dirge la gi? A. TIN HOC VAN PHONG B. Tin hoc van phong C. Tin Hoc Van Phong D. tin hoc van phong au 113. Trong cac ph& bleu v dia chi trong Excel nhw dwell dfiy, phat bleu nio kitting diing? A. $C9 hoc B$1:D$10 la cac dia chi phirc hup. B. B1 hoc A8:H12 la cac dia chi tirong di. C. A$1 hoc $B1:$D10 la Mc dia chi Mn hon. tuyet doi. D. $B$1 hoc $A$8:$H$12 la cac die chi Can 114. Trong Excel, dieu kien trong him IF duvc phit bieu duel clang met pile') so sanh. De so stinh khic nhau, ta sir dyng ki hien nio? A. <:=> >< C.!= D. flu 115. Trong Excel, him SUM(3,2,1) se tra ve gia tri: A. 2 11.1 C.6 D.3 Cau 116. Trong bang bath Excel, khtli la tap him nhieu ô ke cen tao thanh hinh cha nhat. Cach vitt Ilia chi Mt& nio duti dfiy la ding? A. Bl-H15 B.B1 1-H15 C. Bl:H15 D. Bl...H15 Cfiu 117. Trong Excel, =On bet / tat thanh cling that, ta chyn: A. Tools 9 Formula Bar B. View 3 Formula Bar C. View 9 Toolbars --> Formula Bar D. Insert 4 Formula Bar Cau 118. Trong Excel, cling thee =IF(AND(7>=6,0R(5>7,8<9)),1,0) së cho ket qua là gi? A. FALSE B. TRUE C. 1 P.O au 119. Trong Excel, a di ten Sheet, ta thwc hien thao tic: Nhay chuet phai vao Sheet can dolt ten roi chun Rename Chun Work Sheet 3 Rename Chun File 3 Rename Chun Edit 4 Rename Can 120. KM lam viec vfri Excel, d nhep vao &Ong thirc tinh tomn cho met 8, triret ht ta phai go: A. DL bang (= ) B. Dan chain hoi (?) C. Dau d8 la ($) D. Wall hai chain (: ) flu 121. Trong Excel, him Month("20/10/2016") cho ket qua: A. 2016 B. #VALUE! C. 10 P.20 eau 122. Trong Excel, him INT(25.55) cho ket qua: A. 0.55 B. 25.5 C.25 P.25.6 Can 123. Trong Excel, de tinh tang gil trj aic ô tir Al den A7, Ong duly nio duel dig lit dung? A. =SUM(Al- A7) B. —SUM(A1);SUM(A7) C. =SUM(A1):SUM(A7) D. =SUM(A1:A7) 12 Cau 124. Trong Excel, de nhap die lieu sang dlong meri trong cling met ô (Cell) ta sfr dung h(rp phim nio? A. Ctrl + Enter B. Shift + Enter C. Ctrl + Shift + Enter D. At! + Enter Can 125. Trong Excel, chfre ding Format Painter la gi? Paste yang du lieu dugc km trong be nlig dem vlo vi tri con tr8 van ban. Coppy yang di: lieu dugc chgn. Can chinh di) lieu trong 8 dugc chon. Sao elle!) clinh clang Cau 126. Trong Excel, sau khi nhap cling thin sau: = "154" - "54" ta nhan &rot ket qua: A."1" B. "100" C. 100 D. MOt thong bao lei. Cau 127. Trong Excel, cac 0 Al, A2, Bl, 82 chilli cac gia trf l&n luvt li 18.0; 15.5; 18.5; 9.3; Thgc hien cang thfrc =ROUND(A'VERAGE(A1:B2),2) se ahem dirge ket qua li; A. 13.65 B. 13.70 C. 15.325 D. 15.33 Can 128. IChi dang lim viec vosi Excel, tei hgp phim nio cho phep ngay lap tot dim con tro vet 8 du lien (8 Al) cilit bang tinh? A. Shift + Ctrl + Home B. Shift + Home C. Ctrl + Home D. Alt + Home Can 129. Trong bang tinh Excel, muiin idat han met hang ra khei trang tinh, ta dainh dati chgn hang nay vi thgc hien thao tac nlo dyed day? A. Nhan phim Backspace B. Table - Delete Rows C. Tools - Delete D. Edit - Delete Can 130. Trong Excel, 8 Al chii-a tri 9.9 ; Cling that = INT(A1) se tra v gia A.9.0 B.10 C. 0.9 D.9 Can 131. Trong Excel, cac 0 Al, A2, A3, A4, AS chfra cfic gia tri lAn brut 11 18.0; 15.5; 18.5; 9.3; 7.1;. nut hien c8ng fink =MAX(A1:A5) sè nhan dirge ket qua la: A. 13.68 B. 68.4 C. 15.5 D. 18.5 Cau 132. Trong Excel, ham AND(didu kien 1, adu kien 2,...) se tra v gia tri dung (TRUE) khi: A. CO it nhat met didu kien IA dung B. Mui didu kien deu sai C. MO didu kien deu dung D. CO it nhlt met dieu Nen là sai Can 133. Trong Excel, tai 0 A2, ta nhap cling tithe =IF(3>5,100,IF(5>6,200,300)) thi ket qua nhan dirqc t3i 0 A2 là gi? A.300 B. False C.200 D.100 Can 134. Trong Excel, 8 Al chin tri -3 , ô A2 cluia trf 2 . Him MOD(A1,A2) se tra A.1 B. - 0.5 C. - 1 D. 0.5 Can 135. Trong Excel, him SUMP' co d3nF: = SUMIF(COt so_sanh, Cat tieurchuan, COt_lay teng) = SUMIF(Clit ti8u chuan, COt_lay_tow, COt so_sanh) = SUMIF(COt lay_teng, COt tieu_chuan, COt sg_sinh) = SUNIEF(Clit_tiou chuan, COt_so_sanh , Clit Jay_tong) 13 Cau 136. Trong Excel, de ellen them Sheet vao tnric met sheet Rio de, ta nhay chuet phai vio ten Sheet de rai A. Work Sheet 4 OK B. Insert... 4 Work Sheet 4 OK C. Move or copy 4 Work Sheet 4 OK D. Insert .4 OK tau 137. Trong Excel, him IF(OR(7>5,6<=5),"Dting","Sai")) cho ket qui: A. TRUE B. "Sai" C. FALSE D. "Dung" Ciu 138. Trong bang tinh Excel, ti 8 A2 c6 sen gii tri la "Tin hoc"; 8 82 c6 gia tri se 2011. TO 8 C2 gO vio ding tithe =A2+B2 thi nhin dtrqc ket qui: A. #VALUE! 11. 2008 C. Tin hoc D. Tin hoc2011 Cau 139. Trong Excel, de sip A) du lieu sau khi chqn khei die lieu mutt' sip xep, ta thkrc hien thao tic Rio dwell dfiy? A. Data 4 Index... B. Data 4 Form... C. Data 4 Filter... D. Data 4 Sort... Cfiu 140. Trong Excel, gia sir 8 113 c6 gii tri II "Micrsoft Excel". Cling thirc nio dtrifri day tra v ket qui la chilli "soft"? A. =MDD(B3,3,4) B. =MID(B3,5,4) C. =MID(B3,4,4) D. =MID(B3,4,5) Cau 141. Cho biet gil tri cüa bieu those sau day trong Excel: =LEN("Quang Nam")? A.3 11.9 C.10 D.11 Cfiu 142. Trong Excel, tii ô A2 c6 gia tri lit "Tam ICST 2". Neu sir (king nut din d din des lieu den dc 8 132, C2, D2, E2. H6i: ket qua Whin dirge tqi 8 E2? A. Tam Ky 5 B. Tam KY 2 C. #VALUE! D. Tam Ky 6 Cfiu 143. Trong Excel, ham nho sau day cho phep tinh ding die gii tri kieu st thea min dieu Men cho truirc? A. SUMIF B. COUNT C. SUM D. COUNTIF Cfiu 144. Trong Excel, him Day("20/10/2016") cho ket qua: A. 20 B. #VALUE! C.10 11.2016 Can 145. Trong Excel, ding fink : = "Hoa"&" "& "hang" cho ket quill: A. Boa B. Hoa hang C. Hoahling D. Hang Ciu 146. Trong Excel, tkti 8 Al c6 gii tri IA se 10 ; 8 B2 c6 gii tri la sO 3. TO 8 C2 go cang that =MOD(A2,B2) thi nkin duct ket qui la: A. #VALUE! B.3 C.1 11.10 Cfiu 147. Thao tic nio sau dfiy clang de din ten met Sheet trong bang tinh Excel? A. Chola Edit 4 Replace B. Ch9n Edit 4 Rename C. Ch9n Format 4 Sheet 4 Rename D. Chon Insert 4 Name 4 Creat Cfiu 148. Trong bang firth Excel, tqi 8 112 co cling those =B2*C2/100. Neu sao cite') ding thiic den 8 66,8 66 se c6 tang there A. E2*C2/100 B. E7*F7/100 C. B6*C6/100 D. E6*F6/100 14 Đề cương ôn tập thi tuyển viên chức giáo dục môn tin học văn phòng V flu 149. Trong Excel, giao cilia mOt hang vi mOt c(it duyt pill gi? A. Mau tin B. 0 C. Da Ru D. Triremg Can 150. Trong bang tinh Excel, d chen them mOt cOt vat) trang tinh, sau khi clip A tri an then, ta thyc hi§n lenh nio &I'M day? A. Format - Cells - Insert Columns B. Table - Insert Cells C. Table - Insert Columns D. Insert - Columns 15 Đề cương ôn tập thi tuyển viên chức giáo dục môn tin học văn phòng