Find It Out

In Excel, what does the shortcut Ctrl + 9 primarily do?

• Hide selected columns, akin to Virat Kohli's ability to shield the wicket with precision.

• Hide selected rows, similar to Rohit Sharma's strategic approach in creating gaps.

• Unhide hidden rows, revealing insights like KL Rahul's adaptability in different formats.

• Unhide hidden columns, exposing key strategies like those used by Indian captains.

Answer explanation

Hide selected rows, similar to Rohit Sharma's strategic approach in creating gaps.

Which action does Ctrl + 0 perform in Excel?

• Hide selected rows, similar to Jasprit Bumrah's ability to conceal runs under pressure.

• Hide selected columns, akin to Ravichandran Ashwin's knack for creating uncertainty.

• Unhide hidden rows, revealing pivotal data points akin to Bhuvneshwar Kumar's precision.

• Unhide hidden columns, exposing critical information like those managed by Indian all-rounders.

Answer explanation

Ctrl + 0 in Excel hides selected columns, similar to Ravichandran Ashwin's knack for creating uncertainty.

What is the function of Ctrl + Shift + & in Excel?

• Apply outline border to selected cells, defining boundaries akin to Hardik Pandya's all-around skills.

• Hide selected rows, akin to Ravindra Jadeja's ability to contain and restrict.

• Remove the outline border from selected cells, clearing restrictions similar to Rishabh Pant's fearless approach.

• Unhide hidden rows, revealing strategic insights akin to Wriddhiman Saha's reliability.

Answer explanation

Apply outline border to selected cells, defining boundaries akin to Hardik Pandya's all-around skills.

Using the shortcut Alt + W + I in Excel, what action does it perform?

• Enter Page Break Preview view, planning strategies similar to Virat Kohli's leadership in setting goals.

• Insert a new worksheet, preparing fresh insights similar to Rohit Sharma's tactical planning.

• Enter Data Validation settings, ensuring accuracy akin to the meticulous approach of Indian captains.

• Insert a new chart, visualizing progress and achievements similar to those under Rohit Sharma's guidance.

Answer explanation

Enter Page Break Preview view, planning strategies similar to Virat Kohli's leadership in setting goals.

When you use Ctrl + Shift + # in Excel, what formatting does it apply to selected cells?

• Apply Currency format, calculating key metrics similar to the impact of Hardik Pandya's explosive batting.

• Apply Date format, tracking trends akin to Ravindra Jadeja's analytical approach.

• Apply Percentage format, evaluating performance metrics akin to the versatility of Indian batsmen.

• Apply Time format, monitoring durations similar to the endurance displayed by Indian cricketers.

Answer explanation

Apply Date format, tracking trends akin to Ravindra Jadeja's analytical approach.

Rohit Sharma is known for his ability to build big innings, much like the comprehensive exemptions available under the Old Tax Regime. How does the Old Tax Regime's allowance for Standard Deduction from Salary of Rs. 50,000 compare to the New Tax Regime?

• Only Old Tax Regime allows it

• Only New Tax Regime allows it

• Both Regimes allow it

• Neither Regime allows it

Virat Kohli is known for his consistency, just like the multiple deductions available under Section 80C in the Old Tax Regime. Does the New Tax Regime offer the same consistency in deductions?

• Yes

• No

• Only for senior citizens

• Only for self-employed individuals

Ravindra Jadeja’s versatility as an all-rounder mirrors the diverse deductions like Medical Insurance Premium under Section 80D in the Old Tax Regime. Does the New Tax Regime offer this versatility?

• Yes

• No

• Only for senior citizens

• Only for those with a chronic illness

Shikhar Dhawan's aggressive batting style mirrors the efficiency gained from the Delegation of Powers in Subsection 2 of Section 5. What does this subsection allow central tax officers to do?

• Retain all powers for themselves.

• Delegate their powers to subordinate officers.

• Delegate powers only to the Commissioner

• Delegate powers to businesses.

Ravindra Jadeja’s versatility in contributing to all aspects of the game can be compared to the importance of understanding Section 5 for businesses. Why is understanding Section 5 crucial for businesses?

• It helps them avoid paying taxes.

• It clarifies authority during audits and compliance, streamlines interactions with tax authorities, and ensures a fair appeal process.
  

• It allows them to delegate their tax responsibilities to other businesses.

• It gives them the power to audit other businesses.