Edwin Wants to Insert a Pivot Chart to Summarize Raw

question 4

Multiple Choice

Edwin wants to insert a Pivot Chart to summarize raw data.Which of the following combination of clicks/selections/entries should he use to do this?

• A) Select Cell > Insert > PivotChart > OK
• B) Select Cell > Insert > Recommended PivotTables > OK
• C) Select Cell > PivotTable Tools > Analyze > PivotChart > Select a chart > OK
• D) Select Cell > Insert > Table > Create Table dialog box > Fill data in Where is the data for your table? box > OK

Use job cost sheets for tracking production costs including direct materials, direct labor, and overhead.

Apply predetermined overhead rates to allocate overhead costs appropriately.

Record transactions in a job order cost system related to labor, materials, and overhead.

Analyze the financial implications of costing and pricing decisions on gross profit.

---

Definitions:

Withholding Allowances

Deductions allowed on a paycheck, used to be calculated to reduce the amount of income tax withheld from an employee's salary.

FUTA Taxes

Federal Unemployment Tax Act taxes, which are payroll taxes paid by employers to fund the unemployment insurance system.

Liability

A company’s or individual’s legal financial debts or obligations that arise during the course of business operations.

Percentage Method

An IRS method for calculating the amount of taxes to withhold from an employee's paycheck based on income brackets.