Solving complex
42.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
42.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
