Microsoft
77-427 · Question #30
77-427 Question #30: Real Exam Question with Answer & Explanation
Sign in or unlock 77-427 to reveal the answer and full explanation for question #30. 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 a spreadsheet. You use a function in one cell and it works perfectly but when you attempt to copy the function down to other rows, you get the #REF error. 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.
- BExcel is trying to reference an invalid cell.
- CThe lookup_value or the array you are searching resides in a cell containing unseen spaces
- DYou are referencing an entire worksheet by clicking on the grey square at the top left of the
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.