The ________ window has options to create multiple PivotCharts on the same worksheet using data from all connected data sources

Suppose we have a String object referenced by a variable called listing. Suppose we want a new String object that consists of the first 5 characters in listing. Which of the following lines of code will achieve this?

a) String prefix = listing.front(5); b) String prefix = listing.front(6); c) String prefix = listing.substring(1,5); d) String prefix = listing.substring(0,5); e) String prefix = listing.firstChars(5);

A formula containing the entry =J$7 is copied to a cell three columns to the right and four rows down. How will the entry display in its new location?

What will be an ideal response?