would be entered into which of the following? Responses A$.$ A cell containing a formula or function cannot be used with Goal Seek B$.$ To value C$.$ By changing cell D$.$ Set cell $2.$ When entering settings into the Goal Seek dialog box, the cell reference used$1.$ When entering settings into the Goal Seek dialog box, a cell that contains a formula or function would be entered into which of the following? ResponsesA. A cell containing a formula or function cannot be used with Goal SeekB. To valueC. By changing cellD. Set cell