USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Subtotal
|
|
|
Grand Total
|
|
|
Final Total
|
|
|
Subpar
|
Detailed explanation-1: -SUBTOTAL can be used as a nested function as part of other functions, including formulas containing the IF function. If another SUBTOTAL formula is within the ref1 data range, then SUBTOTAL will ignore it and exclude it from the overall calculation.
Detailed explanation-2: -The subtotal summary will get created in Microsoft Excel. Go to data Tab, and select Subtotal from the Outline group. Subtotal dialog box will appear. Select year from the drop down list of ‘At each change in’.
Detailed explanation-3: -You can sum values by group with one formula easily in Excel. Select next cell to the data range, type this =IF(A2=A1, "", SUMIF(A:A, A2, B:B)), (A2 is the relative cell you want to sum based on, A1 is the column header, A:A is the column you want to sum based on, the B:B is the column you want to sum the values.)