100% satisfaction guarantee Immediately available after payment Both online and in PDF No strings attached
logo-home
(DISTINCTION) BTEC IT Unit 5 Data Modelling Assignment 1 - Task 4 -Evaluate the features of spreadsheet software (5/A.D1) $8.64   Add to cart

Essay

(DISTINCTION) BTEC IT Unit 5 Data Modelling Assignment 1 - Task 4 -Evaluate the features of spreadsheet software (5/A.D1)

1 review
 29 views  0 purchase
  • Course
  • Institution

This assignment received Distinction for covering 5/A.D1: Evaluated how the features of spreadsheet software contribute to the decision-making process- - Unit 3 Data Modelling Assignment 1 (Task4)

Preview 2 out of 15  pages

  • May 5, 2024
  • 15
  • 2022/2023
  • Essay
  • Unknown
  • A+

1  review

review-writer-avatar

By: tomurwin • 1 week ago

avatar-seller
Name: ID: Unit 5: Data Modelling



Evaluate how the features of spreadsheet software contribute to the decision-making
process.




Introduction: This following assignment is a report where I will generally evaluate the usage
of crucial functions used in Microsoft Excel, describing the functions used in and why the
user or data analyst uses the function, explaining how to use these functions and affirming
their advantages and disadvantages (2 for each). While stating whether and these functions
would be helpful to the cheese company, how and why these would these tools be
considered.
The functions that are going be mentioned are: VLOOKUP, Data Table, Goal Seek, Data
Validation, Range Name, Macro, Trend Analysis, IF Functions, SUM IF and COUNT IF. These
functions are commonly used and found in Excel along with other tools, and how are they
are going to be useful and if they should be considered by the cheese company.

, Name: ID: Unit 5: Data Modelling



VLOOKUP:

As VLOOKUP stands “Vertical Lookup”. Its role as an implement is 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.
VLOOKUP is used as an important tool in MS Excel in order to search, analyse and find
specific things by row in either a range or a table, for example in this scenario: finding the
employee’s name by their employee ID in the cheese company. Furthermore, VLOOKUP can
easily extract and lookup data rather than an individual having to looking up a piece of
information manually.
One of its benefits is that it deals perfectly with time management and saves it, instead of a
person specifically a data analyst in this scenario having to do it manually especially if the
data in the tables is long and more complex, using VLOOKUP will immediately extract the
data needed in a short time. Another benefit is that it can categorise data in the
correspondent table, this will deal with the spreadsheet especially if it too complex.
Moreover, the data records in the tables and rows will be readable and comprehensible to
lookup for.
However, the drawbacks of using VLOOKUP is that it only looks at the columns to the right
side, this would be a massive limitation if the most major and crucial data and values are
located in the columns at the left side. Another limitation is that VLOOKUP will give incorrect
results if a user inserts any column in the lookup table as the column is hard coded in the
formula, this would a problem if a data is inserted in a blank column.
Overall, I would consider using VLOOKUP as it will save time instead of just looking for a
data over time, this would help especially if there many tables in which the values are
needed to extract. It also will help with more complex matches in the cheese company.




VLOOKUP function has used all the
values from the “ID” and “Company”
columns from the chosen lookup value
which is “HP” in order to look for it.

The benefits of buying summaries with Stuvia:

Guaranteed quality through customer reviews

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

Quick and easy check-out

You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.

Focus on what matters

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 lydii. Stuvia facilitates payment to the seller.

Will I be stuck with a subscription?

No, you only buy these notes for $8.64. You're not tied to anything after your purchase.

Can Stuvia be trusted?

4.6 stars on Google & Trustpilot (+1000 reviews)

83662 documents were sold in the last 30 days

Founded in 2010, the go-to place to buy study notes for 14 years now

Start selling
$8.64
  • (1)
  Add to cart