What does the "range_lookup" parameter in the VLOOKUP function control?
The range of data in which the Vertical look-up function should operate on.
The search direction (up or down) for the lookup value.
Whether the function should perform a case-sensitive lookup.
Whether the function should perform an approximate or exact match lookup.
With the following data, determine which SKU has the minimum Average Days of Inventory.
| Stock Keeping Unit | Open Stock in Warehouse | Avg Daily Sales |
|---|---|---|
| A01 | 18.7 | 8.5 |
| A02 | 31.2 | 6.3 |
| A03 | 15.9 | 3.7 |
| A04 | 12.4 | 2.9 |
A01
A02
A03
A04
Calculate the Overall Equipment Effectiveness (OEE) of the Assembly Line Equipment for the month of July.
Parameters:
| Planned Production Hours (PPH): | 400 |
|---|---|
| Lost Time (LOT): | 30 |
| Designed Assembly Speed from Equipment (DA) per Hour: | 180 |
| Actual Assembly Speed from Equipment (AA) per Hour: | 160 |
| Total Units Assembled (TU): | 8000 |
| Defective Units (DU): | 320 |
Round the OEE to two decimal places
Sign in with Google — it is free — to see every question with its answer and explanation, practise it in learning mode, or take it as a timed mock test.
The IIT Madras BS Business Data Management (BDM) End Term paper sat on 3 Sept 2023, in the May 2023 term, set QPD1-S1: 17 questions for 40 marks in 180 minutes. The first 3 questions are below. Sign in with Google — it is free — to see the whole paper with its answers and explanations, in learning mode or as a timed mock test.
| Feature | BDM End Term 3 Sept 2023 Set QPD1-S1 at a glance |
|---|---|
| Term | May 2023 term |
| Subject | Business Data Management |
| Course code | BSMS2001 |
| Questions | 17 |
| Marks | 40 |
| Duration | 180 min |
| MCQ | 12 |
| Numerical | 3 |
| MSQ | 1 |
| Written | 1 |
| Official paper | IIT M DIPLOMA ET1 EXAM QPD1 S2 03 Sep |
| Negative marking | No negative marking. |
| Updated |
