BIS 155 (BIS 155)

BIS 155 Practical Final Exam 3 Instructions for Super Shoes Complete the tasks below using Microsoft Excel. You may refer to your notes, the textbook, or other resources (for example, you may search the Web for information). You may not get interactive help from any other person (either in person, via email, text messaging, IM, or other communications channels). Save your work frequently using CTL+s.You have 4 hours to complete this exam. NOTE: Be sure you SPELL CHECK on every wo...

Question: At the end current accounting period, account balances were as follows. Cash $28,000, Account Receivable, $44,000, Common Stock, $19,000, Retained Earnings $12 000. Liabilities for the period were: Question: Revenues were $147,000, expenses were $142,000, and cash dividends … and paid were $3,000. What were the next income and the change in the … earnings for the period? Question: Golden Company had the following accounts and balances at the end of the year. What are total assets...

Question 6. Question : (TCO 1) In Excel 2010, a column width ________. Student Answer: is adjustable so you can display more or less characters in a column is not adjustable so keep the formulas as short as possible always switches back to default is best left unchanged unless you absolutely have to Question 7. Question : (TCO 1) If you had worksheets that contained the inventory of each room in your house, with a separate sheet for each room, all the sheets together would be a: ...

Question 5. Question : (TCO 4) Which of the following best describes conditional formatting? Student Answer: Highlights or emphasizes cells that meet certain conditions Tags a table element as a reference in a formula Formats the condition of the worksheet in preparation for printing Calculates an aggregate for values in a range or database Question 6. Question : (TCO 4) Using Conditional Formatting to draw attention to cells that are blank _____. Student Answer: displays a par...

Complete the tasks below using Microsoft Excel. You may refer to your notes, the textbook, or other resources (for example, you may search the Web for information). You may not get interactive help from any other person (either in person, via email, text messaging, IM, or other communications channels). Save your work frequently using CTL+s.You have 4 hours to complete this exam. NOTE: Be sure you SPELL CHECK on every worksheet and correct all spelling errors. If you encounter technic...