Exam 77-888 topic 1 question 3 discussion

Actual exam question from Microsoft's 77-888

Question #: 3
Topic #: 1

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 2010. 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?

A. Gantt Chart Template
B. Form control
C. Trust Center
D. Accounting template

Show Suggested Answer

Suggested Answer: A 🗳️
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 members. 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 pages. 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 months. Answer option C is incorrect. Trust Center is where a user can find security and privacy settings for Microsoft Office 2010 programs.

by Mimito at Oct. 1, 2023, 5:20 p.m.

Comments

Submit Cancel

Shahid_416

1 year, 7 months ago

Option A : Gaant chart to represent a project schedule and progress

upvoted 1 times

...

Mimito

1 year, 9 months ago

A A Gantt Chart is a visual representation of a project's schedule and progress, making it a suitable choice for tracking project tasks and team members' progress. It allows him to see task timelines, dependencies, and the overall project schedule at a glance. Excel provides templates and tools for creating Gantt Charts to help manage and monitor project progress effectively.

upvoted 1 times

...