Матеріали курсу MC 2025 ISTN103 - Development and Application Fundamentals P/W 2 та відповіді на тести | learn2025.ukzn.ac.za

5. A retail company is analysing its sales data using Excel. A sample of the sales data is shown in the screenshot below. The sales manager wants to automatically calculate the discount percentage for each transaction based on the quantity of items sold. The discount rules are stored in a lookup table (columns H and I), where different quantity ranges correspond to different discount percentages. To achieve this, the manager enters a formula in cell D2 that looks up the quantity sold in column B against the discount table in columns H and I, and then auto-fills the formula down to D8.

The retail company also tracks delivery costs for each sales area. A reference table (rows 11 and 12) lists the areas and their corresponding delivery costs. To automate the calculation, the sales manager wants Excel to fetch the correct delivery cost for each transaction based on the area in column A. To achieve this, the manager enters a formula in cell E2 and then auto-fills it down to cell E8.

BAQuestion1

What would be displayed in cell G9 if the manager entered the formula =VLOOKUP(B3; $H$2:$I$8; 0; TRUE)?

Переглянути це питання

Crowdly

MC 2025 ISTN103 - Development and Application Fundamentals P/W 2

Хочете миттєвий доступ до всіх перевірених відповідей на learn2025.ukzn.ac.za?