Computerised Accounting

To solve the problem, we need to identify the feature of a Computerised Accounting System that allows it to adapt to any size of business and type of organization by adjusting to changes in the volume of data processing.

1. Understanding the Given Statement:
The question highlights the fact that the accounting software can handle increases or decreases in data processing volume depending on the size of the business. This implies that the system can grow or shrink in capacity as needed.

2. Feature Being Highlighted:
This feature is known as Scalability — the ability of a system to handle a growing amount of work or its potential to accommodate growth.

3. Explanation of Options:

• (A) Scalability: Correct — it refers to the system’s ability to grow and manage increased demand.
• (B) Simple: Incorrect — simplicity relates to ease of use, not to handling scale.
• (C) Speed: Incorrect — speed refers to how fast the system processes data, not its adaptability.
• (D) Reliability: Incorrect — reliability refers to the system’s dependability and accuracy, not its flexibility in size.

Final Answer:
Correct Option: (A) Scalability

To solve the problem, we need to write the steps to create an 'IF' function in Excel using the Formula tab and dialog box to apply depreciation rules based on the cost of the machine (excluding installation charges).

1. Understanding the Condition:
We are given:

• If the machine cost (excluding installation) is greater than Rs 2,00,000, apply 20% depreciation.
• If it is less than or equal to Rs 2,00,000, apply 10% depreciation.

2. Steps to Create an IF Function Using the Formula Tab and Dialog Box:

1. Select the cell where you want the depreciation amount to appear.
2. Go to the Formula tab on the Ribbon.
3. Click on Insert Function (fx) near the formula bar.
4. In the dialog box, type IF in the search box and press Go.
5. Select the IF function from the list and click OK.
6. Fill in the function arguments:
   • Logical_test: =A2>200000 (Assuming A2 contains the cost excluding installation)
   • Value_if_true: A2*20%
   • Value_if_false: A2*10%
7. Click OK to apply the function.

3. Syntax of the IF Function:
=IF(A2>200000, A2*20%, A2*10%)
Here, A2 is assumed to be the cell containing the cost of the machine (excluding installation charges).

Final Answer:
The IF function is created using the Formula tab and dialog box, and the correct syntax is:
=IF(A2>200000, A2*20%, A2*10%)

A Comparative Balance Sheet compares financial positions of two periods. The structure involves 5 columns: Particulars, 2024 values, 2023 values, Absolute Change, Percentage Change. This helps identify financial trends and shifts.

Comparative Balance Sheet of Tushar Ltd. as at 31^st March, 2024

Interpretation:
There is a 50% increase in total equity and liabilities as well as total assets.
- Share Capital: Increase due to fresh issue of shares indicates equity funding.
- Borrowings: Additional ₹3,00,000 may have been used for capital expenditure.
- Fixed Assets: Rise of 65% shows significant investment, possibly for expansion.
- Cash Position: 25% decline in cash must be watched to ensure liquidity isn't strained.

Overall, the company's financial position has expanded substantially.

Each error type in Excel has a specific meaning:
(A) #DIV/0! Error Occurs when a number is divided by zero or an empty cell.
(B) #NUM! Error Appears when there are invalid numeric values in a formula (e.g., square root of a negative number).
(C) #N/A Error Indicates that a value is not available to a function or formula.
(D) #NAME? Error Happens when Excel doesn't recognize a function name or named range.
The question asks about missing or unavailable values.
This matches the meaning of #N/A Error.

Number Formatting

Number formatting refers to how numbers are displayed in spreadsheet or accounting software. It allows users to present numeric values in meaningful formats.

Common types of number formatting include:

• Currency: Displays values with currency symbols like ₹ or $ (e.g., ₹5,000.00)
• Number: Shows numeric values with or without decimal points (e.g., 5000.00)
• Percentage: Converts and displays values as a percent (e.g., 0.25 as 25%)
• Date and Time: Converts serial numbers to readable dates and times (e.g., 44927 as 31-Mar-2023)
• Scientific: Represents very large or small numbers using exponential notation

Note: Number formatting doesn’t change the actual value in the cell, only how it appears.

To solve the problem, we need to create an IF function using the Formula tab and the Insert Function dialog box in a spreadsheet (e.g., Microsoft Excel) to calculate depreciation based on the total cost of the machine excluding installation charges.

1. Understanding the Condition:
We are told:

• If the total cost (excluding installation charges) is greater than Rs 2,00,000, then depreciation is 20%.
• If it is less than or equal to Rs 2,00,000, then depreciation is 10%.

2. Steps to Use the IF Function via the Formula Tab:

1. Click on the cell where you want the depreciation value to appear.
2. Go to the Formula tab on the Ribbon.
3. Click on Insert Function (fx) on the left.
4. In the Insert Function dialog box, search for "IF" and select it.
5. Click OK.
6. In the function arguments window:
   • Logical_test: Enter the condition (e.g., A2 > 200000).
   • Value_if_true: Enter the formula for 20% depreciation (e.g., A2*20%).
   • Value_if_false: Enter the formula for 10% depreciation (e.g., A2*10%).
7. Click OK to apply the function.

3. Syntax of the IF Function:
=IF(A2>200000, A2*20%, A2*10%)
Here, A2 represents the cell containing the total cost (excluding installation charges).

Final Answer:
The IF function is created using the Formula tab and dialog box, and the result is given by the syntax:
=IF(A2>200000, A2*20%, A2*10%)

To solve the problem, we need to determine which button should be clicked in Excel to see all available shape styles.

1. Understanding the Context:
In Microsoft Excel (and other Office applications), when you insert a shape and want to view all the styling options available for that shape (like color, outline, effects), you need to access the extended style menu.

2. Correct Option:
To view all available shape styles, you click the "More" button (usually represented by a small downward-pointing arrow with a horizontal line) in the Shape Styles group under the Format tab.

This expands the shape style gallery and displays all predefined styles that can be applied to the selected shape.

Final Answer:
The button clicked to see all available shape styles is "More".
Correct Option: (D) More

To solve the problem, we need to understand what a null value signifies in the context of data and databases.

1. Understanding Null Value:
A null value is used to represent the absence of a value or when the value is unknown or not applicable. It is not the same as a zero, blank, or empty string — it simply means “no data.”

2. Correct Option Analysis:

• (A) Stores value items — Incorrect, because a null value stores no value.
• (B) Data with many values — Incorrect, null means no value, not multiple values.
• (C) Absence of data items — Correct, this matches the definition of null.
• (D) Single value data item — Incorrect, null does not refer to a value, but the lack of one.

Final Answer:
Correct Option: (C) Absence of data items

To solve the problem, we need to identify which item belongs to the Asset group 'Current Assets' under the account group of Assets in accounting.

1. Understanding Current Assets:
Current Assets are assets that are expected to be converted into cash, sold, or consumed within one financial year or within the normal operating cycle of the business.

2. Explanation of Options:

• (A) Duties and Taxes: These are liabilities or payables, not assets — Incorrect.
• (B) Miscellaneous Expenditures: These are deferred revenue expenditures — Incorrect.
• (C) Reserves & Surplus: These are part of Shareholder’s Equity, not assets — Incorrect.
• (D) Direct Expenses: These are related to the cost of production, not assets — Incorrect.

However, none of the given options correctly fits under the group 'Current Assets'.
Usually, examples of current assets include:

• Cash in hand
• Bank balances
• Accounts receivable
• Inventory
• Short-term investments

Since the correct option is not present among the listed choices, technically, none of the above options belong to 'Current Assets'.

Final Answer:
None of the provided options correctly represent a Current Asset.

Cash Flow from Operating Activities (Indirect Method)

For the year ended 31st March, 2025

Working Notes

• Increase in Trade Payables = 1,17,000 − 50,000 = +67,000 (Add)
• Decrease in Other Current Assets = 27,000 − 24,700 = +2,300 (Add)
• Decrease in Commission Received in Advance = 10,000 − 4,000 = (6,000) (Less)
• Increase in Accrued Interest = 30,000 − 10,000 = (20,000) (Less)
• Decrease in Outstanding Rent = 20,000 − 10,000 = (10,000) (Less)
• Increase in Trade Receivables = 1,00,000 − 81,000 = (19,000) (Less)
• Increase in Inventories = 75,000 − 50,000 = (25,000) (Less)

Net Effect of Working Capital Changes:
67,000 + 2,300 − 6,000 − 20,000 − 10,000 − 19,000 − 25,000 = (10,700)

Final Answer

The Net Cash Flow from Operating Activities for the year ended 31st March, 2025 is ₹6,11,300.