Question

2. Why is the diagonal and the area below the diagonal in the two-way table grayed out?

3. How do these modifications relate to the efficiency of the data extraction and storage?
4. What information is easier to extract from the two-way table than the raw extracted receipt data?
5. What information is lost or obscured when looking only at the two-way table?
E) Document anything significant that you find. Consider the following questions as you do this:

Answer 1

according to everything I've found this is all that's showing

Answer: HLookup

Step-by-step explanation:

HLookup is a function in Microsoft Excel that is part of the Lookup functions, that is, it is used to lookup a value from another table or cell so that it reflects in the desired table.

The “H” in the HLookup stands for Horizontal, that is Horizontal Lookup.

The HLookup function works by looking for a value in the top row of a table or array of values and returning the value in the same column from a row that is specified.

The function is;

=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])

So, to extract our shipping value from the lookup table, we use the formula;

=HLOOKUP(C2,$B$11:$E$12,2)