Given a spreadsheet containing five columns:SuburbStatePostcodeQuantityIf you'd like to create a subtotal based on Quantity for each State, then you'll need to Blank 1 Question 5 by Blank 2 Question 5 , before running Subtotal.
Question
Given a spreadsheet containing five columns:SuburbStatePostcodeQuantityIf you'd like to create a subtotal based on Quantity for each State, then you'll need to Blank 1 Question 5 by Blank 2 Question 5 , before running Subtotal.
Solution
To answer your question, you need to follow these steps:
-
First, you need to sort your data by the 'State' column. This is because the Subtotal function in Excel creates a subtotal for each unique value in the sorted column. So, if you want a subtotal for each State, you need to sort your data by the 'State' column first. This is what you need to fill in for 'Blank 1 Question 5'.
-
Next, you need to select the 'Quantity' column. This is because you want to create a subtotal based on Quantity. So, you need to select the 'Quantity' column before running the Subtotal function. This is what you need to fill in for 'Blank 2 Question 5'.
-
Finally, you can run the Subtotal function. In Excel, you can do this by going to the 'Data' tab, then click on 'Subtotal'. A dialog box will appear. In the 'At each change in' box, select 'State'. In the 'Use function' box, select 'Sum'. In the 'Add subtotal to' box, select 'Quantity'. Then click 'OK'. Excel will then create a subtotal for the Quantity for each State in your data.
Similar Questions
The first step when using the Subtotal command is to_____________.Group of answer choicesSort the list.Open the Subtotal dialog box.Insert blank rows between each data group.Select the function used to calculate the subtotals.
When using the subtotal function, you can calculate what values?Group of answer choicesSumAverageMinimumAll of the Above
Which of the following can be done to insert two levels of subtotals to a data.Group of answer choicesOpen the Subtotal window and add both levels of Subtotal at the same timeOpen the Subtotal window and add the Subtotal for Primary Category Open the Subtotal window a second time and add Subtotal for the Secondary CategoryOpen the Subtotal window and add the Subtotal for Secondary Category Open the Subtotal window a second time and add Subtotal for the Primary CategoryAll of the above
To add subtotal, what should be in "At each change in" box:Group of answer choicesSpecify sorted rowspecify filtered column Specify filtered rowSpecify sorted column
OOPS! You made a mistake while creating Subtotal in Excel. Which of the following is the fastest and easiest way to remove all Subtotal features?Group of answer choicesClick on Subtotal under Outline group and click "Remove All" button. Simply add a new set of correct subtotals, then hide the incorrect ones.Write down the current subtotals on a piece of paper, then delete/restore the subtotals one by one until you find your error. Then delete all the remaining subtotals making sure to keep the proper values in the new subtotals as you go.It is hard to remove Subtotal features, so continue working without removing them even though the data might be inaccurate.
Upgrade your grade with Knowee
Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.