Question

Write command(s) to calculate subtotals for expense filed in an expense worksheet.​

Answer 1

Explanation:

${\huge\fbox\pink{A}\fbox\blue{N}\fbox\purple{S}\fbox\green{W}\fbox\red{E}\fbox\orange{R}}$

• On the Data tab, in the Outline group, click Subtotal. The Subtotal dialog box is displayed.
• In the At each change in box, click the nested subtotal column.
• In the Use function box, click the summary function that you want to use to calculate the subtotals.
• Clear the Replace current subtotals check box.

Answer 2

ANSWER:-

The command(s) to calculate subtotals for expenses filed in an expense worksheet.

• Click on the Data tab then in the Outline group, click Subtotal and then the Subtotal dialog box will be displayed.
• At each change in the box, click the nested subtotal column.
• In the Use function box, click the summary function( “=SUBTOTAL(4, A2: A4)” to select the cell with the maximum value from A2 to A4 function) that you want to use to calculate the subtotals.
• Clear the Replace recent subtotals check box.

EXPLANATION:-

• Example:- “=SUBTOTAL(4, A2: A4)” selects the cell with the maximum value from A2 to A4

• To define which function you want to replicate, you need to infiltrate its defined code as a statement. After this, infiltrate the other statements as if you were using that function.

• The SUBTOTAL() function reimburses the subtotal in a database. Relying on what you want, you can select either average, count, sum, min, max, and others.

#SPJ2