Câu 8: 77-888: Excel 2010 Expert

You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company's high selling products. You input a formula for calculating the monthly sell of a particular product but your Excel cell shows a string of # symbols instead of returning a value as shown below: Which of the following are the reasons that are causing the above problem? Each correct answer represents a complete solution. Choose all that apply.

1. A. You are inserting a new column, next to a column that is already formatted as text.
2. B. The cell is not wide enough for displaying the calculated value. — đáp án hiện tại
3. C. The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.
4. D. Excel is trying to show the contents of the cell as a date or time stored as positive numeric values within Excel, but the cell contains a negative value. — đáp án hiện tại