You work for several accountants who are hosting a public seminar on recent changes to tax law that are applicable to the new tax year. You and two of your coworkers are tasked with automating the seminar participants’ sign-in process by creating a sign-in form in an Excel workbook (based on a workbook created by a previous team) and a macro. Today you and your coworkers are holding a ‘brainstorming session’ in preparation for creating the form.
As the ‘brainstorming session’ begins, Lucy asks how best to get
started on the form. You suggest that the team first familiarize
itself with the workbook, since it was created by another team.
Which of the following is NOT a suggestion you make to this
end?
|
a. |
Record a macro. |
c. |
Check which cells have macros enabled. |
|
b. |
Use Cell Reference Manager to show which cells are referenced in formulas and functions. |
d. |
Press ALT+F8, select a macro, click Run button. |
You work for several accountants who are hosting a public seminar on recent changes to tax law that are applicable to the new tax year. You and two of your coworkers are tasked with automating the seminar participants’ sign-in process by creating a sign-in form in an Excel workbook (based on a workbook created by a previous team) and a macro. Today you and your coworkers are holding a ‘brainstorming session’ in preparation for creating the form.
Bob, who has never before attempted to automate a worksheet task,
asks how the team can ensure that participants signing in using the
data entry form cannot accidentally or purposely make changes to
the form. You tell the team ____.
|
a. |
not to worry about accidental or purposeful changes to the form; participants can be trusted not to make changes |
c. |
that a special software patch will be added to Excel to protect the worksheet from changes |
|
b. |
that the new company intern will stand by to monitor all participants’ data entry and make sure no changes are made to the form |
d. |
that when macros are enabled, a security setting in Excel must be modified. |
1) A Record a Macro
As the team is not aware about the form, to get started, they must first understand the existing form rather than recording a macro
2) C
There is a feature available in Excel worksheet for data protection which restricts the access rights
You work for several accountants who are hosting a public seminar on recent changes to tax...
First, read the article on "The Delphi Method for Graduate Research." ------ Article is posted below Include each of the following in your answer (if applicable – explain in a paragraph) Research problem: what do you want to solve using Delphi? Sample: who will participate and why? (answer in 5 -10 sentences) Round one questionnaire: include 5 hypothetical questions you would like to ask Discuss: what are possible outcomes of the findings from your study? Hint: this is the conclusion....