1. Âèáåð³òü ïðàâèëüíèé îïèñ çì³ííî¿ äëÿ ðîáîòè ç COM ñåðâåð³â Excel
1) var a:object;
2) var a:xlsobj;
3) var a:comobj;
4) var a:variant;
2. ßêèé ìîäóëü ïîòð³áíî ï³äêëþ÷èòè äî ïðîåêòó äëÿ ðîáîòè ç COM îá'ºêòîì Excel?
1) xlsobj
2) objcom
3) comobj
4) xlscom
3. ßêèé ìåòîä îá'ºêòà COM äîçâîëÿº äîäàòè â ïðîãðàì³ Excel íîâó êíèãó?
1) e.workbook.add
2) e.activeworkbook.add
3) e.add.workbooks
4) e.workbooks.add
4. ßêèé ìåòîä îá'ºêòà COM äîçâîëÿº äîäàòè â ïðîãðàì³ Excel íîâèé äîêóìåíò íà îñíîâ³ øàáëîíó?
1) e.workbooks.add(³ì'ÿ_øàáëîíó)
2) e.workbook.add(³ì'ÿ_øàáëîíó)
3) e.add.workbook(³ì'ÿ_øàáëîíó)
4) e.activeworkbook.add(³ì'ÿ_øàáëîíó)
5. ßêèé ìåòîä îá'ºêòà COM äîçâîëÿº çáåðåãòè â ïðîãðàì³ Excel ôàéë íà äèñêó?
1) e.activeworkbooks.saveas
2) e.workbooks.saveas
3) e.activeworkbook.save
4) w.activeworkbook.saveas
6. ßêèé ìåòîä îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel çàêðèòè ïîòî÷íèé äîêóìåíò?
1) e.workbooks.close
2) w.activeworkbook.close
3) w.activeworkbook.quit
4) w.activeworkbooks.quit
7. ßêà âëàñòèâ³ñòü îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel çâåðíóòèñÿ äî ïîòð³áíîãî àðêóøà?
1) e.activeworkbook.sheets[i]
2) e.activeworkbooks.sheets.item[i]
3) e.activeworkbook.sheets.item[i]
4) e.activeworkbooks.sheets[i]
8. ßêèé ìåòîä îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel äîäàòè íîâèé àðêóø ó êíèãó?
1) e.activeworkbook.sheets.item[i].add
2) e.activeworkbook.sheets[i].add
3) e.activeworkbook.sheets.item[i].new
4) e.activeworkbooks.sheets[i].add
9. ßêèé ìåòîä îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel âèëó÷èòè àðêóø ³ç êíèãè?
1) e.activeworkbook.sheets.item[i].delete
2) e.activeworkbooks.sheets[i].delete
3) e.activeworkbook.sheets[i].delete
4) e.activeworkbook.sheets.item[i].delete
10. ßêèé ìåòîä îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel ñêîï³þâàòè àðêóø êíèãè?
1) e.activeworkbook.sheets.item[i].copy
2) e.activeworkbook.sheets.item[i].copy
3) e.activeworkbook.sheets[i].copy
4) e.activeworkbooks.sheets[i].copy
11. ßêà âëàñòèâ³ñòü îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel çâåðíóòèñÿ äî ³ìåí³ àðêóøà êíèãè?
1) e.activeworkbook.sheets[i].name
2) e.activeworkbook.sheets.item[i].name
3) e.activeworkbook.sheets.item[i].listname
4) e.activeworkbooks.sheets[i].listname
12. ßêà êîìàíäà îá'ºêòà COM äîçâîëÿº «ïîäàâèòè» âèäà÷ó ïîâ³äîìëåíü Excel ïðè âèäàëåíí³ àðêóøà êíèãè?
1) e.displayalerts:=false;
2) e.displayerrors:=false;
3) e.showallerts:=false;
4) e.displayconfirm:=false;
13. ßêèé ìåòîä îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel âèêîíàòè çàì³íó òåêñòó?
1) e.activeworkbook.sheets.item[i].cell.replace
2) e.activeworkbook.sheets.item[i].cells.replacement
3) e.activeworkbook.sheets.item[i].cells.replace
4) e.activeworkbooks.sheets.item[i].cell.replacement
14. ßêå ³ì'ÿ ìຠïàðàìåòð äëÿ çàâäàííÿ òåêñòó-çðàçêà ïðè âèêëèêó ìåòîäó çàì³íè â ïðîãðàì³ Excel?
1) text
2) what
3) firsttext
4) example
15. ßêå ³ì'ÿ ìຠïàðàìåòð äëÿ çàâäàííÿ íîâîãî òåêñòó ïðè âèêëèêó ìåòîäó çàì³íè â ïðîãðàì³ Excel?
1) secondtext
2) perlacetext
3) secondtext
4) perlacement
16. ßêà âëàñòèâ³ñòü îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel çâåðíóòèñÿ äî âì³ñòó ÷àðóíêè?
1) e.activeworkbook.sheets.item[i].cell[i,j].text
2) e.activeworkbooks.sheets.item[i].cells[i,j].value
3) e.activeworkbook.sheets.item[i].cell[i,j].text
4) e.activeworkbook.sheets.item[i]cells[i,j].value
17. ßêèé ìåòîä îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel âèä³ëèòè ä³àïàçîí ÷àðóíîê?
1) e.activeworkbook.sheets.item[i].range[].select
2) e.activeworkbook.sheets.items[i].range[].select
3) e.activeworkbooks.sheets.item[i].range[].select
4) e.activeworkbook.sheets[i].range[].select
18. ßêèé ìåòîä îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel âñòàâèòè âèä³ëåíèé ä³àïàçîí ó çàçíà÷åíå ì³ñöå àðêóøà?
1) e.activeworkbook.sheets[i].range[].paste
2) e.activeworkbook.sheets.item[i].paste
3) e.activeworkbook.sheets.item[i].range[].paste
4) e.activeworkbook.sheets[i].paste
19. ßêà âëàñòèâ³ñòü îá'ºêòà COM äîçâîëÿº â ïðîãðàì³ Excel çâåðíóòèñÿ äî ôîðìóëè ÷àðóíêè?
1) e.activeworkbook.sheets.item[i].cell[i,j].formula
2) e.activeworkbooks.sheets.item[i].cell[i,j].formula
3) e.activeworkbook.sheets.item[i].cells[i,j].formula
4) e.activeworkbook.sheets.item[i].cell[i,j].formula