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
0%
Macro Excel Quiz
共享
由
ColegSirGar
Adult education
Computing
编辑内容
嵌入
更多
排行榜
显示更多
显示更少
此排行榜当前是私人享有。单击
,共享
使其公开。
资源所有者已禁用此排行榜。
此排行榜被禁用,因为您的选择与资源所有者不同。
还原选项
随堂测验
是一个开放式模板。它不会为排行榜生成分数。
需要登录
视觉风格
字体
需要登录
选项
切换模板
显示所有
播放活动时将显示更多格式。
打开结果
复制链接
QR 代码
删除
恢复自动保存:
?