(PASS CRITERIA) BTEC IT Unit 5 Data Modelling Assignment 1 - Task 2 - spreadsheet software features to aid decision-making process (5/A.P2) (Powerpoint)

Spreadsheet Model features
How the features of spreadsheet software are used to support the decision-making
process

, VLOOKUP

 A VLOOKUP or “Vertical Lookup” is an implement for
looking up a piece of information in a data or table set
and withdrawing some related information or data. It
displays the data from the already existing table that
includes the information.
 A benefit of VLOOKUP for the cheese company is that the
data analyst can rapidly find the correspondent data,
which makes less to not complicated.
 It looks up data automatically rather than an individual to
do it manually.

, MACRO

 Also used in MS Access, a Macro in Excel
is a rule or action that automates tasks
with particular instructions.
 Macro is useful for complex, tedious or
repetitive processes.
 The pros of Macro for the cheese company
is that it automatically performs the tasks
for the data analyst, in which it helps with
time management and saves it .
 By using Macro, the data analyst will be
informed in case of any error or mistake
for the types of cheeses and the prices in
the tables.