nerdexam
IBM

COG-706 · Question #42

You want to connect to an external Excel file using the data load method.Which two selections should you perform to accomplish this? (Choose two.)

The correct answer is A. The range selected should only contain what is needed for the report. D. The range of numbers should be rounded at the source Excel file externally from FSR if possible. See the full explanation below for the reasoning.

Question

You want to connect to an external Excel file using the data load method.Which two selections should you perform to accomplish this? (Choose two.)

Options

  • AThe range selected should only contain what is needed for the report.
  • BThe ranges should contain as many V-Lookup formulas as possible.
  • CThe range should contain links to multiple Excel spreadsheets and multiple workbook sheets
  • DThe range of numbers should be rounded at the source Excel file externally from FSR if possible.

How the community answered

(17 responses)
  • A
    82% (14)
  • B
    12% (2)
  • C
    6% (1)

Community Discussion

No community discussion yet for this question.

Full COG-706 Practice