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 replacekey in the minheap class with the following signature: public void replacekey(integer oldkey, integer newkey) the method will replace the first occurrence of oldkey with the newkey, and restore the min-heap property after the change. if the oldkey does not exist in the heap, the method prints an appropriate message and returns without changing the heap. example: suppose our binary heap object (bh) has the following keys: *** 4 6 7 32 19 64 26 99 42 54 28 then the method call: bh.replacekey (oldkey integer(54), newkey integer(2))

Identify at least three types of characteristics that you were asked about as you the computer identify a fruit.

In a compound condition, both conditions on either side of the logical operator and must be true for the overall condition to be true. a: true b: false