e05h1Sociology.xlsx (solution)

Before you use the Subtotal feature, you must sort the data by discipline and then by area. After sorting the data, you will insert subtotals for each discipline. You want to see the totals for the wholesale sales, retail sales, and combined book sales. Refer to Figure 5.5 as you complete Step 1

a. Open e05h1Sociology and save it as e05h1Sociology_LastFirst

b. Click the DATA tab and click Sort in the Sort & Filter group.

c. Click the Sort by arrow and select Discipline in the Sort dialog box.

d. Click Add Level , click the Then by arrow , and then select Area . Click OK . Excel sorts the data by discipline in alphabetical order. Within each discipline, Excel sorts the data further by area. he data are sorted first by disciplines so that you can apply subtotals to each discipline.

e. Click Subtotal in the Outline group. the Subtotal dialog box opens. the default At each change in is the Discipline column, and the default Use function is Sum. These settings are correct.

f. Click the Sales: Wholesale check box in the Add subtotal to section.

g. Click the Sales: Retail check box in the Add subtotal to section. Excel selected the last column—total Book Sales—automatically. You selected the other two sales columns to total. You will leave the Replace current subtotals and Summary below data check boxes selected.

h. Click OK . Scroll to the right to see the subtotals and click cell L14 to see the SUBTOTAL function for the total book sales for the Aging/Death discipline. Save the workbook. Excel inserts subtotal rows after each discipline category. The subtotal rows include labels and subtotals for the wholesale sales, retail sales, and book sales columns

Before you use the Subtotal feature, you must sort the data by discipline and then by area. After sorting the data, you will insert subtotals for each discipline. You want to see the totals for the wholesale sales, retail sales, and combined book sales. Refer to Figure 5.5 as you complete Step 1

a. Open e05h1Sociology and save it as e05h1Sociology_LastFirst

b. Click the DATA tab and click Sort in the Sort & Filter group.

c. Click the Sort by arrow and select Discipline in the Sort dialog box.

d. Click Add Level , click the Then by arrow , and then select Area . Click OK . Excel sorts the data by discipline in alphabetical order. Within each discipline, Excel sorts the data further by area. he data are sorted first by disciplines so that you can apply subtotals to each discipline.

e. Click Subtotal in the Outline group. the Subtotal dialog box opens. the default At each change in is the Discipline column, and the default Use function is Sum. These settings are correct.

f. Click the Sales: Wholesale check box in the Add subtotal to section.

g. Click the Sales: Retail check box in the Add subtotal to section. Excel selected the last column—total Book Sales—automatically. You selected the other two sales columns to total. You will leave the Replace current subtotals and Summary below data check boxes selected.

h. Click OK . Scroll to the right to see the subtotals and click cell L14 to see the SUBTOTAL function for the total book sales for the Aging/Death discipline. Save the workbook. Excel inserts subtotal rows after each discipline category. The subtotal rows include labels and subtotals for the wholesale sales, retail sales, and book sales columns

Before you use the Subtotal feature, you must sort the data by discipline and then by area. After sorting the data, you will insert subtotals for each discipline. You want to see the totals for the wholesale sales, retail sales, and combined book sales. Refer to Figure 5.5 as you complete Step 1

a. Open e05h1Sociology and save it as e05h1Sociology_LastFirst

b. Click the DATA tab and click Sort in the Sort & Filter group.

c. Click the Sort by arrow and select Discipline in the Sort dialog box.

d. Click Add Level , click the Then by arrow , and then select Area . Click OK . Excel sorts the data by discipline in alphabetical order. Within each discipline, Excel sorts the data further by area. he data are sorted first by disciplines so that you can apply subtotals to each discipline.

e. Click Subtotal in the Outline group. the Subtotal dialog box opens. the default At each change in is the Discipline column, and the default Use function is Sum. These settings are correct.

f. Click the Sales: Wholesale check box in the Add subtotal to section.

g. Click the Sales: Retail check box in the Add subtotal to section. Excel selected the last column—total Book Sales—automatically. You selected the other two sales columns to total. You will leave the Replace current subtotals and Summary below data check boxes selected.

h. Click OK . Scroll to the right to see the subtotals and click cell L14 to see the SUBTOTAL function for the total book sales for the Aging/Death discipline. Save the workbook. Excel inserts subtotal rows after each discipline category. The subtotal rows include labels and subtotals for the wholesale sales, retail sales, and book sales columns

Before you use the Subtotal feature, you must sort the data by discipline and then by area. After sorting the data, you will insert subtotals for each discipline. You want to see the totals for the wholesale sales, retail sales, and combined book sales. Refer to Figure 5.5 as you complete Step 1

a. Open e05h1Sociology and save it as e05h1Sociology_LastFirst

b. Click the DATA tab and click Sort in the Sort & Filter group.

c. Click the Sort by arrow and select Discipline in the Sort dialog box.

d. Click Add Level , click the Then by arrow , and then select Area . Click OK . Excel sorts the data by discipline in alphabetical order. Within each discipline, Excel sorts the data further by area. he data are sorted first by disciplines so that you can apply subtotals to each discipline.

e. Click Subtotal in the Outline group. the Subtotal dialog box opens. the default At each change in is the Discipline column, and the default Use function is Sum. These settings are correct.

f. Click the Sales: Wholesale check box in the Add subtotal to section.

g. Click the Sales: Retail check box in the Add subtotal to section. Excel selected the last column—total Book Sales—automatically. You selected the other two sales columns to total. You will leave the Replace current subtotals and Summary below data check boxes selected.

h. Click OK . Scroll to the right to see the subtotals and click cell L14 to see the SUBTOTAL function for the total book sales for the Aging/Death discipline. Save the workbook. Excel inserts subtotal rows after each discipline category. The subtotal rows include labels and subtotals for the wholesale sales, retail sales, and book sales columns

Answers

Related Questions

Business Finance : Cumberlands University Differe...

Assignment: 1 Discussion Topic: Congratulations! You have recently been promoted and are the company’s new Human Resources Manager! You have offices...

Science : Good Manufacturing practices...

I have a question on Good Manufacturing practices Many people take Varsanta products, and there are several generic versions of this well done blood p...

Business Finance : UMUC Week 5 Understanding of E...

Respond: Week 5, Discussion 5.2 - Applying Our Understanding of Effective Listening Skills Participation in this learning activity is worth 2.5% of yo...

Humanities : City College of San Francisco Ethics...

1. Should the makers of the documentary have tried to intervene in any of the twenty-plus suicides they witnessed? Why or why not? 2. If a local news...

Writing : change proposal...

……..discussion question 250 words...……. Stakeholder support is necessary for a successful change proposal project implementation. Consider you...

Science : Houston Community College System Ethics...

Directions 1. Choose one of the following case studies: Case A: In the US, our system of disaster triage is based upon which ethical principle? Health...

Humanities : Fundacao Getulio Vargas Social Activ...

I need a 6-8 page research paper. with 5-8 sources 2 of them being books. and the basis of the paper needs to use different examples of activism and t...

Business Finance : UMUC Week 5 Understanding of O...

Respond: Week 5, Discussion 5.1 - Applying Our Understanding of Organizational Cultures Participation in this learning activity is worth 2.5% of your...

Humanities : Just an outline...

The draft of the research prospectus is due by Thursday, Nov. 21. While the academic literature search was a group project, the draft and final versio...

Business Finance : Communications Management (3-1...

Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks....

Business Finance : Knowledge management (3-1)...

Avoid plagiarism, the work should be in your own words, copying from students or other resources without proper referencing will result in ZERO marks....

Humanities : Guns, Germs, and Steel--Conquest...

In this episode of Guns, Germs, and Steel, Jared Diamond offers his explanation for how Spaniards conquered the Inca Empire in the sixteenth century....

Business Finance : Unit 1 Discussion Board...

Eddison Electronic Company (EEC) provides electricity for several states in the United States. You have been employed as a cost accountant at this org...

Writing : ENG 130 Unit 5 Assignment...

In this essay, you will argue which conflict Wilson uses most to drive (bring forth, move forward) all the other elements of the story? This assignmen...

Humanities : ​Trace the evolution of your profe...

Trace the evolution of your profession (or another chosen profession), field of study, or branch of service, starting in the Cold War era and continui...

Humanities : Minor Assignment 3: Advertising Anal...

Action: What is going on in this ad? Is there any action? If not, what is happening in the image? Who is doing each action? Why is this important?Peop...

Writing : Part 1: Post a Response...

Which one of the strategies listed below do you believe will best help you prepare to deliver your introductory speech in an online environment? Thoro...

Programming : In 500 words or more, compare DNS f...

In 500 words or more, compare DNS failover and cloud failover. Use at least three sources. Include at least 3 quotes from your sources enclosed in quo...

Writing : Write a systematic review paper...

My topic: Effect of music on exercise performance (heart rate and rating of perceived exertion)Final Manuscript Requirements ChecklistTitle of 18 or l...

Business Finance : using survey123 withDaesh crim...

Must include the following: How can survey123 help the Kakayi communities with reporting crimes committed against them by isis Advantage and disadvant...

Programming : Propose and defend a topic for your...

Propose and defend a topic for your final project. Write 500 words or more explaining why this topic is important for your peers to understand. Be foc...

Programming : Boston University Oracle12c: SQL Ch...

Q1 List the first name and the last name of each customer who placed more than the average number of orders. Along with the names, show the total each...

Business Finance : ETH501 Trident University Inte...

This Case 3 focuses on how a large, well-respected financial institution can seriously put its reputation at stake and what happened to bring that abo...

Writing : University of California Statement of P...

Option 1: Statement of Purpose Perhaps the most common personal narrative, a personal statement or statement of purpose provides future graduate schoo...

If you didn't find the right answer

Ask Your Questions, We'll notify you once someone answers it