Summary
Summary unit 42
- Institution
- PEARSON (PEARSON)
Summary of 13 pages for the course Unit 42 - Spreadsheet Modelling at PEARSON (unit 42)
[Show more]
Seller
Follow
Content preview
Solving complex42.4 - problems
Muhammad Hasa
FITFLOPPIES Qadri
J58828
, Manipulating Complex D
Data manipulation: Data manipulation is a process where you will change the data In a cell so that the data is mo
and readable for the viewer of the spread sheet. Fit floppies may use many ways to manipulate data as they are a
they will have many files that are unorganised and all over the place so they can use data manipulation tools to h
There are many examples of data manipulation tools such as the filter system which allows you to look at specific
many others outlined below.
Charts and graphs: charts and graphs can be used to manipulate a huge amount of data. The data must be relate
other in order for the graph to communicate with the reader successfully. This tool will compress the huge amoun
small more readable graph. It will use small keys such as colour and percentages to manipulate the data so the re
analyse it better. This will help fit floppies as they will not have to look through huge number of files to find specifi
could be used to find out the total amount of colours available for each shoe size.
VLOOKUP: VLOOKUP is the process that will require fit floppies to set up a table as the purpose of VLOOKUP is to s
specific order number. An order number is selected by fit floppies and through the VLOOKUP data manipulation to
number will show up with the colour, size, price and gender of the shoe. This is beneficial to fit floppies as it will s
to look through all the order numbers and find one specific order. As they are a business time is very valuable to
in business time is money.
IF statement: there are many forms of the IF statement that can be used but personally, I would say the most use
the one that was applied to the use of the discount. The IF statements manipulate data as it predicts future expen
floppies and “what if” situations. This is applied in the discount situation as the formula fit floppies used was word
floppies order quantity is greater than 200 then the discount will be applied. This is useful to fit floppies as it will s
time to calculate how much of a discount they will receive. It will also help them get through future complications
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller hasanqadri12003. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for £7.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
52355 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy revision notes and other study material for 14 years now