Elias recorded a macro for formatting all of his data cells that include scientific number notation. After recording a long series of steps, he practices running the macro. Then he realizes that he meant to make all of these cells top-aligned instead of the default bottom-aligned. What is the most efficient way for Elias to fix this macro? Using the VBA editor, he could find every instance of “VerticalAlignment,” and then change the text after the equal sign from “xlBottom” to “xlTop.”

Using the VBA editor, he could find every instance of “HorizontalAlignment,” and then change the text after the equal sign from “xlBottom” to “xlTop.”

He could record the macro again, type in “xlBottom” to deactivate the default setting, and then select the top-align button under the Home tab.

He could record the macro again, select the bottom-align button under the Home tab to deactivate it, and then type in “xlTop” to trigger the correct setting.

Evelyn would like to open a small business that is categorized as a being in the distribution industry. to do this she could open a establishment.

Put each of them in order. you are a young entrepreneur with a startup business. you now seek credit from the bank to expand it. what are the steps you will have to take? 1. you support your loan application with relevant documents. 2. you fill out the loan application form at the bank 3. you get an approval for the loan and the money is disbursed to your business account 4. you use the credit to further your business plan. 5. you have an interview with the loan officer and you explain your business plan.

Assume that all of thurmond company’s sales are credit sales. it has been the practice of thurmond company to provide for uncollectible accounts expense at the rate of one-half of one percent of net credit sales. for the year 20x1 the company had net credit sales of $2,021,000 and the allowance for doubtful accounts account had a credit balance, before adjustments, of $630 as of december 31, 20x1. during 20x2, the following selected transactions occurred: jan. 20 the account of h. scott, a deceased customer who owed $325, was determined to be uncollectible and was therefore written off. mar. 16 informed that a. nettles, a customer, had been declared bankrupt. his account for $898 was written off. apr. 23 the $906 account of j. kenney & sons was written off as uncollectible. aug. 3 wrote off as uncollectible the $750 account of clarke company. oct. 20 wrote off as uncollectible the $1,130 account of g. michael associates. oct. 27 received a check for $325 from the estate of h. scott. this amount had been written off on january 20 of the current year. dec. 20 cater company paid $7,000 of the $7,500 it owed thurmond company. since cater company was going out of business, the $500 balance it still owed was deemed uncollectible and written off. required: prepare journal entries for the december 31, 20x1, and the seven 20x2 transactions on the work sheets provided at the back of this unit. then answer questions 8 and 9 on the answer sheet. t-accounts are also provided for your use in answering these questions. 8. which one of the following entries should have been made on december 31, 20x1?