Question

totals/adds data arranged in an array-that is, a group of cells with labels for columns and/or rows Which step one must should follow before using the Subtotal option? a. Consolidate b. Rename Data c. Filter Data d. Subtotal​

Answer 1

Answer:

b. Rename Data

Explanation:

We have to Rename the Data so that Open office can identify the range.

Answer 2

Answer:

option- d

Explanation:

subtotal

there are two steps to follow when we wish to use the subtotal function .

these are: formatting and sorting of the provided Excel data . applying subtotal to the syllabus.

using subtotal dialog, you can select upto three arrays , then choose a statistical function to apply to them.

FINAL ANSWER- option d

#SPJ3