Revenue and expense reports.

 

 

For the Module 8 Lab Assignment, you will help the financial director of Matchbox Financial prepare and analyze revenue and expense reports. HINT: The finished Module 8 Lab Assignment should include 4 worksheets.

Problem: You work for Matchbox Financial and help the CFO prepare and analyze revenue and expense reports. He has asked you to create two PivotTables and corresponding PivotCharts based on sales data. One PivotTable and PivotChart summarize the sales by supplier. The other PivotTable and PivotChart summarize the digital products sales by month for the top supplier.

Perform the following tasks:

1. Open the workbook, Lab 8 Matchbox Financial from the Data Files folder and save the workbook as LastnameFirstnameModule8Lab.

2. Create a new worksheet before the Sales Results worksheet with your name in cell A1, date in cell A2, course in cell A3, instructor name in cell A4, and assignment name in cell A5. Name this worksheet “Module 8 Lab Assignment Info”.

3. Using the data in the Sales Results worksheet, create a PivotTable in a separate worksheet named “Sales by Supplier”. Move this worksheet after “Sales Results” and change the worksheet tab color to orange. The PivotTable needs to start in cell A3; Store is in Columns, Supplier is in Rows, and Sum of Sales is in Values; sort Store and Supplier by A-Z)

4. Change the contents of cell A4 (Row Labels) to Supplier and cell B3 (Column Labels) to Store. Apply the ‘Pivot Style Dark 21’ style to the PivotTable (data font color is white, data background color is brown, column heading row and Grand Total row font color is white/background color is black). Format the values as currency values with a dollar sign and no decimal places.

5. Create a Clustered Column PivotChart from the PivotTable data. Resize the PivotChart to cover the range A18:G35 and then hide ALL field buttons. Apply the ‘Chart Style 14’ to the PivotChart (last chart style in selection menu).

6. Using the data in the “Sales Results” worksheet, create a second PivotTable (should start in cell A3; Store is in Columns, Supplier is in Rows, Sum of Sales is in Values, and Category is in Filters; sort Store and Month by A-Z) in a separate worksheet in the workbook named “Digital Product Sales by Month”. Move this worksheet after “Sales by Supplier”.

7. Change the contents of cell A4 (Row Labels) to Months and cell B3 (Column Labels) to Store. Apply the ‘Pivot Style Dark 7’ style to the PivotTable (data font color is black, data background color is tan, column heading row and Grand Total row font color is white/background color is brown). Format the values as currency values with a dollar sign and no decimal places. Filter the category by Digital Products. Filter the store to Wilton Wholesale Club.

8. Create a Line PivotChart from the PivotTable data. Resize the PivotChart to cover the range D1:H16 and then hide ALL field buttons. Apply the ‘Chart Style 15’ to the PivotChart (last chart style in selection menu). Delete the legend. Now, add a linear trendline that forecasts the trend for three more months. Add the R-squared value to the trendline and make it visible.

9. Update the author (use your name) and title (use ‘Student’) in the document properties.

Upload your assignment as a Microsoft Excel workbook using the following naming protocol: LastnameFirstnameModule8Lab.xlsx

Please answer these questions:

Among many advanced Excel users, PivotTables are known as the best thing since sliced bread. Provide a reason why you believe this idiom might be said among advanced Excel users. Do you agree or disagree with the idiom? Explain your reasoning!
Suggest (2) real-world scenarios in which a PivotTable report would be useful to analyze data.
Discuss the role planning plays in the decisions you must make when deciding how to best use PivotTables PivotCharts, trendlines, and slicers.

 

Sample Solution

 

 

 

 

Canada: The Beginning

GuidesorSubmit my paper for examination

Canada is a venerated nation in the North American landmass for its benevolent individuals, tranquil governmental issues, terrific natural life, and substantially more. In any case, for individuals who live outside this nation (second biggest as far as zone), the historical backdrop of this country may not be known or comprehended. So as to see how Canada turned into the nation it is presently, a diagram will be given.

Canada has experienced a long history before its Constitution was patriated in 1982. Truth be told, it starts with the pre-contact native timetable. As indicated by Britannica.com, “North America’s first people relocated from Asia, apparently over a currently submerged land connect from Siberia to Alaska at some point around 12,000 years prior, during the last Ice Age; it has additionally been contended, nonetheless, that a few people showed up before, potentially as long as 60,000 years back. Obscure quantities of individuals moved southward along the western edge of the North American ice top. The nearness of the ice, which for a period for all intents and purposes secured Canada, makes it sensible to expect that the southern scopes of North America were settled before Canada, and that the Inuit (Eskimo) who live in Canada’s Arctic districts today were the remainder of the native people groups to arrive at Canada” (Nicholson, Norman L., and Roger D. Lobby). Before Europeans came, around 12 dialects were created by the locals of the land, and these dialects were found in different societies and clans. In the long run, the Iroquois Confederacy was sorted out, which comprised of the Mohawk, Oneida, Onondaga, Cayuga, and Seneca people groups, and in the end the Tuscarora.

In these clans, and all through the Iroquois Confederacy, there was blend of agribusiness and chasing. Additionally, a few gatherings had a significant level of political, strict, social, and exchanging association. As indicated by Britannica.com, “The one trademark for all intents and purposes all the gatherings in precontact Canada shared was that they were self-administering and politically autonomous” (Nicholson, Norman L., and Roger D. Corridor). Despite the fact that the inevitable European pioneers and trespassers depicted the locals at times as savages, this was deduced out of obliviousness.

The principal European adventurers of the Canadian area were Vikings from Iceland, where they came to Labrador and Newfoundland. There are as yet the remaining parts of their settlements in these zones (Citizenship Canada). The locals and Vikings didn’t get along so well at first, despite the fact that they in the long run exchanged together, as per accessible proof (Nicholson, Norman L., and Roger D. Lobby). After the Vikings in the long run fled the district, John Cabot (otherwise known as Giovanni Caboti), an Italian guide happened upon this land. As indicated by the Canadian Encyclopedia, “Cabot and his team were the second gathering of Europeans to arrive at what might become Canada, chasing after Norse voyagers 1000 CE. In spite of not yielding the exchange course Cabot sought after, the 1497 journey furnished England with a case to North America and information on a huge new fishery” (“John Cabot”). Despite the fact that the Northwest Passage was not discovered, another piece of the British angling industry rose up out of this journey. It additionally started exchange between the locals and Europeans, however they were suspicious of one another.

The first asserting of land in Canada was by the French. As expressed by Canada.ca, “Somewhere in the range of 1534 and 1542, Jacques Cartier made three journeys over the Atlantic, asserting the land for King Francis I of France. Cartier heard two caught guides express the Iroquoian word kanata, signifying “town.” By the 1550s, the name of Canada started showing up on maps” (Citizenship Canada). After these journeys, the principal French settlement was developed. As indicated by Britannica, “… the French lord, restless to challenge the cases of Spain in the New World, chose to set up a sustained settlement. Inward and European legislative issues deferred the venture until 1541, when, under the order of Jean-François de La Rocque, sieur (master) de Roberval, Cartier came back to Stadacona and established Charlesbourg-Royal only northwest of Quebec” (Nicholson, Norman L., and Roger D. Corridor). Despite the fact that the French didn’t find jewels and different valuable things in their new land, they despite everything made a case for the region that they “found.”

Progressively French settlement action proceeded for the sake of contending with the Spanish. As indicated by Britannica, “In 1604 the French guide Samuel de Champlain, under Pierre du Gua, sieur de Monts, who had gotten an award of the imposing business model, drove a gathering of pilgrims to Acadia. He picked as a site Dochet Island (Île Sainte-Croix) in the St. Croix River, on the current limit between the United States and Canada. Be that as it may, the island demonstrated unsatisfactory, and in 1605 the settlement was moved over the Bay of Fundy to Port Royal (presently Annapolis Royal, Nova Scotia)” (Nicholson, Norman L., and Roger D. Corridor). Despite the fact that the settlement was made as a hide exchanging post, its water frameworks (waterways) were too hard to even consider getting through for the productive conveyance of merchandise. This settlement in the end moved, and they additionally engaged in united fighting with the locals. As per Discover Canada, “In 1608 Champlain assembled a stronghold at what is presently Québec City. Champlain associated the state with the Algonquin, Montagnais, and Huron, memorable foes of the Iroquois, a confederation of five (later six) First Nations who combat with the French settlements for a century. The French and the Iroquois made harmony in 1701” (Citizenship Canada). Not at all like in the United States, the pilgrims were progressively deferential towards the locals, and even battled for the privileges of specific clans.

In the consequent years, England, the Netherlands, and furthermore Scotland attempted to guarantee portions of Canada as their own through exchange and fighting. The locals likewise got more interweaved in the matter of hide exchange, and even battled among clans for power over exchange. Rivalry for the area was in exchange, land, and religion, with Catholics, Jesuits, and Protestants all needing to guarantee their own in this new land. Increasingly detailed governments and collusions were made to deal with the area with more noteworthy impact. With numerous nations competing for Canada at its new home, the British in the end made it another piece of its domain, with the French taking a littler segment in its overseeing and impact. Since 1848, mindful government was set up by the British, yet Britain despite everything had control over the locale until 1931, with the Statute of Westminster. It expressed that Canada had a similar position as the United Kingdom. With this affirmation, it took a few additional decades until Canada made its own Constitution, in 1982. In any case, with Canada presently being a parliamentary majority rule government and an established government, Queen Elizabeth II is still observed as the head of state (Nicholson, Norman L., and Roger D. Lobby).

Numerous subtleties couldn’t be expounded on in this little space, however I trust the movement of this extraordinary nation was clarified. Canada was first populated by socially, profoundly, strictly, and semantically advanced individuals, with 12 dialects and numerous clans. The Vikings were the principal Europeans to dare to the place where there is Canada however didn’t remain for long. Italian John Cabot, employed by Britain, investigated the area, and started an angling industry there. The French came before long, asserting area as their own in the territory of Quebec. After New France was established, British, Dutch, and different pilgrims for different nations battled for the exchange, land, and even religion of this new spot. Unions with the locals were made for exchange and religion, and wars began to be battled under the flag of exchange, religion, and land ownage. Be that as it may, after numerous overwhelming fights between the French and British, Canada in the long run went under the influence of the British Empire, and stayed so until the Canadian Constitution was patriated in 1982. From that point on, Canada shook off the shackles of reliance on Britain, and has remained for the most part monetarily and legislatively stable since.

Works Cited

Nicholson, Norman L., and Roger D. Lobby. “Canada.” Encyclopædia Britannica, Encyclopædia Britannica, Inc., 25 Dec. 2018, www.britannica.com/place/Canada/History.

 

 

 

This question has been answered.

Get Answer
WeCreativez WhatsApp Support
Our customer support team is here to answer your questions. Ask us anything!
👋 Hi, Welcome to Compliant Papers.