Answer:
In cell B6, formula =INDEX(INDIRECT($B$3),A6)
CallCenter Worksheet Details:
The image of the CallCenter Report worksheet for reference to the question asked is attached below.
Explanation:
Firtsly, an absolute reference in Excel refers to a reference that is "locked" so that rows and columns won't change when copied. To do this,we put a $ dollar sign ( =A$1,) before the row coordinate to lock only the row.
A relative reference in Excel is a cell address without the $ sign in the row and column coordinates example A1.
Having known what absolute and relative reference are, we wlil write the below formula in cell B6 that will later be copied to cell B9:
: =INDEX(INDIRECT($B$3),A6)
Answer:
B) contextual
Explanation:
Contextual advertising is a form of targeted advertising for advertisements appearing on websites or other media.
For example:
Timothy was reading tournament results of the football World Cup matches on Infogoalistic.com. As he was going through the results, an advertisement of new football studs popped up. This is an example of <u>contextual</u> advertising.
Answer:
Consistency
Explanation:
Bi integrating marketing communications, we can infer that the different brands working under Excel Enterprises have the same basic design, so the marketing department can sell their features easily, without having to create different campaigns or protocols for each individual product.
This homogeneous design then turns intuitive for the user, a textbook definition of consistent design, and the tone is maintained through the different brands.
Just like when you move from Microsoft's Excel to Microsoft's Word, you know the usage of each program is different, but the layout is the same, allowing you to understand the basics of the UX (user interface) of one, by understanding the other.