User Account

All Pages

Discuss and compare the data consolidation

Assignment Help Basic Computer Science
Reference no: EM13818849

Discuss and compare the data consolidation and What-If analysis Excel tools. Under what circumstances would you use each of these tools? Do they both serve the same purpose, or is each one used under different scenarios? Give examples of how each can be used.

Comment about para below:

Data consolidation is when you whant to summarize a large amount of data into a worksheet. What-if is the process when you change the values to see how they affect the formulas that are in the worksheet.

They do serve a purpose and this is to help data stay organized and to see what affects they can have on data. An example of data consolidation would be summarizing data in excel and for the what if it would be scenarios where you would want to see how much you would make in 20 years if you make the Same amount an hour and then change what you make an hour.

Comment about para below:

Consolidation in Excel is a great feature than can be used to summarize data or values from multiple worksheets that contain related data or values. With this feature, users can find it very easy to combine all related data for several users or items. Let say for instance we have a sheet that entails various customers who make purchases during the week and among them there are two customers who basically make 5 purchase on separate days during the week, for example. Repeating the same name and purchase made for a specific customer might be a burden or confusing to read at times.

To erase that, the consolidating feature can be used to calculate the total purchase of that specific customer over the week instead of repeating the same name in the worksheet. With that users will find it pretty much easy to understand their sales over the week for various customers.

On the other hand, the what-if analysis feature is basically the process in which variables can be modified or changed in order to notice or observe how it can affect calculated results or an outcome of particular something. Verily, most big companies and businesses use this feature to make assumptions about future trend and profit making in order to observe and compare how a particular change may affect a related outcome. Comparing the two features, I will personally say that they serve similitude characteristics but aren't the same, neither do they perform the same function.

Thus I will say each of them is used under different scenarios.

Reference no: EM13818849

Questions Cloud

Operating segments comprise alcoa business : Based on the data presented, what operating segments comprise Alcoa's business? Based on the reconciliation of ATOI to Net Income, what can you say about the quality of Alcoa's income? Be specific in your answer.
Describe the legality of security work : Choose either public or private security and write a paper on the elements of negligent liability and the legal issues associated with the performance of security work
Determine the demographic profile of your typical consumer : Determine the demographic profile of your typical consumer. Determine the psychographic profile of your typical consumer. Determine if the typical consumer is your ideal consumer. Why or why not
Write a research argument essay about media violence : Write a Research argument essay about Media violence and its effects on children.
Discuss and compare the data consolidation : Discuss and compare the data consolidation
Explain how these moving averages can assist a stock analyst : How do the moving averages for the same values of m compare between a trend-moving average and a centered-moving average?
How law you researched influences compensation strategies : Use the Internet to determine how the law you researched influences compensation strategies for all companies directly affected by the law in your state.
Impact of cyclone marcia on the equilibrium price : Explain how market equilibrium price and quantity for macadamias are determined and impact of Cyclone Marcia on the equilibrium price and quantity in the market
What variables might explain or predict an outcome : What variables might explain or predict an outcome in your department or life. If you generated a regression equation, how would you interpret it and the residuals from it

Reviews

Write a Review

Basic Computer Science Questions & Answers

  Ethical concerns in computing

Please select from one of the following topics, which are addressed in the course textbook, Introduction to Computer Literacy: Collaborative Technologies, Ethical Concerns in Computing

  Program that allows a user to enter 10 item stock

Write a program that allows a user to enter 10 item stock numbers, prices, quantities in stock into three parallel arrays. Display all the data in report form - that is, aligned correctly in columns.

  What is qos what is it used for and how does it work

What is QOS what is it used for and how does it work and What are the differences between Inserv and Diffserv

  Prove true a similar statement for octal representation

suppose a 4n-bit number B is represented by an n-digit hexadecimal number H. Prove that the two's complement of B is represented by the 16's complement of H. Make and prove true a similar statement for octal representation.

  Imagine you are an entrepreneur starting a new business

1. assess the challenges e-business and e-commerce technologies present to the field of information technology.

  network structure-Management Information system

Which of the following is true of a network structure? The Management Information system (MIS) structure with one main computer system is called a

  Designing unique game world

Answer the questions listed below under Part A - save your answers into a Word document for submission along with remainder of your assignment. Design your own unique game world, which must exhibit the following characteristics:

  Compute net present value and return on investment

Compute net present value (NPV) and return on investment (ROI) and present break-even analysis (BEA). Suppose discount rate of 12 percent and five-year time horizon.

  Explaining visible and consistent management support

Illustrate visible and consistent management support. Establish privacy responsibilities. Privacy needs need to be incorporated into any position which handles personally identifiable information (PII).

  Write a loop that subtracts one from the class

1- Write a loop that subtracts one from the Class Dog's energy for every 30 steps that the Dog takes. 2- Make the player-controlled Class Dog move more slowly whenever the method isTired returns a value of true.

  Variables-constants and data types

Document the steps for the logic structure to capture the payment information. This can be done as either a flowchart or pseudocode. Be sure to include inputs, variable declarations and assignments, and outputs.

  Eu directive on the protection of personal data

How does the EU directive on the protection of personal data impose requirements on organizations in non-EU countries?"

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd