Question

in the spreadsheet ______ function is used to total a data arranged in an array that is how a group of cell with labels for columns and a row.

(a) solver
(b) gold seek
(c) sub total
(d) macro​

Answer 1

Answer:

(a)

Explanation:

thank you for your support

Answer 2

Option (c) sub total

In the spreadsheet  sub total function is used to total a data arranged in an array that is how a group of cell with labels for columns and a row.

• By creating a subtotal dashboard over a filtered area, SUBTOTAL can be utilized to quickly analyze various subsets of data. The dashboard will automatically update with new aggregations each time the filter criteria are modified. SUBTOTAL helps avoid double-counting that can occur with straightforward SUM calculations.
• When a Total row is displayed in an Excel Table, the SUBTOTAL function is used. Excel automatically inserts the SUBTOTAL function, and a drop-down option lets you change the behaviour and display the maximum, minimum, average, and other values.
• The function codes are shown below and are always accessible in Google Sheets. You must first start typing the function =SUBTOTAL in order to accomplish this. The "Learn More" button is then located in the formula assistance section on the bottom left. Choose that.
• By creating a subtotal dashboard over a filtered area, SUBTOTAL can be utilised to quickly analyse various subsets of data. The dashboard will automatically update with new aggregations each time the filter criteria are modified. SUBTOTAL helps avoid double-counting that can occur with straightforward SUM calculations.
• The sum of all the items and quantities in the shopping cart, with any item promotions that have been applied, is the subtotal. The subtotal of the Shopping Cart does not include applicable order discounts, anticipated shipping, or applied shipping discounts.

#SPJ2