Question: An Excel workbook contains three worksheets: Data, Report, and Reference. The following was entered into cell A 5 in the Report worksheet: = Data!C 2
An Excel workbook contains three worksheets: Data, Report, and Reference. The following was entered into cell A in the Report worksheet: Data!C Which of the following is true with regards to this entry?
The value entered into cell C on the Data worksheet will appear in cell A on the report worksheet.
The one argument of the Data function is defined with the cell reference
The cell reference must be enclosed in parentheses.
This is not a proper Excel function and will produce an error output in cell A on the Report worksheet.
The value entered into cell A in the Report worksheet will appear in cell C on the Data worksheet.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
