Lesson 5 – Excel & Data Tables

Intro:A fruit company wants your help with the orders. What you will learn: Primarily Excel Data Tables Secondarily: Condition in an If Variables Client name:Green Fruit Process Name:Fruit Orders Description:Green Fruit wants to have a robot, that automatically can calculate orders: Read the Excel sheet Calculate the Totals column (that is quantity multiplied with price) […]

Intro:
A fruit company wants your help with the orders.

What you will learn:

  • Primarily
    • Excel
    • Data Tables
  • Secondarily:
    • Condition in an If
    • Variables

Client name:
Green Fruit

Process Name:
Fruit Orders

Description:
Green Fruit wants to have a robot, that automatically can calculate orders:

  • Read the Excel sheet
  • Calculate the Totals column (that is quantity multiplied with price)
  • Place a “Yes” in the “Big Order” column, if the Total is bigger than 10