nerdexam
Microsoft

77-427 · Question #33

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows- based network. Rick is creating a project through Microsoft Excel 2013. The project on which he is working has 98…

The correct answer is A. Gantt Chart Template. The Gantt Chart Template Deluxe Edition for Excel is used to generate quick and easy Gantt charts that define the progress of a user's projects containing up to 100 project tasks and team Answer option B is incorrect. A form control is an original control that is compatible…

Create Advanced Charts and PivotTables

Question

Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows- based network. Rick is creating a project through Microsoft Excel 2013. The project on which he is working has 98 project tasks and 57 team members. Rick wants to check the progress of his project quickly and easily. Which of the following will Rick use to accomplish the task?

Options

  • AGantt Chart Template
  • BForm control
  • CTrust Center
  • DAccounting template

How the community answered

(26 responses)
  • A
    77% (20)
  • B
    8% (2)
  • C
    12% (3)
  • D
    4% (1)

Explanation

The Gantt Chart Template Deluxe Edition for Excel is used to generate quick and easy Gantt charts that define the progress of a user's projects containing up to 100 project tasks and team Answer option B is incorrect. A form control is an original control that is compatible with old versions of Excel, beginning with Excel version 5. 0. It is designed for use on XLM macro sheets. It can be used when a user wants to simply interact with cell data without using VBA code and when he wants to add controls to chart sheets. By using form controls, the user can run macros. He can attach an existing macro to a control, or write or record a new macro. These controls cannot be added to UserForms, used to control events, or modified to run Web scripts on Web Answer option D is incorrect. The accounting template is used for numbering months of a financial year to period numbering. It is used to compare month to month, actual v budget, quarter to quarter, year to year variances. It is the initial point for other reports that need the use of Answer option C is incorrect. Trust Center is where a user can find security and privacy settings for Microsoft Office 2013 programs.

Topics

#Gantt chart#project management#Excel templates#task tracking

Community Discussion

No community discussion yet for this question.

Full 77-427 Practice