I need help with the rest of the homework. Please do not add or


Question Description:

30

I need help with the rest of the homework. Please do not add or delete columns or rows. Please do not change font, or color unless instructed. _E02_26Apr08_36.XLSX Assignm Please do not (otherwise you will jeopardize the grading proce -rename this workbook -rename any sheets -insert/delete any columns in a sheet -insert/delete any rows in a sheet Read the Multiple Choice and Excel assignment(s) carefully an You have to complete every cell colored yellow For every cell colored yellow, you have to decide: Dropdown -> Every cell with a dropdown, choose the Value -> enter the appropriate numeric, date/time or Formula -> enter the appropriate formula e.g. ‘=A1+B Array Formula -> enter the appropriate array formula The initial due date/time for this assignment is Friday, May 06 The retake due date/time for this assignment is Friday, May 06 Cell comments: every cell you must complete has a cell comment. The cell comment has spe When you rest the pointer on the cell, the comment appears. Four items of information will 1. 2. cell value – whether the cell value will be date, logical value, number, text cell formula – simple or array the formula tokens will be provided and sorted e.g. 0 (3), 1 (2), 12 (4), H the formula operators */+-^() are not provided if a formula token is used more than once in the formula, the token cou 3. cell formatting – Excel lets you change many of the ways it displays data in a cell. Fo to the cell. You can access and modify the majority of these settings in the Format characteristics. 4. cell name – any required cell name will be indicated Excel instructions: column AA will contain any Excel instructions for a chart, conditional form Assignment Instructions Exam: 2 he grading process): nt(s) carefully and do the following: o decide: own, choose the appropriate response from the dropdown ric, date/time or text value mula e.g. ‘=A1+B1’ press Enter te array formula e.g. ‘=LINEST(A1:A12, B1:B12, True, True)’ press Ctrl+Shift+Enter s Friday, May 06, 2016 — 6:00:00 PM is Friday, May 06, 2016 — 6:00:00 PM he cell comment has specific information for the student. When a cell has a comment, a red indicator appears in the corner ems of information will be provided to the student in the cell comment. , number, text e.g. 0 (3), 1 (2), 12 (4), H18 (4), H20 (2), H36 (2), I29 (2), I33 (2), IF, ROUNDUP formula, the token count will appear in parentheses e.g. 0 (3), H18 (4) displays data in a cell. For example, you can specify the number of digits to the right of a decimal point, or you can add a patt settings in the Format Cells dialog box (on the Format menu, click Cells). The student is required to only set 12 commonly u chart, conditional formatting, tables, data tables, range names, pivot tables, etc. trl+Shift+Enter r appears in the corner of the cell. nt, or you can add a pattern and border only set 12 commonly used formatting Megan, Inc. uses the following standard costs per unit for one of its products: Direct labor (2.00 $2.50/hr.) = $5.00. The flexible budget for overhead is $120,000 plus $1.00 per direct labor hou costs of $227,000, total fixed overhead of $124,200, 84,100 hours worked, and 39,000 units pro MC-001 The overhead production volume variance for Megan, Inc. for the month is: è è è è è Answer: A. B. C. D. E. $4,200 unfavorable $3,000 unfavorable $18,700 unfavorable $32,000 unfavorable $6,100 unfavorable B. Zero Company’s standard factory overhead rate is $3.69 per direct labor hour (DLH), calculated the company operated at 79.00% of capacity, or 790 standard DLHs. Budgeted factory overhead fixed overhead. For December, the actual factory overhead cost was $3,740 for 842 actual DLHs MC-002 Assuming the use of a four-way breakdown (decomposition) of the total overhead variance, wh for Zero Company in December? è è è è è Answer: MC-003 A. B. C. D. E. $139 unfavorable $116 unfavorable $755 unfavorable $587 unfavorable $87 favorable B. Examine this algeb

Answer

30