Elianna has put together the Projected Income worksheet above. She is finalizing the worksheet for a presentation to her company's board of directors. When needed, please refer to the figure above as you answer the questions below.
-Under Assumptions, Elianna accidentally clears the entry for COGS, 300%, and she wants to recreate it. She only wants data entered as a percentage between 0 and 1. She also knows that several top managers throughout the company will be entering the data. What could Elianna do to guide them?
A) Set up a new macro.
B) Display formulas.
C) Set COGS to 50.
D) Set up a validation rule.

Question

Elianna has put together the Projected Income worksheet above. She is finalizing the worksheet for a presentation to her company's board of directors. When needed, please refer to the figure above as you answer the questions below.
-Under Assumptions, Elianna accidentally clears the entry for COGS, 300%, and she wants to recreate it. She only wants data entered as a percentage between 0 and 1. She also knows that several top managers throughout the company will be entering the data. What could Elianna do to guide them?
A) Set up a new macro. 
B) Display formulas. 
C) Set COGS to 50. 
D) Set up a validation rule.

Quizplus · Accepted Answer

Elianna should set up a validation rule to restrict data entry for COGS between 0 and 1 as a percentage. This will guide the top managers throughout the company and ensure accurate data entry. A macro or displaying formulas are not necessary for this task, and setting COGS to 50 would not be appropriate as it is not a percentage value.

Elianna Has Put Together the Projected Income Worksheet Above