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

列印
嵌入

排行榜

視覺風格

選項

切換範本

恢復自動保存: ?