Case-Based Critical Thinking Questions
?
Case 3-2
Susan is in charge of the inventory reports for her company.  She will need to find specific inventory items as well as project increases in inventory costs.  To get ready she will create a worksheet and use the Microsoft Excel 2016 Analysis tools.
?
?
Susan wants to automate the trial-and-error process by allowing her to specify a value for a calculated item, which Excel uses to determine the input value needed to reach that goal. She can use ______.

A. Data Validation
B. Goal Seek
C. Goal Set
D. If Conditional


Answer: B

Computer Science & Information Technology

You might also like to view...

Describe some illegal reconnaissance activities.

What will be an ideal response?

Computer Science & Information Technology

Would disk scheduling be useful for a single-user, dedicated disk in a sequential file processing application?Why?

What will be an ideal response?

Computer Science & Information Technology

Which type of malware will hide or remove all traces of evidence that may reveal the malware, such as log entries?

A. Virus B. Rootkit C. Trojan D. Adware

Computer Science & Information Technology

Changes made to the original worksheet are automatically reflected in the PivotTable

Indicate whether the statement is true or false

Computer Science & Information Technology