Select the correct option. (advanced electronic spreadsheet) 1. It collates the data from different ranges and places it in a worksheet.
a. Consolidate
b. Combining
C. Subtotals

2. It generates a subtotal to summarise the data.
a. Define range
b. Total
c. Subtotals

3. Which tab holds the 'What-If Analysis' option?
a. Analysis
b. Data Tools
c. Developer

4. It is the elaborate form of Goal Seek.
a. Detective
b. Solver
C. Scenario

5. It is used to set a goal to find the optimum value for one or more target variables.
a. Scenario
b. Goal Seek
c. Detective

Write a method that takes in an array of point2d objects, and then analyzes the dataset to find points that are close together. be sure to review the point2d api. in your method, if the distance between any pair of points is less than 10, display the distance and the (x,y)s of each point. for example, "the distance between (3,5) and (8,9) is 6.40312." the complete api for the point2d adt may be viewed at ~pf/sedgewick-wayne/algs4/documentation/point2d.html (links to an external site.)links to an external site.. try to write your program directly from the api - do not review the adt's source code.

Asecurity policy is a a. set of guidlines b. set of transmission protocols c. written document d. set of rules based on standards and guidelines

Which of the following is not a key player in the sale of travel products?