DATABASE FUNDAMENTALS
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: -The Subtotal command allows you to automatically create groups and use common functions like SUM, COUNT, and AVERAGE to help summarize your data. For example, the Subtotal command could help to calculate the cost of office supplies by type from a large inventory order.
Detailed explanation-2: -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-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.)