Rick works as an Office Assistant for Tech Perfect Inc. He is creating a user form through Microsoft Excel 2013. While creating forms for a number of users, he is required to repeat some of the…

Question

Options

• AHe will use the Trust Center bar.
• BHe will use the Evaluate Formula tool.
• CHe will put the workbook in a trusted location.
• DHe will create and run a macro.

• A
  4% (1)
• B
  4% (1)
• C
  13% (3)
• D
  78% (18)

Explanation

A macro is defined as a tool that permits a user to automate tasks and add several functionalities to forms, reports, and controls. For example, if a user adds a command button to a form, he associates the button's OnClick event to a macro, and the macro consists of the commands that are to be performed by the button each time it is clicked. The macro records the user's mouse clicks and keystrokes while he works and lets him play them back later. The macro can be used to record the sequence of commands that the user uses to perform a certain task. When the user runs the macro, it plays those exact commands back in the same order. Answer option B is incorrect. Evaluate Formula is a formula examination tool provided by Microsoft Excel. This tool is useful for examining formulas that do not produce any error but are not generating the expected result. Answer options A and C are incorrect. The benefit of connecting to external data from Microsoft Excel is that a user can automatically update Excel workbooks from the real data source wheneverthe data source is updated with new information. It is possible that the external data connection might be disabled on the computer. For connecting to the data source whenever a workbook is opened, it is required to enable data connections by using the Trust Center bar or by putting the workbook in a trusted location.

No community discussion yet for this question.