USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Excel inserts a subtotal line whenever it detects a change in the value of the chosen field.
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -The quickest and easiest way to sum a range of cells is to use the Excel AutoSum button. It automatically enters an Excel SUM function in the selected cell.
Detailed explanation-2: -The SUBTOTAL function in Microsoft Excel returns the subtotal value from a range of cells. It allows you to use other functions, like AVERAGE or COUNT, to find custom totals from a dataset.
Detailed explanation-3: -Select a cell within the list you want to subtotal, and then, on the Data menu, click subtotals. In the At Each Change In box, select the field you want to create subtotals for. In the Use Function box, select the type of calculation you want the subtotal to perform.
There is 1 question to complete.