CP212 Exam Review With Correct
Answers
Which cprogramming cconcept ccan cbe cdescribed cas c"The cparts cof ca cprogram chave
caccess cto cwhich cother cparts?" c- ccorrect canswers✔✔The cScope
What cVBA cfunction ccan cbe cused cto ccheck cto csee cif ca cvalue cis ca cvlid cdate c-
ccorrect canswers✔✔isDate()
What cis cthe cscope cof cthe csalary cvariable
Sub cTest1()
cDim csalary cAs cCurrency
csalary c= c5000
End cSub c- ccorrect canswers✔✔subroutine clevel cscope
On cassigning ca cvalue cto ca cnew cvariable cinside ca cfunction cit cautomatically
cbecomes ca cglobal cvariable c(T/F) c- ccorrect canswers✔✔False
A csubroutine ccannot ccall ca cfunction c(T/F) c- ccorrect canswers✔✔False
What cis cthe cname cof cthe cVBA cobject cthat crepresents can cexcel cfile c- ccorrect
canswers✔✔Workbook
Which cVBA ccommand cwill callow cyou cto caccess cvalues cfrom ca cUserform ccalled
cmyUserform cbefore cthe cUserform cis cdisplayed cto cthe cuser c- ccorrect
canswers✔✔Load cmyUserform
Which cVBA cstatement cis ctypically cused cto cdisplay ca cUserform ccalled cmyUserform
con cthe cscreen cfor cthe cfirst ctime c- ccorrect canswers✔✔Show cmyUserform
A cUserform cthat callows cyou cto ckeep cworking cin cExcel cwhile cits. copen cis ccalled: c-
ccorrect canswers✔✔Modal
What cis cthe cline cof ccode cused cto chave cyour cprogram ccontinue cwhen can cunusual
cerror chappens c- ccorrect canswers✔✔On cError cResume cNext
What cline cof ccode cis cused cto cturn cerror chandling coff c- ccorrect canswers✔✔On cError
cGo cTo c0
In cthe cfollowing ccode cwhat cis cthe cword c"DataEnrtyError" ccalled cin cVBA?
Sub csomeErrors()
, cOn cError cGo cTo cDataEntryError
cStatement
cOn cError cGo cTo c0
cExit cSub
DataEntryError:
cMsgBox c"Error"
End cSub c- ccorrect canswers✔✔Label
You care cworking con can capplication cwhere call cthe ccustomer cfiles care ckept cin cthe
csame cfolder, cbut cyou cdon't cknow cwhich cfolder. cWhich cis cthe cbetter csolution cfor ca
cgraphical cinterface-based capplication? c- ccorrect canswers✔✔Display ca cfolder cpicker
cdialog cbox cso cthe cuser ccan cselect cthe cright cfolder
What clibrary ccontains cthe cFileSystemObject c- ccorrect canswers✔✔Microsoft cScripting
cRuntime cLibrary
What cobject callows cyou cto cpreform cfile coperations csuch cas cremaining, cdeleting, cor
cchecking cto csee cif ca cfile cexists c- ccorrect canswers✔✔FileSystemObject
Which cdialog cbox callows cthe cuser cto cselect cone cre cmore cfiles cthat ccan cthen cbe
copened cin cexcel cusing cthe cexecute ccommand c- ccorrect
canswers✔✔msoFileDialogFilePicker
What cis cthe cessential celement cin cany crelational cdatabase c- ccorrect
canswers✔✔Field
What cscripting clanguage cis cused cto cpreform cqueries con ca cdatabase c- ccorrect
canswers✔✔SQL
Microsoft caccess cis ca cserver cbased crelational cdatabase cmanagement csystem c(T/F)
c- ccorrect canswers✔✔False
What care cthe creasons cyou cwould cchoose cto cautomate ca cpivot ctable cby cproviding ca
cGUI capplication cto ca cuser c- ccorrect canswers✔✔the cuser cdoesn't cneed cto cknow
chow cto cuse cpivot ctables cand canswers cto cdata cdriven cquestions ccan cbe cprovided
ceasier
What cobjects care crequired cto cautomate ca cpivot ctable cwith cVBA ccode c- ccorrect
canswers✔✔PivotCache, cPivotTable
Which ccan cbe csources cof cdata cfor ca cpivot ctable c- ccorrect canswers✔✔access
cdatabase, cexcel cworksheet, coracle cdatabase
What clanguage cis cused cto cdesign cthe cMicrosoft cRibbon cinterface c- ccorrect
canswers✔✔XML
Answers
Which cprogramming cconcept ccan cbe cdescribed cas c"The cparts cof ca cprogram chave
caccess cto cwhich cother cparts?" c- ccorrect canswers✔✔The cScope
What cVBA cfunction ccan cbe cused cto ccheck cto csee cif ca cvalue cis ca cvlid cdate c-
ccorrect canswers✔✔isDate()
What cis cthe cscope cof cthe csalary cvariable
Sub cTest1()
cDim csalary cAs cCurrency
csalary c= c5000
End cSub c- ccorrect canswers✔✔subroutine clevel cscope
On cassigning ca cvalue cto ca cnew cvariable cinside ca cfunction cit cautomatically
cbecomes ca cglobal cvariable c(T/F) c- ccorrect canswers✔✔False
A csubroutine ccannot ccall ca cfunction c(T/F) c- ccorrect canswers✔✔False
What cis cthe cname cof cthe cVBA cobject cthat crepresents can cexcel cfile c- ccorrect
canswers✔✔Workbook
Which cVBA ccommand cwill callow cyou cto caccess cvalues cfrom ca cUserform ccalled
cmyUserform cbefore cthe cUserform cis cdisplayed cto cthe cuser c- ccorrect
canswers✔✔Load cmyUserform
Which cVBA cstatement cis ctypically cused cto cdisplay ca cUserform ccalled cmyUserform
con cthe cscreen cfor cthe cfirst ctime c- ccorrect canswers✔✔Show cmyUserform
A cUserform cthat callows cyou cto ckeep cworking cin cExcel cwhile cits. copen cis ccalled: c-
ccorrect canswers✔✔Modal
What cis cthe cline cof ccode cused cto chave cyour cprogram ccontinue cwhen can cunusual
cerror chappens c- ccorrect canswers✔✔On cError cResume cNext
What cline cof ccode cis cused cto cturn cerror chandling coff c- ccorrect canswers✔✔On cError
cGo cTo c0
In cthe cfollowing ccode cwhat cis cthe cword c"DataEnrtyError" ccalled cin cVBA?
Sub csomeErrors()
, cOn cError cGo cTo cDataEntryError
cStatement
cOn cError cGo cTo c0
cExit cSub
DataEntryError:
cMsgBox c"Error"
End cSub c- ccorrect canswers✔✔Label
You care cworking con can capplication cwhere call cthe ccustomer cfiles care ckept cin cthe
csame cfolder, cbut cyou cdon't cknow cwhich cfolder. cWhich cis cthe cbetter csolution cfor ca
cgraphical cinterface-based capplication? c- ccorrect canswers✔✔Display ca cfolder cpicker
cdialog cbox cso cthe cuser ccan cselect cthe cright cfolder
What clibrary ccontains cthe cFileSystemObject c- ccorrect canswers✔✔Microsoft cScripting
cRuntime cLibrary
What cobject callows cyou cto cpreform cfile coperations csuch cas cremaining, cdeleting, cor
cchecking cto csee cif ca cfile cexists c- ccorrect canswers✔✔FileSystemObject
Which cdialog cbox callows cthe cuser cto cselect cone cre cmore cfiles cthat ccan cthen cbe
copened cin cexcel cusing cthe cexecute ccommand c- ccorrect
canswers✔✔msoFileDialogFilePicker
What cis cthe cessential celement cin cany crelational cdatabase c- ccorrect
canswers✔✔Field
What cscripting clanguage cis cused cto cpreform cqueries con ca cdatabase c- ccorrect
canswers✔✔SQL
Microsoft caccess cis ca cserver cbased crelational cdatabase cmanagement csystem c(T/F)
c- ccorrect canswers✔✔False
What care cthe creasons cyou cwould cchoose cto cautomate ca cpivot ctable cby cproviding ca
cGUI capplication cto ca cuser c- ccorrect canswers✔✔the cuser cdoesn't cneed cto cknow
chow cto cuse cpivot ctables cand canswers cto cdata cdriven cquestions ccan cbe cprovided
ceasier
What cobjects care crequired cto cautomate ca cpivot ctable cwith cVBA ccode c- ccorrect
canswers✔✔PivotCache, cPivotTable
Which ccan cbe csources cof cdata cfor ca cpivot ctable c- ccorrect canswers✔✔access
cdatabase, cexcel cworksheet, coracle cdatabase
What clanguage cis cused cto cdesign cthe cMicrosoft cRibbon cinterface c- ccorrect
canswers✔✔XML
