1) A _____________ is a set of instructions performed automatically? a) Cell b) Worksheet c) Macro d) Table 2) All recorded macros generate code in VBA (Visual Basic for Applications)? a) True b) False 3) After a macro is recorded, you can play back those actions anytime you want? a) True b) False 4) The Macro Recorder is located in the ______________ Tab? a) Insert b) Review c) Data d) Developer 5) You can NOT edit a macro after it has been recorded? a) True b) False 6) An _____________ reference macro is set to the exact location as recorded? a) Absolute b) Relative 7) A _____________ reference macro is applied to an active selected cell? a) Absolute b) Relative 8) Recorded macros can be edited in the ________________? a) Visual Basic Spreadsheet b) Visual Basic Editor c) Visual Basic Document d) Visual Basic Viewer 9) To apply macros on an Excel spreadsheet they must be saved in Excel Macro-Enabled Workbook file extension? a) True b) False 10) What is the file extension name for a Macro-Enabled Workbook? a) .xlsx b) .xlsm c) .xlst d) .xlss

Macro Excel Quiz

인쇄
퍼가기

순위표

비주얼 스타일

옵션

템플릿 전환하기

자동 저장된 게임을 복구할까요?