Microsoft
77-427 · Question #8
You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You are facing a problem that when you type in a function and press Enter, the cell shows the function as you ty
Sign in or unlock 77-427 to reveal the answer and full explanation for question #8. The question stem and answer options stay visible for context.
Apply formulas and functions
Question
You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You are facing a problem that when you type in a function and press Enter, the cell shows the function as you typed it, instead of returning the function's value as shown below: Which of the following is the reason that is causing the above problem?
Options
- AYou are inserting a new column, next to a column that is already formatted as text.
- BExcel is trying to reference an invalid cell.
- CYou are inserting a new column, next to a column containing Dates or Times.
- DThe lookup_value or the array you are searching resides in a cell containing unseen spaces
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.
Topics
#formula display issue#text format cells#formula troubleshooting#cell formatting