1. 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

.

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

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.

for each sales area. A reference table (rows 11

and 12) lists the

.

To automate the calculation, the sales manager wants Excel to fetch the correct

delivery cost for each transaction based on the

. To

achieve this, the manager enters a formula in

and then

auto-fills it down to