Free 77-888 Web TestEngine Demo

Q3 Single choice

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?

A
You are inserting a new column, next to a column that is already formatted as text.
B
Excel is trying to reference an invalid cell.
C
You are inserting a new column, next to a column containing Dates or Times.
D
The lookup_value or the array you are searching resides in a cell containing unseen spaces at the start or end of that cell.

77-888 Web TestEngine demo