PLEASE HELP!!! I NEED HELP WITH THE WHOLE TEST SOMEONE PLS HELP

In a sumif conditional function, what should be the order of terms in the parentheses?

Balance sheet baggett company's balance sheet accounts and amounts as of december 31, 2016, are shown in random order as follows: account debit (credit) account debit (credit) income taxes payable $(3,800) additional paid-in capital on preferred prepaid items 1,800 stock $(7,900) additional paid-in capital on common stock (9,300) allowance for doubtful accounts (1,600) land 12,200 bonds payable (due 2020) (23,000) notes payable (due 2019) (6,000) buildings 57,400 notes receivable (due 2018) 16,400 sinking fund to retire bonds payable 5,000 accounts receivable 12,600 advances from customers (long-term) (2,600) premium on bonds payable (1,400) cash 4,300 accounts payable (13,100) accumulated depreciation: equipment (9,700) inventory 7,400 retained earnings (18,300) accumulated depreciation: buildings (21,000) preferred stock, $100 par (18,600) patents (net) 4,600 wages payable (1,400) equipment 28,700 common stock, $10 par (12,700) required: 1. prepare a december 31, 2016 balance sheet for the baggett. baggett company balance sheet december 31, 2016 assets current assets: $ $ $ long-term investments: $ property, plant, and equipment: $ $ $ intangible assets: liabilities current liabilities: $ $ long-term liabilities: $ $ other liabilities: shareholders' equity contributed capital: $ $ $ $ 2. compute the debt-to-assets ratio. round to one decimal place. do not enter a percent sign (%) as part of your answer. %

Last week paul, ceo of quality furniture in south carolina, traveled to europe to visit customers. while overseas, paul checked his e-mail daily and showed his company's website to customers, explaining how the website will them place orders and receive merchandise more quickly. after visiting the last customer friday morning, paul was able to return to the corporate office in south carolina to meet with his board of directors that night. is the "shrinking" of time and space with air travel and electronic media.