What role does HR play in fostering agility?

Encouraging continuous learning

studbud

Battle of Learning Teams Round 1

70 termsStudBud Administration18 plays

Test your knowledge on Excel analytics, functions, and features to enhance your data analysis skills

Flashcards70 cardsFPractice quizPHost liveL

Questions 70

Answers

1
What does USP stand for?
Unique Store Product
Unique Selling Product
Unique Selling Proposition
Unique Selling Price
2
What proves Electrowhip's decision wise?
competitors use social media
products support high prices
operates in competitive market
not price sensitive market
3
What creates a seamless cross-channel experience?
Point-of-purchase marketing
Social media marketing
Omni-channel retailing
Virtual marketing
4
Which marketing concept relates to employees?
Socially responsible marketing
Internal marketing
Relationship marketing
Integrated marketing
5
What percentage values hybrid work arrangements?
80%
77%
90%
61%
6
What role does HR play in fostering agility?
Ensuring rigid structures
Eliminating training programs
Reducing collaboration
Encouraging continuous learning
7
What pricing method seeks 10% profit margin?
Value
Markup
Perceived value
Target return
8
Which principle explains visual grouping in dashboards?
Proximity
Similarity
Closure
Continuity
9
What is a key feature of E-POSH module?
Manual complaint logging
Training only for managers
AI-powered analytics
Limited access to timelines
10
What percentage prefers mentorship programs?
65%
56%
81%
77%
11
What percentage of women find POSH Act effective?
86%
92%
87%
5%
12
What encourages brand switching?
reminder
covert
persuasive
informative
13
How does E-POSH protect victim identity?
Restricting filing to management
Notifying all employees
Public access to complaints
Hiding victim details
14
Which pricing approach offers low base product?
Product line pricing
By product pricing
Captive product pricing
Product bundle pricing
15
What is the NPV if interest cost is zero?
NPV will decrease
Cannot say
NPV will remain same
NPV will increase
16
What is the downside of salary advances?
Reduction in debt
Increased savings
Encouragement of overspending
Improved credit score
17
Which function merges customer names in Excel?
INDEX
SUMIFS
VLOOKUP
COUNTIFS
18
What do tech professionals consider indispensable?
Office perks
High salaries only
Career pathing and L&D
Unlimited paid leaves
19
Which function calculates weighted totals in Excel?
SUMPRODUCT
SUMIFS
VLOOKUP
COUNTIFS
20
Which process ensures dataset compatibility?
ETL
Pivoting
Dashboarding
Modeling
21
Which firm uses indirect channel?
Bank
Fast food chain
Manufacturer
Accounting firm
22
Which step links sales data with demographics?
Dataflows
DAX Formulas
Modeling
Visualization
23
Which chart compares quarterly sales across regions?
Bar Chart
Line Chart
Pie Chart
Scatter Plot
24
If ROE 20%, profit after tax Rs. 100 and number of outstanding shares 10 crores, then book value of a share is?
Rs. 50
Rs. 40
Rs. 100
Rs. 80
25
What is a key benefit of using HRIS?
Eliminates compliance need
Automates HR tasks
Increases paperwork
Reduces efficiency
26
What is the WACC with debt-equity ratio 1:3, cost of equity = 16% and post-tax cost of debt = 8%?
12%
10%
16%
14%
27
What retailers offer sales assistance?
Off-price retailers
Full-service retailers
Self-service retailers
Limited-service retailers
28
What is the value triad?
Price, Service, Quality
Service, Quality, Satisfaction
Quality, Loyalty, Service
Satisfaction, Loyalty, Price
29
What challenge exists when implementing HRIS?
Increased manual paperwork
Resistance to change
Reduced compliance need
Decreased efficiency
30
What is nonpersonal promotion by a sponsor?
sales promotion
advertising
direct marketing
personal selling
31
Which feature enables dashboard interactivity?
Bookmarks
DAX
Dataflows
Slicers
32
Which process standardizes raw sales data?
Pivot Tables
Dashboarding
ETL
Data Modeling
33
What is discriminating pricing based on?
Segment
Form
Time
Location
34
Which principle groups non-outlier data points?
Anomaly
Similarity
Closure
Proximity
35
What is a collection of Tyre Sellers?
Tyre Company
Tyre Industry
Tyre Competition
Tyre Market
36
Which data type shows monthly website traffic?
Nominal
Categorical
Continuous
Ordinal
37
Which feature summarizes monthly expenses in Excel?
Formatting
Pivot Tables
Data Validation
Conditional
38
What is an advertising objective?
inform
explain
remind
persuade
39
Which step addresses duplicates in datasets?
Visualization
Cleaning
Business Context
Data Model Building
40
Which HR function is least managed by HRIS?
Employee record management
Performance tracking
Personal counseling
Payroll processing
41
Which tool automates profit comparison in Excel?
Goal Seek
XLOOKUP
Trace Precedents
Data Tables
42
What is the effect of increased project risk?
NPV will remain same
NPV will increase
Cannot say
NPV will decrease
43
Which analytics type highlights historical patterns?
Diagnostic
Predictive
Prescriptive
Descriptive
44
What is high price intention for future?
market-skimming
cost-plus
market-segmentation
market-penetration
45
What are the 3 Cs in pricing?
Costs, Country, Customers
Company, Competitors, Customers
Costs, Competitors, Customers
Costs, Customers, Company
46
What is the top reason employees leave jobs?
Toxic work environment
Unsatisfactory pay
Lack of growth opportunities
Poor work-life balance
47
What percentage of women feel unsafe at work?
87%
3%
5%
92%
48
Which tool identifies monthly growth rate in Excel?
Pivot Charts
Goal Seek
Solver
Data Tables
49
What is the form of human needs?
Desire
Demands
Wants
Needs
50
What is selling pizza online and offline?
Zero channel distribution
Omni channel distribution
Direct distribution
Reverse flow distribution
51
What differentiates a brand?
Potential
Basic
Expected
Augmented
52
How can HR create a purpose-driven culture?
Avoiding engagement initiatives
Focusing on external hiring
Incorporating metrics into decisions
Enforcing hierarchy
53
What encourages employees to stay?
Work-life balance
Positive work environment
Career growth opportunities
Higher salaries
54
Which attribute highlights high-risk regions?
Color
Shape
Length
Position
55
What documents an organization's purpose?
vision statement
mission statement
value proposition
business portfolio
56
What did household debt increase to?
37.9%
41%
43.5%
30%
57
Which function combines criteria for total sales?
VLOOKUP
IF
COUNTIFS
SUMIFS
58
Which analytics branch forecasts delivery delays?
Descriptive
Prescriptive
Diagnostic
Predictive
59
Which concepts suffer from marketing myopia Product, Production and?
Demand
Societal
Selling
Customer
60
What percentage cited poor leadership for quitting?
32.4%
20.5%
27.7%
30.3%
61
What is a challenge of delaying onboarding?
Loss of trust
Immediate productivity improvement
Increased satisfaction
Higher retention rates
62
What is the price in buyer's mind?
Psychological pricing
Product form pricing
Reference pricing
Product line pricing
63
What does operating leverage analyze?
Credit Risk
Production Risk
Business Risk
Financing Risk
64
Which is not a place marketing mix element?
Channels
Packaging
Location
Assortments
65
Which tool resolves Excel crashing issues?
XLMiner
RealStat
Power BI
Tableau
66
When should market-skimming not be used?
competitors can undercut prices
quality supports price
competitors can enter
enough buyers want
67
How can HRIS enhance employee engagement?
Replacing face-to-face
Limiting access to info
Tracking performance
Manual tracking of hours
68
What is essential for effective manpower planning?
Aligning hiring with forecasts
Delaying onboarding indefinitely
Offering jobs without assessment
Hiring in bulk without evaluation
69
Which tool audits formula dependencies in Excel?
Trace Precedents
XLMiner
Data Validation
Goal Seek
70
If pay-out ratio 50%, equity dividend Rs. 100 crores and net sales Rs. 2000 crores, then net profit margin is ?
12%
8%
20%
10%

Battle of Learning Teams Round 1 Flashcards | StudBud

Battle of Learning Teams Round 1

70 termsStudBud Administration18 plays

Test your knowledge on Excel analytics, functions, and features to enhance your data analysis skills

Flashcards70 cardsFPractice quizPHost liveL

Questions 70

Answers

1
What does USP stand for?
Unique Store Product
Unique Selling Product
Unique Selling Proposition
Unique Selling Price
2
What proves Electrowhip's decision wise?
competitors use social media
products support high prices
operates in competitive market
not price sensitive market
3
What creates a seamless cross-channel experience?
Point-of-purchase marketing
Social media marketing
Omni-channel retailing
Virtual marketing
4
Which marketing concept relates to employees?
Socially responsible marketing
Internal marketing
Relationship marketing
Integrated marketing
5
What percentage values hybrid work arrangements?
80%
77%
90%
61%
6
What role does HR play in fostering agility?
Ensuring rigid structures
Eliminating training programs
Reducing collaboration
Encouraging continuous learning
7
What pricing method seeks 10% profit margin?
Value
Markup
Perceived value
Target return
8
Which principle explains visual grouping in dashboards?
Proximity
Similarity
Closure
Continuity
9
What is a key feature of E-POSH module?
Manual complaint logging
Training only for managers
AI-powered analytics
Limited access to timelines
10
What percentage prefers mentorship programs?
65%
56%
81%
77%
11
What percentage of women find POSH Act effective?
86%
92%
87%
5%
12
What encourages brand switching?
reminder
covert
persuasive
informative
13
How does E-POSH protect victim identity?
Restricting filing to management
Notifying all employees
Public access to complaints
Hiding victim details
14
Which pricing approach offers low base product?
Product line pricing
By product pricing
Captive product pricing
Product bundle pricing
15
What is the NPV if interest cost is zero?
NPV will decrease
Cannot say
NPV will remain same
NPV will increase
16
What is the downside of salary advances?
Reduction in debt
Increased savings
Encouragement of overspending
Improved credit score
17
Which function merges customer names in Excel?
INDEX
SUMIFS
VLOOKUP
COUNTIFS
18
What do tech professionals consider indispensable?
Office perks
High salaries only
Career pathing and L&D
Unlimited paid leaves
19
Which function calculates weighted totals in Excel?
SUMPRODUCT
SUMIFS
VLOOKUP
COUNTIFS
20
Which process ensures dataset compatibility?
ETL
Pivoting
Dashboarding
Modeling
21
Which firm uses indirect channel?
Bank
Fast food chain
Manufacturer
Accounting firm
22
Which step links sales data with demographics?
Dataflows
DAX Formulas
Modeling
Visualization
23
Which chart compares quarterly sales across regions?
Bar Chart
Line Chart
Pie Chart
Scatter Plot
24
If ROE 20%, profit after tax Rs. 100 and number of outstanding shares 10 crores, then book value of a share is?
Rs. 50
Rs. 40
Rs. 100
Rs. 80
25
What is a key benefit of using HRIS?
Eliminates compliance need
Automates HR tasks
Increases paperwork
Reduces efficiency
26
What is the WACC with debt-equity ratio 1:3, cost of equity = 16% and post-tax cost of debt = 8%?
12%
10%
16%
14%
27
What retailers offer sales assistance?
Off-price retailers
Full-service retailers
Self-service retailers
Limited-service retailers
28
What is the value triad?
Price, Service, Quality
Service, Quality, Satisfaction
Quality, Loyalty, Service
Satisfaction, Loyalty, Price
29
What challenge exists when implementing HRIS?
Increased manual paperwork
Resistance to change
Reduced compliance need
Decreased efficiency
30
What is nonpersonal promotion by a sponsor?
sales promotion
advertising
direct marketing
personal selling
31
Which feature enables dashboard interactivity?
Bookmarks
DAX
Dataflows
Slicers
32
Which process standardizes raw sales data?
Pivot Tables
Dashboarding
ETL
Data Modeling
33
What is discriminating pricing based on?
Segment
Form
Time
Location
34
Which principle groups non-outlier data points?
Anomaly
Similarity
Closure
Proximity
35
What is a collection of Tyre Sellers?
Tyre Company
Tyre Industry
Tyre Competition
Tyre Market
36
Which data type shows monthly website traffic?
Nominal
Categorical
Continuous
Ordinal
37
Which feature summarizes monthly expenses in Excel?
Formatting
Pivot Tables
Data Validation
Conditional
38
What is an advertising objective?
inform
explain
remind
persuade
39
Which step addresses duplicates in datasets?
Visualization
Cleaning
Business Context
Data Model Building
40
Which HR function is least managed by HRIS?
Employee record management
Performance tracking
Personal counseling
Payroll processing
41
Which tool automates profit comparison in Excel?
Goal Seek
XLOOKUP
Trace Precedents
Data Tables
42
What is the effect of increased project risk?
NPV will remain same
NPV will increase
Cannot say
NPV will decrease
43
Which analytics type highlights historical patterns?
Diagnostic
Predictive
Prescriptive
Descriptive
44
What is high price intention for future?
market-skimming
cost-plus
market-segmentation
market-penetration
45
What are the 3 Cs in pricing?
Costs, Country, Customers
Company, Competitors, Customers
Costs, Competitors, Customers
Costs, Customers, Company
46
What is the top reason employees leave jobs?
Toxic work environment
Unsatisfactory pay
Lack of growth opportunities
Poor work-life balance
47
What percentage of women feel unsafe at work?
87%
3%
5%
92%
48
Which tool identifies monthly growth rate in Excel?
Pivot Charts
Goal Seek
Solver
Data Tables
49
What is the form of human needs?
Desire
Demands
Wants
Needs
50
What is selling pizza online and offline?
Zero channel distribution
Omni channel distribution
Direct distribution
Reverse flow distribution
51
What differentiates a brand?
Potential
Basic
Expected
Augmented
52
How can HR create a purpose-driven culture?
Avoiding engagement initiatives
Focusing on external hiring
Incorporating metrics into decisions
Enforcing hierarchy
53
What encourages employees to stay?
Work-life balance
Positive work environment
Career growth opportunities
Higher salaries
54
Which attribute highlights high-risk regions?
Color
Shape
Length
Position
55
What documents an organization's purpose?
vision statement
mission statement
value proposition
business portfolio
56
What did household debt increase to?
37.9%
41%
43.5%
30%
57
Which function combines criteria for total sales?
VLOOKUP
IF
COUNTIFS
SUMIFS
58
Which analytics branch forecasts delivery delays?
Descriptive
Prescriptive
Diagnostic
Predictive
59
Which concepts suffer from marketing myopia Product, Production and?
Demand
Societal
Selling
Customer
60
What percentage cited poor leadership for quitting?
32.4%
20.5%
27.7%
30.3%
61
What is a challenge of delaying onboarding?
Loss of trust
Immediate productivity improvement
Increased satisfaction
Higher retention rates
62
What is the price in buyer's mind?
Psychological pricing
Product form pricing
Reference pricing
Product line pricing
63
What does operating leverage analyze?
Credit Risk
Production Risk
Business Risk
Financing Risk
64
Which is not a place marketing mix element?
Channels
Packaging
Location
Assortments
65
Which tool resolves Excel crashing issues?
XLMiner
RealStat
Power BI
Tableau
66
When should market-skimming not be used?
competitors can undercut prices
quality supports price
competitors can enter
enough buyers want
67
How can HRIS enhance employee engagement?
Replacing face-to-face
Limiting access to info
Tracking performance
Manual tracking of hours
68
What is essential for effective manpower planning?
Aligning hiring with forecasts
Delaying onboarding indefinitely
Offering jobs without assessment
Hiring in bulk without evaluation
69
Which tool audits formula dependencies in Excel?
Trace Precedents
XLMiner
Data Validation
Goal Seek
70
If pay-out ratio 50%, equity dividend Rs. 100 crores and net sales Rs. 2000 crores, then net profit margin is ?
12%
8%
20%
10%