Question

in calc, using the subtotal dialog, you can select arrays and then choose a statistical function to apply to them for efficiency, you can choose up to ________ group of arrays to which to apply a function. a- two, b- three, c- four, d- five​

Answer 1

Answer:

Option B

Explanation:

there are 3 group of arrays in Calc

Answer 2

You can choose arrays in Calc and apply a statistical function to them using the Subtotals dialogue. You can apply a function to up to three different groups of arrays for efficiency.

Explanation:

SUBTOTAL:

SUBTOTAL is listed in the Mathematical category, When you utilise the Function Wizard (Insert > Function). The function has a graphical interface that can be accessed from Data > Subtotals because of its utility.

SUBTOTAL totals data in an array, which is a collection of cells with column labels.

You can select up to three arrays in the Subtotals dialogue, then apply a statistical function to them.

Matching elements in your array will be grouped together as a single group above a subtotal by default.

To add subtotal values to a sheet, do the following:

• Make sure the columns are labelled.
• Choose Data > Subtotals after selecting the range of cells for which you wish to generate subtotals.
• Select the column by which the subtotals should be classified in the Subtotals dialog's Group by list. For each individual value in this column, a subtotal will be generated.
• Select the columns containing the numbers you wish to produce subtotals for in the Calculate subtotals for box. The subtotals are automatically recalculated if the values of the specified columns change later.
• Select the function you want to use to calculate the subtotals in the  function box.
• Click OK.

Final answer:

In calc , using the subtotal dialog we can choose upto to three group of arrays to apply a function

#SPJ3