The problems in this document reflect the types of things you have learned in th

Question

The problems in this document reflect the types of things you have learned in the lesson like formatting of cells and the values contained within cells (i.e., bolding, text size, cell fill colour, single accounting underline, double accounting underline, resizing of cells, et cetera).

make at least 5 corrections and give 5 explanationns

1,Identify the cells address or identify the range of cells with a problem

2,Make the change to correct the problem and briefly explain the need for the change at the bottom of the sheet using a merged cell or text wrap (do not have text spill)

3.Repeat until you have at least five errors corrected

Noble Chartered Accountants Corp Balance Sheet For the Year Ended November 30, 2010 Assets Liabilities and Owners Equity Current Assets Current Liabilities Cash Temporary Investments Accounts Recievable Notes Recievable Merchandise Inven Prepaid Expenses Accounts Payable Wages Payable Notes Payable Current Portion of long-term Liabilities 15,300.00 3,200.00 3,000.00 7,500.00 Total Current Liabilities 22,801.07 3 Total Current Assets #NAME? Long-Term Liabilities Long term Notes payable Mortgage Payable 50,000.00 Long-term Investments ABC Common Shares Land held for Future Expansion Total long-term Liabilities S 5,000,000,000.00 ### 8 Total Investments #NAME? Owners Equity Common Shares 75,000.00 o Capital Assets 64,800.00 25,000.00 Preferred Shares Plant and Equipment ined Earnings 164,800.00 Store Equipment less: accumulated amortization Buildings less: accumulated amortization Land Total Plant and Equipment Total Owners Equity Total Liabilies and Owners Equity S 5,000,187,601.07 S 303,400.00000 9 Intangible Assets Trademark 10,000.00 2 Total Assets #NAME? 5

Explanation / Answer

> C Column # - Means there is something wrong it in.

                   Select the cell.

Format the cell as "General". (Right-click the cell, select Format Cells, and choose              "General.")

              Delete the "=" at the beginning of your formula, and hit Enter.

               Insert the "=" back in the formula at the beginning.

> E Column – Cell Sizing.

Click on the border of the E Cell to resize the cell according to the input. Or you can create your Page Layout from the Top Menu Bar.

> Bold Marking – Current Assets, Total Current Asset.

Try using ctrl +b to bold it which can make you to analyze your excel document better and easy to check. Here Current Assets, Total Current Asset, Current Liabilities, Total Investment (i.e. BIG Banner Words) etc. are not bold.

· >   # Name -

It is caused due to some sort of typing mistake in the formula. Please do check the formula

· >  Red Colour – Duplicate Value

Select the data list you need, and click Data > Remove Duplicates.

Then in Remove Duplicates dialog, check the column name that you want to remove duplicates from, and if your data has header, check

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.