e05h2Sociology.xlsx (solution)

a. Open e05h1Sociology_LastFirst if you closed it at the end on Hands-On Exercise 1 and save it as e05h2Sociology_LastFirst , changing h1 to h2 .

b. Click the Books Data worksheet tab . Excel does not let you create a Pivotable using subtotaled data. To preserve the subtotals you created in Hands-On Exercise 1, you will use the dataset in the Books Data worksheet.

c. Click in cell A5 , click the INSERT tab , and then click Recommended PivotTables in the tables group. The Recommended Pivottables dialog box opens (see Figure 5.10). d. Scroll the thumbnails or recommended Pivottables and click the Sum of Total Book Sales by Discipline thumbnail . (NOnE: Hover the mouse pointer over the thumbnails to see the full names.) You selected this PivotTable to show the overall total book sales for each discipline. The dialog box shows a preview or the selected Pivot Table

 

a. Open e05h1Sociology_LastFirst if you closed it at the end on Hands-On Exercise 1 and save it as e05h2Sociology_LastFirst , changing h1 to h2 .

b. Click the Books Data worksheet tab . Excel does not let you create a Pivotable using subtotaled data. To preserve the subtotals you created in Hands-On Exercise 1, you will use the dataset in the Books Data worksheet.

c. Click in cell A5 , click the INSERT tab , and then click Recommended PivotTables in the tables group. The Recommended Pivottables dialog box opens (see Figure 5.10). d. Scroll the thumbnails or recommended Pivottables and click the Sum of Total Book Sales by Discipline thumbnail . (NOnE: Hover the mouse pointer over the thumbnails to see the full names.) You selected this PivotTable to show the overall total book sales for each discipline. The dialog box shows a preview or the selected Pivot Table

 

a. Open e05h1Sociology_LastFirst if you closed it at the end on Hands-On Exercise 1 and save it as e05h2Sociology_LastFirst , changing h1 to h2 .

b. Click the Books Data worksheet tab . Excel does not let you create a Pivotable using subtotaled data. To preserve the subtotals you created in Hands-On Exercise 1, you will use the dataset in the Books Data worksheet.

c. Click in cell A5 , click the INSERT tab , and then click Recommended PivotTables in the tables group. The Recommended Pivottables dialog box opens (see Figure 5.10). d. Scroll the thumbnails or recommended Pivottables and click the Sum of Total Book Sales by Discipline thumbnail . (NOnE: Hover the mouse pointer over the thumbnails to see the full names.) You selected this PivotTable to show the overall total book sales for each discipline. The dialog box shows a preview or the selected Pivot Table

 

a. Open e05h1Sociology_LastFirst if you closed it at the end on Hands-On Exercise 1 and save it as e05h2Sociology_LastFirst , changing h1 to h2 .

b. Click the Books Data worksheet tab . Excel does not let you create a Pivotable using subtotaled data. To preserve the subtotals you created in Hands-On Exercise 1, you will use the dataset in the Books Data worksheet.

c. Click in cell A5 , click the INSERT tab , and then click Recommended PivotTables in the tables group. The Recommended Pivottables dialog box opens (see Figure 5.10). d. Scroll the thumbnails or recommended Pivottables and click the Sum of Total Book Sales by Discipline thumbnail . (NOnE: Hover the mouse pointer over the thumbnails to see the full names.) You selected this PivotTable to show the overall total book sales for each discipline. The dialog box shows a preview or the selected Pivot Table

a. Open e05h1Sociology_LastFirst if you closed it at the end on Hands-On Exercise 1 and save it as e05h2Sociology_LastFirst , changing h1 to h2 .

b. Click the Books Data worksheet tab . Excel does not let you create a Pivotable using subtotaled data. To preserve the subtotals you created in Hands-On Exercise 1, you will use the dataset in the Books Data worksheet.

c. Click in cell A5 , click the INSERT tab , and then click Recommended PivotTables in the tables group. The Recommended Pivottables dialog box opens (see Figure 5.10). d. Scroll the thumbnails or recommended Pivottables and click the Sum of Total Book Sales by Discipline thumbnail . (NOnE: Hover the mouse pointer over the thumbnails to see the full names.) You selected this PivotTable to show the overall total book sales for each discipline. The dialog box shows a preview or the selected Pivot Table

a. Open e05h1Sociology_LastFirst if you closed it at the end on Hands-On Exercise 1 and save it as e05h2Sociology_LastFirst , changing h1 to h2 .

b. Click the Books Data worksheet tab . Excel does not let you create a Pivotable using subtotaled data. To preserve the subtotals you created in Hands-On Exercise 1, you will use the dataset in the Books Data worksheet.

c. Click in cell A5 , click the INSERT tab , and then click Recommended PivotTables in the tables group. The Recommended Pivottables dialog box opens (see Figure 5.10). d. Scroll the thumbnails or recommended Pivottables and click the Sum of Total Book Sales by Discipline thumbnail . (NOnE: Hover the mouse pointer over the thumbnails to see the full names.) You selected this PivotTable to show the overall total book sales for each discipline. The dialog box shows a preview or the selected Pivot Table

 

Answers

Related Questions

Other : FIN430 M1A3 - Time Value of Money Calculat...

 Assignment 3: Time Value of Money Calculations The IT department has requested an update in its server population. This upgrade is required to main...

Other : FIN430 M1A3 - Time Value of Money Calculat...

 Assignment 3: Time Value of Money Calculations The IT department has requested an update in its server population. This upgrade is required to main...

Other : FIN430 M1A3 - Time Value of Money Calculat...

 Assignment 3: Time Value of Money Calculations The IT department has requested an update in its server population. This upgrade is required to main...

Other : FIN430 M1A3 - Time Value of Money Calculat...

 Assignment 3: Time Value of Money Calculations The IT department has requested an update in its server population. This upgrade is required to main...

Other : FIN430 M1A3 - Time Value of Money Calculat...

 Assignment 3: Time Value of Money Calculations The IT department has requested an update in its server population. This upgrade is required to main...

Sociology : reading question require carefully and...

Not too much reference, thought by your self.ALSO THERE ARE FOUR FILES WHICH ARE THE NOTEBOOK'S PPT. AFTER READ AND WRITE PAPER“Dear Abby” is...

Other : FIN430 M1A3 - Time Value of Money Calculat...

 Assignment 3: Time Value of Money Calculations The IT department has requested an update in its server population. This upgrade is required to main...

Marketing : Compare viral marketing campaigns...

Compare viral marketing campaigns. I spoke a challenge versus red nose day of 2015. All work must follow AP style guidelines.Find a link from the offi...

Political Science : Policy Analysis Esaay Report...

POLS 3314 ASSIGNMENT This is an open book assignment.  Follow the specific instructions of data analysis for each question.There are three question...

Health & Medical : Hi Anyone can help me please...

Discuss how a chart is to be organized, include data elements, source oriented versus problem oriented, active, inactive or closed status.  Describe...

Programming : Need programming help for writing an...

AssignmentDetails_11_22_2015.pdfIn this assignment, you will be asked to demonstrate what you have learned in the Discussion Board in terms of vector,...

Humanities : 1-8 are all separate assignment resp...

1Why was T. Hall singled out for scrutiny?How did T. Hall’s neighbors respond to the gossip that this person’s sex was unclear?What authority did...

Humanities : Journal paper...

In this first journal activity, you may write about any topic(s) of your choice, but it is best to use the textbook to study.For this activity, topics...

Humanities : History research paper...

Note: Before beginning this assignment, read through information contained in the Scholastic Dishonesty link in the course menu to the left.The core...

Accounting : Preparing Adjusting Entries...

Kinokawa Consultants Company’s trial balance on December 31, 2014, follows.The following information is also available: Ending inventory of office...

Business Finance : Strategic Plan Part 2: SWOT An...

Attached is the previous essay that relates to this question. Conduct an internal and external environmental analysis, and a supply chain analysis f...

Algebra : Algebra 2 homework question...

You are having a conference call with the CEO of a paper company. You have interpreted the number of trees cut down versus profit as the function P(x)...

Political Science : Policy analysis assignment...

POLS 3314 ASSIGNMENT  This is an open book assignment.  Follow the specific instructions of data analysis for each question. There are three ques...

Other : Policy analysis assignment/ instructions b...

POLS 3314 ASSIGNMENT  This is an open book assignment.  Follow the specific instructions of data analysis for each question. There are three questi...

Political Science : Policy Analysis Assignment/ In...

Instructions POLS 3314 ASSIGNMENT  This is an open book assignment.Follow the specific instructions of data analysis for each question.  There are...

Management : Principals of Management...

Bank of America is the company that you will be writing two paragraghs with 5 to 10 sentence on both questions below 1. Who are your organization’s...

Biology : Microbiology discussions...

In this first discussion, you will learn two important techniques commonly used in the microbiology lab. Proceed to the Virtual Interactive Bacteriol...

Humanities : They Say/ I Say type essay, English...

Summarize and respond to the following essay in They Say/ I Say:Richard Mueller, "Nuclear Waste"after an engaging introduction, you'll summarize t...

Other : Business Model Plan - Human Resource Manag...

Using the Osterwalder and Pigneur text as a resource (coupled with the other resources of the course), examine and discuss the observable patterns, de...

If you didn't find the right answer

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