This assignment received Distinction for covering 5/A.M2: Analysed how the features of spreadsheet software contribute to the decision-making process. - Unit 3 Data Modelling Assignment 1 (Task3).
Analysing how the features of spreadsheet software contribute to the decision-
making process.
Graphs and Charts:
Graphs are where the worksheet's data is represented visually through graphs, meanwhile
charts represent patterns that contain information about the data in the table.
To create a Graph in Excel, the user must select the data needed for the chart to be created,
selecting on “INSERT” menu and then on “Recommended Charts”, the user will be able to
choose any chart that is recommended by Excel, the user can also add chart elements such
data labels and giving titles to axis, and displaying the data in the chart by selecting either
“Chart Elements”, “Chart Styles” or “Chart Filters” and decorating or customising the chart.
Another factor to consider is using “TOOLS” to add additional design and arranging
possibilities.
The benefits of using graphs and charts in Excel is that the data analyst can easily
understand and see through the trends and patterns of the cheese sales over the weeks,
months, year and even the last decade, and its relationship and comparison with total
number of cheeses, its types, exported from the both Netherlands and France, this helps the
company to set goals for the sales of cheese in the near future by using the prediction
option.
, Unit 5: Data Modelling
Data Validation:
Data validation is a feature in which it controls what the users can enter in a cell.
By making rules, when the user enters a data that violates the rule, it will display a message
informing that the user has entered an invalid data.
Creating a Validation rule is achieved by selecting the cells needed to validate, using “Data”
tab and “Data Validation” , this feature will allow the user to select any value wanted to
allow, whether a whole number, list, date and time, text length and even “any value” which
does not apply validation criteria, then the user will specify data validation rules ( note that
the validation options depend on the option selected). When a user tries to enter data that
will violate the validation rule, Excel will inform the user that the data entered in invalid by
displaying a message about the cell restricted. The user is also allowed to add input and type
in a message to inform other people when entering data in the worksheet.
By using Data Validation, the
cheese company will ensure that the data entered is accurate and valid with cleanness, so
that it can make accurate predictions of the sales of the cheese, exchange currency…etc,
from the table without errors that are subject to inaccurate data. This will ensure that the
data is not corrupted from eliminating data errors, in which it will create better results.
Voordelen van het kopen van samenvattingen bij Stuvia op een rij:
Verzekerd van kwaliteit door reviews
Stuvia-klanten hebben meer dan 700.000 samenvattingen beoordeeld. Zo weet je zeker dat je de beste documenten koopt!
Snel en makkelijk kopen
Je betaalt supersnel en eenmalig met iDeal, creditcard of Stuvia-tegoed voor de samenvatting. Zonder lidmaatschap.
Focus op de essentie
Samenvattingen worden geschreven voor en door anderen. Daarom zijn de samenvattingen altijd betrouwbaar en actueel. Zo kom je snel tot de kern!
Veelgestelde vragen
Wat krijg ik als ik dit document koop?
Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.
Tevredenheidsgarantie: hoe werkt dat?
Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.
Van wie koop ik deze samenvatting?
Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper lydii. Stuvia faciliteert de betaling aan de verkoper.
Zit ik meteen vast aan een abonnement?
Nee, je koopt alleen deze samenvatting voor €7,45. Je zit daarna nergens aan vast.