exam 3 - t-r.r rv"i v'Ivcfw_ultiple-Choice cfw_3C points...

This preview shows page 1 - 3 out of 8 pages.

t--r .r - . rv. - ' "i v Section i: 'Iv{ultiple-Choice {3C points}: Please read each choice carefi-rily, and circle the Iefter of the correct answer- 1. There are four syotax forms that can be'.rsed ivith Do Loops. Which shcuid be used if you rvantthe loop to co:rtinue as long as the condition is you wart to guarantee execution of the statements within the ioop at least the condition is evaluated? tor hext loop - e p 5c EC What rvindow in Visual Basic Editor do and yow Modules? 6) Project Explorer Windorv F- Loca-l Window d- Code Wiadow go to in order to access Tbis Workbook Sorru-LtrrrnS 3 feAht + wres syntax form {alse and once before f vh you a. Acrive Window 3. Check boxes, scroll bars, and combo boxes ars gxamples a- Forms Conhols -b- Macro Controis O ActiveX Controls d. Properly Conbols of. fr
4. ActiveCell.Offset(-1,4).Select tells Excel to select which of the following? active cell. cell. active cel1. active cell. cell-
5. Which ternr would you use when writing code to define a variable for letters/words? cty'ana ct y61rre bV: + t/^ wenu+. -fr + t !.r lecr ct r' \sJ [^ro \e ih * '5"H1-g.-'it teqo" ;lrfuow d'urArnri1 ? 9\\v:cy tex+- a. Single s?H': d. 'Value - .r,vte4ry w/wl fex t v-olves Call ovt *-Urna,lq k.1^rn4s *cxt)
Which ofthe following is tme? , ^\ rarl - /6r\' - lar f" To assign a bge to a macro that you have written, you should click on the Inser-t button in the eonuots goup on the Developer tab, anC then you shorild select the button icon fiom the Aeti+effirrols area. FOr n.r CO F/+ (.Ol To indicate a comment, the user should type a set of quotatio++earles before the cornmentwhenwriting itinVisualBasicEditor. oVqtrOPhe . M\JSt 4f, Inputboxes are used to display information.to a user in a dialog Uox. t! PC I n lh+Q (a J Option buttons should be created if you only rvant to allorv the user to selectlffi.jPJ \-/ oithe available options. @1

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture