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

הדפסה
הטבעה

לוח תוצאות מובילות

סגנון חזותי

אפשרויות

החלף תבנית

האם לשחזר את הנתונים שנשמרו באופן אוטומטי: ?