Question 5 (16 marks) a) Why are Pivot Tables are so widely used? b) Consider that...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Question 5 (16 marks) a) Why are Pivot Tables are so widely used? b) Consider that you have a spreadsheet containing the below information: c) EMPLOYEE-ID COUNTRY OF ORIGIN DEPT JOB TITLE JOB LEVEL QUALIFICATION MARITAL STATUS SALARY XQ LEVEL (4 marks) What are eight (8) appropriate report layouts that you can extract using Pivot Table. For each layout, you are required to show a draft of how the report look like. (8 marks) d) In a Pivot Table, besides showing all the fields, there are 4 quadrants. List out these quadrants and state briefly their purposes (4 marks) Question 5 (16 marks) a) Why are Pivot Tables are so widely used? b) Consider that you have a spreadsheet containing the below information: c) EMPLOYEE-ID COUNTRY OF ORIGIN DEPT JOB TITLE JOB LEVEL QUALIFICATION MARITAL STATUS SALARY XQ LEVEL (4 marks) What are eight (8) appropriate report layouts that you can extract using Pivot Table. For each layout, you are required to show a draft of how the report look like. (8 marks) d) In a Pivot Table, besides showing all the fields, there are 4 quadrants. List out these quadrants and state briefly their purposes (4 marks)
Expert Answer:
Answer rating: 100% (QA)
a Pivot Tables are widely used because it can simply summarize data for you depending on the kind of ... View the full answer
Related Book For
Accounting concepts and applications
ISBN: 978-0538745482
11th Edition
Authors: Albrecht Stice, Stice Swain
Posted Date:
Students also viewed these accounting questions
-
prepare a classified balance sheet for the month ending August On the 1st of August, Brothers haircut had these transactions during this month. On August 2, Paid $2200 cash for August salon rent. On...
-
Use the following information to prepare an income statement for Fairchild Corporation for the year ended December 31, 2012. You should show separate classifications for revenues, cost of goods sold,...
-
Use the following to prepare an income statement for Excel Technology, Inc., for the year ended June 30, 2011: Service revenues ...... $62,675 Rent expense ........ 12,000 Insurance expense ..........
-
using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using...
-
Saffron Enterprises Inc., a U.S.-based company, purchases a 4 percent bond denominated in euros for $1,500 on January 1, Year 1, when the exchange rate is $1.50 per euro. (In other words, the...
-
Match the following basic transaction analysis with the best description of the economic event. 1. Cash increased by $10,000 and the owner's equity account, D. Morris, Capital, is increased by...
-
Which of the following statements is correct? (a) \(C_{P}\) can never be less than \(C_{V}\) (b) \(C_{P}\) is always equal to \(C_{V}\) (c) \(C_{P}\) may be less than \(C_{V}\) (d) \(C_{P}\) may be...
-
Several years after reengineering its production process, Biltmore Corporation hired a new controller, Rachael Johnson. She developed an ABC system very similar to the one used by Biltmores chief...
-
You have recently become a divorced, single parent and moved to Kalamazoo, MI. You have 3 children (10, 6, 3). You were recently hired at Target- located on West Main working 11am-7pm Monday through...
-
John Chang operates a plumbing business as a proprietorship (John Chang Plumbing). The following events took place during the month of June 2022: Required Identify the accounting assumption,...
-
A certain substance decomposes according to a continuous exponential decay model. To begin an experiment, the initial amount of the substance is 4300 kg. After 11 hours, 3053 kg of the substance is...
-
lodine-131 has a half-life of 8.040 d. After 2 weeks, how much is left of a 550 g sample?
-
1 ezt 9. Show that 2 z 2 +1 dz = sint if t> 0 and C is the circle |2| = 3. eiz 10. Evaluate f dz where C is the circle || = 2. (5) (5)
-
Find the equilibrium points for the system x'= 10(y - x) y'= 28x - y-xz 8 z' = - -z+xy 3 One of the equilibrium points will have all positive coordinates. Those coordinates are: x= y = x =
-
B Ltd a US firm had exports to C Ltd a UK firm in year 2016 for 10M payable in 1 year. The interest and exchange rates applicable were as follows: US interest rates 6.1% UK interest rates 9.0% Spot...
-
You long 10 ATM straddle Ie 10 call and 10 put both at strike of 100. What is the delta and gamma value of the position?
-
Using quantitative research findings on culture, deviant workplace behavior, motivation, and politics, how would you apply these independent and dependent variables to the organization that is least...
-
Presented below are income statements prepared on a LIFO and FIFO basis for Kenseth Company, which started operations on January 1, 2024. The company presently uses the LIFO method of pricing its...
-
Iron Company incurred the following transactions relating to the common stock of Bronze Company: July 14, 2010 Purchased 10,000 shares at $35 per share. Sept. 4, 2011 Sold 2,500 shares at $40 per...
-
When is a company legally barred from paying cash dividends?
-
Yoshika Landscaping is contemplating purchasing a new ditch-digging machine that promises savings of $5,600 per year for 10 years. The machine costs $21,970, and no salvage value is expected. The...
-
You are the senior partner of a large, local audit firm. In reviewing the work of a junior staff member on a compilation engagement for Greasemonkey's Delight Inc., a local autoparts store (in which...
-
The chapter discussed three issues to consider when obtaining evidence using a sample-based audit procedure: a. The number of transactions or items to examine b. The actual transactions or items to...
-
Compare and contrast statistical and non-statistical (judgmental) sampling. Include in your discussion conditions that might make one approach to sampling more desirable than the other.
Study smarter with the SolutionInn App