77-427 Web TestEngine demo

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.

Select all that apply.

• A

  You are inserting a new column, next to a column that is already formatted as text.

• B

  The cell is not wide enough for displaying the calculated value.

• 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.

• 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.