Multiple Choice
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.
Correct Answer:

Verified
Correct Answer:
Verified
Q43: An Error Alert button names the type
Q44: You should protect your entire workbook file
Q45: To work with advanced macro features, the
Q46: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING
Q47: To unprotect a workbook, on the REVIEW
Q49: Cell formula printouts also serve as a
Q50: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING
Q51: Cells with comments have blue indicator triangles
Q52: If a cell contains an error-indicator triangle
Q53: MATCHING<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB3934/.jpg" alt="MATCHING