Microsoft
77-427 · Question #38
77-427 Question #38: Real Exam Question with Answer & Explanation
Sign in or unlock 77-427 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
Question
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.
Options
- AYou are inserting a new column, next to a column that is already formatted as text.
- BThe cell is not wide enough for displaying the calculated value.
- CThe lookup_value or the array you are searching resides in a cell containing unseen spaces
- DExcel is trying to show the contents of the cell as a date or time stored as positive numeric
Unlock 77-427 to see the answer
You've previewed enough free 77-427 questions. Unlock 77-427 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.