nerdexam
Microsoft

77-427 · Question #13

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft Excel 2013. Rick wants to trace the project with the actual requirements. For this purpose, he is…

The correct answer is B. Accounting template. 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…

Create and manage worksheets and workbooks

Question

Rick works as an Office Assistant for Tech Perfect Inc. He is creating a report through Microsoft Excel 2013. Rick wants to trace the project with the actual requirements. For this purpose, he is required to compare month to month, actual v budget, quarter to quarter, year to year variances. Which of the following will Rick use to accomplish the task?

Options

  • AEvaluate Formula
  • BAccounting template
  • CForm control
  • DTrust Center

How the community answered

(46 responses)
  • A
    7% (3)
  • B
    76% (35)
  • C
    4% (2)
  • D
    13% (6)

Explanation

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. 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 anexisting macro to a control, or write or record a new macro. These controls cannot be added to User Forms, used to control events, or modified to run Web scripts on Web Answer option A is incorrect. Evaluate Formula is the 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 option D is incorrect. Trust Center is where a user can find security and privacy settings For Microsoft Office 2013 programs.

Topics

#accounting template#variance analysis#budget comparison#financial reporting

Community Discussion

No community discussion yet for this question.

Full 77-427 Practice