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

สั่งพิมพ์
ฝัง

ลีดเดอร์บอร์ด

สไตล์ภาพ

ตัวเลือก

สลับแม่แบบ

คืนค่าการบันทึกอัตโนมัติ: ใช่ไหม