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...
-
Refer to the quote in the previous exercise, about marijuana and cocaine use in 1980 and 1993. a. What was the relative risk of cocaine use for college students in 1980 compared with college students...
-
Lagrange's equations, when applied to a MDOF linear system, always leads to symmetric mass, stiffness, and damping matrices. Indicate whether the statement presented is true or false. If true, state...
-
The November cash records of Stenback, Inc., follow: Stenbacks Cash account shows the balance of $6,172 on November 30. On November 30, Stenback received the following bank statement: Additional data...
-
The Village of Seaside Pines prepared the following enterprise fund Trial Balance as of December 31, 2017, the last day of its fiscal year. The enterprise fund was established this year through a...
-
At the end of this month, Leslie will start saving $200 a month for retirement through his company's superannuation plan. His employer will contribute an additional $0.50 for every $1.00 that he...
-
Brentwood Bay Inc.s comparative balance sheet at September 30, 2020, and its 2020 income statement are shown below: Other information for the year ended September 30, 2020: a. Acquired equipment by...
-
Q.1 Consider a smooth inclined plane that is making an angle of 60 with the horizontal axis. An object of mass 11 kg is supported on this plane with a force F making an angle of 30 degree with the...
-
Ali is a forty-year-old man. He was insured under a health insurance policy since March 2023. Last month he was urgently operated on unsuccessfully. Upon further investigations, the insurance company...
-
How much does a 25 kg concrete block weigh under water? (The density of concrete is 2300 kg/m)
-
On 31/12/23 XYZ Corp is involved in a LEGAL CASE Involving air pollution. In the event that XYZ corp is found to be liable, damages have to be paid. At the moment, XYZ Corp does not recognize a...
-
Lisa (25 years old) studied music education in college and graduated a year ago. She currently works as a music teacher at a year-round private middle school. Her gross pay is $33,000 a year, or...
-
If your organization has a contribution rate of 45% and knows the break-even point is $202,500, what are your organization's total fixed costs
-
Scofield Company's budget for the coming year includes the following: Direct material $675,000 Indirect material 337,500 Direct labor (@ $17 per hour) 1,125,000 Indirect labor 132,750 Factory...
-
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...
-
Derive the equation of motion and natural frequency for a mass \(m\) on the string that is under constant tension \(T\) as shown in Figure 2.44. Assume small displacements and that \(m\) is much...
-
Continuing Problem 13, the string is stretched to the position shown in Figure 2.45. Calculate the natural frequency of the system using the following parameter values: \(m g=2 \mathrm{lb}, T=50...
-
Derive the equation of motion for a uniform stiff rod restrained from vertical motion by a torsional spring of stiffness \(K\) and two translational springs each of stiffness \(k\), as shown in...
Study smarter with the SolutionInn App