WorksheetsMega Quiz - Data Based Decision Making
Total questions: 26
Worksheet time: 30mins
A universe consists of 1000 individuals, out of which half are male. Target audience for your channel is male. In a particular week, your channel is watched by 100 male & 50 female audience. What is the reach of your channel in this week?
10%
30%
20%
15%
The second match of India England T20 series was watched by 19.7 million households across India. What is the all India Household reach for this match?
10%
20%
30%
2.5%
How is the individual reach of a program calculated?
Sum of all individuals watching for at least 1 second
Sum of all individuals watching for at least 10 seconds
Sum of all individuals watching for at least 5 Minutes
Sum of all individuals watching for at least 1 Minute
A program of 1 hour had a rating of 10 and a reach of 20%. What is the TSV (Time Spent by Viewer)?
20 Minutes
30 Minutes
40 Minutes
15 Minutes
How do you calculate GRP of a channel for a week?
Add impressions of all programs broadcast in the week over half hour slots
Add TVR/Rating of all programs broadcast in the week over half hour slots
Add impressions of all programs broadcast in the week over one hour slots
Add TVR/Rating of all programs broadcast in the week over one hour slots
The universe consists of 1000 people. India Vs England T20 International aired for 3 hours. 200 people watched it for 2 hour. 200 people watched it for one hour. And hundred people people watched it for 30 minutes. What is the TSV & TSU?
TSV - 1.3 Hours, TSU - 0.65 Hours
TSV - 0.65 Hours, TSU - 1.3 Hours
TSV - 0.65 Hours, TSU - 0.32 Hours
TSV - 1.3 Hours, TSU - 1.3 Hours
A TV channel has GRP of 168 for a week. What is the average TVR for the channel?
1
2
0.5
4
Which of these Vlookup functions is searching for an exact match?
=VLOOKUP (False, A2:B6, 2, C16)
= VLOOKUP (C16, A2:B6, 2 , TRUE)
=VLOOKUP (C16, A2:B6, 2, FALSE)
=VLOOKUP (C16, A2:B6,1, 1)
In the image, Vlookup function is returning an error against Aaj Tak but is working for rest of the entries. How do you fix the error?
(Click on the image to Zoom)
Use Trim function
Freeze B6 Cell
Change approximate match to exact match
The error can not be fixed by changing formula
Which function is used to highlight cells in the enclosed image?
(Click on the image to zoom)
Conditional formatting cells >15,000
Conditional Formatting duplicate cells
Filtering cells > 15,000
Filtering duplicate cells
In the enclosed image, channels of various languages are listed in rows. How do you find out ratings of all Hindi language channels.
(Click on the image to zoom)
Put channel language in columns and Rat% in rows
Put channel language in filter and Rat% in values
Put channel language in filter and Rat% in columns
Put channel language in rows and Rat% in columns
Which key should you press in excel to find all shortcuts?
ALT
CTRL
TAB
SHIFT
What is the function of the Subtotal command?
Can be used to add up values in Pivot Table
Can be used to sum and average the values in a filtered table
Can be used to multiply two different tables
Can be used to sort and filter data
The LCO collects Rs 300 from the ground for a pack. Out of this the LCO pays Rs 120 to the DPO. In turn, DPO pays Rs 60 to the broadcasters. What is the gross margin of the DPO?
180
60
120
240
DPO has published a price of Rs 300 for his pack. However, LCO sells the pack for Rs 320. The LCO pays the DPO Rs 150 as link charges. The DPO in turn pays Rs 60 as content charges. What is the Gross Margin of the LCO?
170
90
150
210
A DPO sells only one pack of Rs 300 to its direct points. Current Content cost of the pack is Rs 120. The broadcasters have increased their rates and the content cost will now increase to Rs 150 for the same content. DPO has two options.
Option 1 - Keep the price same at Rs 300 and retain all customers
Option 2 - Increase price to Rs 350 and lose 10% customers
What should the DPO do to increase Gross Margin?
DPO is indifferent between the two options as Total Gross Margin is same in both cases
Select Option 1
Select Option 2
There is not enough information
What are the practical applications of Gross Margin in distribution?
Creating a business case for the DPO
Understanding profitability of each DPO pack
Estimating potential marketing arrangements
All of the above
A company has an EBITDA of Rs 100 Crore and Finance charges of Rs 150 Crore. What can you interpret about the health of the company?
(ISR = Interest Service Ratio)
The ISR < 1; the company is in financial difficulties
The ISR > 1; the company is generating enough funds to meet liabilities
EBITDA is very high, company is very profitable
EBITDA>0, the company has no financial difficulties
The DPO collected Rs 2 Cr and paid out Rs 1.5 Cr in costs. At the same time, DPO booked sales of Rs 1.8 Cr and booked expenses of 1.6 Cr. What is the operating cashflow of the DPO?
Rs 50 Lakh
Rs 30 Lakh
Rs 20 Lakh
Rs 10 Lakh
How can we use Price Piano to help our pricing and packaging decisions?
Find the "Hot" or "most selling" price points in the market
To enable customers to move to higher price points
To find penetration of competitor offerings
To calculate gross margin of the products
What is the use of Price Ladder?
Enables upselling by offering customers path to higher price points
To find most selling price points in the market
To find penetration of competitor offerings
To calculate gross margin of the products
A DPO has 1000 subscribers and collects link charge of Rs 150 per subscriber. The content cost is Rs 80 per subscriber. The LCOs are asking for a reduction in the Link charges by Rs 10 due to competitive pressure. If the DPO does not agree to the reduction in link charges, it will loose 180 subscribers. If the DPO agrees to the reduction, it will maintain the subscriber base. What should the DPO do to maximize gross margin?
DPO is indifferent between the two options as Total Gross Margin is same in both cases
Reduce the link charge to 140
Maintain link charge at 150
There is not enough information
Which method will you use to analyze operating expenses such as HR costs, Admin & selling costs etc. ?
Create Common Size P&L and compare with similar companies
Evaluate gross margin
Calculate the total profits of the company
Calculate the interest service ratio
A DPO has operating income of Rs 500 Cr. The content cost is Rs 300 Cr and all other operating costs are Rs 150 Cr. The interest charges are Rs 50 Cr and depreciation is Rs 25 Cr. What is the interest service ratio.
1.0
0.5
4.0
2.0
Kanwal is working on a spreadsheet of all his accounts. He only wants to view the accounts that have >75% bouquet penetration. What command should he use to complete this task?
AutoFill
Filter
Find and Replace
Sort
What is the period (start and end day) of BARC week?
Friday to Thursday
Sunday to Saturday
Monday to Sunday
Saturday to Friday
