Chapter 08 – Business Across the Enterprise
8-8
c. Find a Lotus Notes/Domino product review on the Web, read it, and report your findings to the
class. Your presentation should answer the following questions: Who provided the review? What
is the reviewer’s relationship to the product? What did the reviewer like? What did the reviewer
dislike? What competitors were mentioned in the review? How did Lotus Notes/Domino
compare?
Students should discover that Lotus Notes/Domino systems are built on a proprietary, cross platform
3. Enterprise Sales Support
Note: The first three questions in this exercise can be answered independently from each other. Each
question focuses on a separate set of skills: Formatting, functions, logic operations, and pivot tables.
a. Pending sales need Christina’s immediate attention. Help her spot these opportunities by
automatically highlighting them. Select the “Sales Leads” spreadsheet and use Excel’s
Conditional Formatting feature to set the cell shading color of each Status cell (Life, Auto, Home,
Health) to green if the status is “Sale” (S) and red if the status is “Pending” (P).
See Data Solutions Disk for the completed exercise. This task illustrates how dynamic formatting
b. Select the “Cover Sheet” spreadsheet. In cell C2, use the COUNTA function to count the total
number of sales leads in the Sales Leads sheet. In cells C5 through C8, use the COUNTIF
function to count the number of sales made for each type of insurance. In cells D5 through D8,
divide the sales made by the number of leads to calculate the percentage of sales. Write these
formulas so they calculate the correct answers even when Christina later adds more records to
the list. Which product has the highest sales rate?
See Data Solutions Disk for the completed exercise. This task exposes students to cross-sheet
c. When rating the quality of her information, Christina counts whether or not a lead resulted in at
least one sale. Using the IF and the OR functions, write a formula that will display “1” when at
least one sale was made to a lead and “0” if the lead generated no sales.
See Data Solutions Disk for the completed exercise. Excel logic functions can produce extremely