Correct Answer: The formula becomes invalid and displays a #NAME? error.
Explanation:
Note: This Question is unanswered, help us to find answer for this one
Excel Skill Assessment
Your Skill Level: Poor
Retake Quizzes to improve it
More Excel MCQ Questions
You want to restrict the values entered in a cell to a specified set, such as Hop, Skip, Jump. Which type of data validation should you use?
You want to find the second-largest invoice in a column containing all the invoices in a given month. What function would you use?
What is one way to center text in a cell?
Cell D1 contains the value 7.877. You want cell D1 to display the value as 7.9 but keep the original number in calculations. How can yu=ou accomplish this?
To insert a new column to the left of a specific column, right-click the header containing the column's letter and select _.
You can never open any workbook that has previously been saved and given a name.
Your spreadsheet is printing, but the grid lines aren't showing up. What is most likely the problem?
How do you control which cells are printed?
____ adds a range of cells together.
What tool allows you to summarize and analyze data in various categories?