Click on the "Calculate Adjustments" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. Each graded cell is highlighted in yellow. Select all account titles/la bels using dropdowns. Enter formulas for all dollar amounts. The formula must only contain cell addresses. Each correct formula will begin with =,+, or - . The basic mathematical operators are,+ and / Addition: To add the values in cells A1 and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1B4 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1BA Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 Order of operations Remember the acronym PEMDAS when creating your formulas. Parentheses Exponents Multiplication Division Addition Subtraction When calculating a fraction, make sure to put parentheses around any formula used in either the numerator or denominator. For example =(B1+B2)/(C1+C2) a. Unadjusted balance in the Prepaid Insurance account on December 31. Unexpired coverage as of December 31. \$0 $0 b. Supplies account balance at beginning of year. Supplies purchased during the year Physical count of supplies at December 31. $0 $0 $0 c. Balance in Unearned revenue at beginning of year $0 Cash recelved from customers in advance of performing services (recorded as Unearned revenue). Portion of work completed as of December 31. \$o 0% d. Unadjusted balance in Prepaid Rent Unexpired Prepaid rent as of December 31. \$o \$0 e. Cost of equipment purchased on January 1 of current year Estimated salvage value Estimated useful life (years) $0 so 0 Unadjusted balance in the Prepaid Insurance account on December 31. Unexpired coverage as of December 31. Supplies account balance at beginning of year. Supplies purchased during the year Physical count of supplies at December 31. c. Balance in Unearned revenue at beginning of year Cash received from customers in advance of performing services (recorded as Unearned revenue). Portion of work completed as of December 31. d. Unadjusted balance in Prepaid Rent Unexplred Prepaid rent as of December 31. e. Cost of equipment purchased on January 1 of current year Estimated salvege value Estimated useful life (years) Click on the "Calculate Adjustments" tab and enter your name in Cell C1. If Cell C1 is left blank, you will not be able to see your score. Each graded cell is highlighted in yellow. Select all account titles/la bels using dropdowns. Enter formulas for all dollar amounts. The formula must only contain cell addresses. Each correct formula will begin with =,+, or - . The basic mathematical operators are,+ and / Addition: To add the values in cells A1 and B4, the formula is =A1+B4 Subtraction: To subtract the value in cell B4 from the value in cell A1, the formula is =A1B4 Multiplication: To multiply the values in cells A1 and B4, the formula is =A1BA Division: To divide the value in cell A1 by the value in cell B4, the formula is =A1/B4 Order of operations Remember the acronym PEMDAS when creating your formulas. Parentheses Exponents Multiplication Division Addition Subtraction When calculating a fraction, make sure to put parentheses around any formula used in either the numerator or denominator. For example =(B1+B2)/(C1+C2) a. Unadjusted balance in the Prepaid Insurance account on December 31. Unexpired coverage as of December 31. \$0 $0 b. Supplies account balance at beginning of year. Supplies purchased during the year Physical count of supplies at December 31. $0 $0 $0 c. Balance in Unearned revenue at beginning of year $0 Cash recelved from customers in advance of performing services (recorded as Unearned revenue). Portion of work completed as of December 31. \$o 0% d. Unadjusted balance in Prepaid Rent Unexpired Prepaid rent as of December 31. \$o \$0 e. Cost of equipment purchased on January 1 of current year Estimated salvage value Estimated useful life (years) $0 so 0 Unadjusted balance in the Prepaid Insurance account on December 31. Unexpired coverage as of December 31. Supplies account balance at beginning of year. Supplies purchased during the year Physical count of supplies at December 31. c. Balance in Unearned revenue at beginning of year Cash received from customers in advance of performing services (recorded as Unearned revenue). Portion of work completed as of December 31. d. Unadjusted balance in Prepaid Rent Unexplred Prepaid rent as of December 31. e. Cost of equipment purchased on January 1 of current year Estimated salvege value Estimated useful life (years)
