SUBJECT IS MICROSOFT EXCEL 1. You work for several accountants who are hosting a
ID: 3892191 • Letter: S
Question
SUBJECT IS MICROSOFT EXCEL
1. 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.
c.
b.
d.
2.
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.
c.
b.
d.
3.
Len, your supervisor, asks you to research the interlinked power tools available in Excel. He wants to discuss your research and recommendations next Tuesday.
To begin Tuesday’s meeting, Len asks you to explain the difference between Power Pivot and Power View. You explain that ____.
a.
c.
b.
d.
4.
Len, your supervisor, asks you to research the interlinked power tools available in Excel. He wants to discuss your research and recommendations next Tuesday.
Next, Len asks you to explain how a 3D Map works. You tell Len that a 3D Map ____.
a.
c.
b.
d.
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.Explanation / Answer
Q1
Recording a macro isn't suggested
Q2
D option is most appropriate
Q3
C is the correct one as multiple views are supported in power view
Q4
Do give a thumbs up
helps show your data in relation to a geographical area on a mapDo give a thumbs up
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.