Identify the correct sequence
I
A. First open subtotals window and then select the data where we need to apply subtotals.
B. Both of the above are correct
C. None of these
D. First Select data and then open subtotals window
Answers
Answer:
The correct sequence is (D) First Select data and then open subtotals window.
Explanation:
MS Excel is a spreadsheet that is used for calculation, creating pivot tables, graphing tools and also known as macro programming language.
Various uses of the excel file:
1) It is used for scheduling and calendars.
2) it is used for forecasting any updates.
3) it is used for collecting and verifying the data of the business.
4) it is used for data entry.
5) it is used by accounting and for budgeting.
Procedure to open the sub total dialog box:
1) First, select At each change in box choose the fist column which you want to based on subtotal.
2) Next, you need to use a function box and select the summary function so that it will be used for getting the total of columns.
3) now, we have look for the list and check mark the columns for which the subtotal is applicable.
4) Again, we have to remove the check mark from “Replace the current subtotals”.
5) Finally, click on OK button and the dialog box should be closed.
Therefore, the correct sequence is First Select data and then open subtotals window.
#SPJ3
Answer:
D. First Select data and then open subtotals window
Explanation:
Opening the Sub Total Dialog Box procedure:
1) Pick first Choose the first column you wish to base changes on for each box change.
2) Next, utilise a function box and choose the summary function to use it to calculate the sum of the columns.
3) Next, we must locate the list and indicate the columns that the subtotal applies to.
4) Once more, we must uncheck the box next to "Replace the current subtotals."
5) To close the dialogue box, click the OK button at the end.
Uses for the excel file include:
1) Calendars and scheduling are used with it.
2) It is employed for updating forecasts.
3) It is used to gather and validate the company's data.
4) Data entry is done with it.
5) Accounting and budgeting both use it.
#SPJ3