Page 419 - Computer Software Application TP - Volume 1

COMPUTER SOFTWARE APPLICATION - CITS

• You are analyzing the performance of different marketing campaigns and want to calculate the conversion rate
for each campaign based on the number of leads generated and the number of conversions. Create an Excel
spreadsheet with the following details:

• Column A: Campaign names.
• Column B: Number of leads generated by each campaign.
• Column C: Number of conversions from leads for each campaign.
• Row 1: Use an array formula to calculate the conversion rate for each campaign by dividing the number
of conversions by the number of leads generated. Ensure that the array formula adjusts correctly for each
campaign as you copy it across.
• You are managing a restaurant and want to analyze the popularity of different menu items. Create an Excel
spreadsheet with the following details:
• Column A: Menu item names.
• Columns B through G: Weekly sales figures for each menu item for the past six weeks (varying values).
• Row 1: Use an array formula to calculate the total sales for each menu item by summing the sales figures
across all weeks. Ensure that the array formula adjusts correctly for each menu item as you copy it across.

404
CITS : IT & ITES - Computer Software Application - Exercise 68