
| Basis | Analog Computer | Digital Computer |
|---|---|---|
| Nature of Data | Continuous data | Discrete (0s and 1s) |
| Working Principle | Measures physical quantities | Arithmetic & logical operations |
| Accuracy | Less accurate | Highly accurate |
| Speed | Faster for simulations | Efficient for general tasks |
| Output | Graphical/continuous | Numerical/symbolic |
| Basis | Straight Line Method | Diminishing Balance Method |
|---|---|---|
| Depreciation Amount | Same every year | Decreases every year |
| Basis of Charge | Original cost | Written down value |
| Book Value at End | Can become zero | Never zero |
| Ease | Very simple | Slightly complex |
| Suitable For | Uniform usage assets | Rapid obsolescence assets |
| Basis | Compiler | Interpreter |
|---|---|---|
| Translation | Entire program at once | Line by line |
| Speed | Faster execution | Slower |
| Error Display | All errors together | One error at a time |
| Output File | Creates .exe file | No separate file |
| Examples | C, C++ | Python, BASIC |
| Basis | Android OS | Windows OS |
|---|---|---|
| Developer | Microsoft | |
| Platform | Linux-based, Open-source | Proprietary |
| Interface | Touch-based | Keyboard + Mouse GUI |
| App Store | Google Play Store | Microsoft Store |
| Devices | Mobiles, Tablets | Desktops, Laptops |
| Basis | Sole Proprietorship | Partnership |
|---|---|---|
| Ownership | Single person | 2 or more persons |
| Decision Making | Quick & independent | Mutual agreement |
| Liability | Unlimited | Shared |
| Capital | Limited | More capital |
| Continuity | Ends with owner | Continues with agreement |
| Basis | DSS | MIS |
|---|---|---|
| Purpose | Semi-structured decisions | Routine reports |
| Data | Internal + External | Internal only |
| Decision Type | Analytical | Programmed |
| Output | Models, simulations | Periodic summaries |
| Flexibility | High | Standardized |
| Basis | NEFT | RTGS |
|---|---|---|
| Settlement | Batch-wise | Real-time individual |
| Minimum Limit | No minimum | ₹2 lakh |
| Speed | Few hours | Instant |
| Suitability | Small payments | High-value transfers |
| Availability | 24×7 | 24×7 |
| Basis | Statement of Loan | Lease Declaration |
|---|---|---|
| Ownership | Asset ownership remains with the borrower. | Ownership remains with the lessor. |
| Payment Type | Repayment includes principal + interest. | Payment includes rent and lease charges. |
| Tenure | Fixed repayment tenure. | Flexible tenure as per the lease agreement. |
| Balance Sheet Impact | Shown as a liability. | Treated as an expense in the income statement. |
| Basis | Country Code TLD (ccTLD) | Generic TLD (gTLD) |
|---|---|---|
| Meaning | Represents the name of a country or region. | Represents general categories, groups, or organizations. |
| Examples | .in (India), .uk (United Kingdom) | .com, .org, .edu |
| Control | Managed by national authorities. | Managed by international bodies like ICANN. |
| Purpose | Used for region-specific websites. | Used for global or generic purposes. |
| Identification | Two-letter domain code. | Usually three letters or more. |
| Basis | Local Area Network (LAN) | Wide Area Network (WAN) |
|---|---|---|
| Coverage Area | Covers small areas like offices, buildings, or campuses. | Covers large geographic areas such as cities, states, or countries. |
| Ownership | Privately owned and managed. | Can be privately or publicly owned; often shared infrastructure. |
| Speed | High data transmission speed. | Relatively lower speed compared to LAN. |
| Cost | Lower installation and maintenance costs. | Expensive due to the wide infrastructure. |
| Examples | Office or campus network. | Internet or banking network systems. |
| Basis | NPV (Net Present Value) | IRR (Internal Rate of Return) |
|---|---|---|
| Meaning | The difference between the present value of cash inflows and outflows. | Discount rate at which NPV becomes zero. |
| Decision Rule | Accept if NPV > 0. | Accept if IRR > cost of capital. |
| Measure Type | Absolute measure (value in rupees). | Relative measure (percentage rate). |
| Computation | Requires a predetermined discount rate. | Determines discount rate internally. |
| Interpretation | Shows total value gain in monetary terms. | Shows the earning rate of the investment. |
| Basis | Current Ratio | Quick Ratio |
|---|---|---|
| Meaning | Compares current assets with current liabilities. | Compares quick (liquid) assets to current liabilities. |
| Formula | Current Assets ÷ Current Liabilities | (Current Assets − Inventory − Prepaid Expenses) ÷ Current Liabilities |
| Components | Includes all current assets. | Excludes inventory and prepaid expenses; considers only liquid assets. |
| Ideal Ratio | 2: 1 | 1: 1 |
| Significance | Measures overall liquidity. | Measures immediate liquidity and short-term solvency. |
| Basis | Authentication | Authorization |
|---|---|---|
| Meaning | Verifies the identity of the user. | Grants access to specific resources. |
| Process | Occurs first in the security process. | Occurs after authentication. |
| Verification | Confirms “Who you are.” | Confirms “What you can do.” |
| Methods Used | Passwords, biometrics, OTPs. | Access rights, roles, and permissions. |
| Example | Logging into an account. | Accessing restricted files after login. |
| Aspect | Functions | Formulas |
|---|---|---|
| Definition | Predefined (built-in) operations provided by the spreadsheet software | User-created expressions to perform calculations |
| Syntax Example | Uses specific function names with arguments =SUM(A1:A5) =AVERAGE(B1:B5) =VLOOKUP(...) =IF(...) | Uses arithmetic operators and/or cell references =A1+A2+A3+A4+A5 =B1*B2+C1 =(A1+A2)/2 |
| Purpose | Perform standard, repeatable, and often complex computations quickly | Perform customized or simple calculations tailored to specific needs |
| Ease of Use | Easier and faster, especially for complex or repetitive tasks (error-free, optimized) | Requires manual creation; more prone to errors, but offers full flexibility |
| Reusability | Highly reusable across sheets and workbooks | Can be copied, but logic must be built from scratch each time |
| Examples | =SUM(B1:B10) =AVERAGE(B1:B5) =COUNTIF(C1:C100,">50") =TODAY() | =B1+B2+B3+B4+B5 =(Sales - Costs) * Tax_Rate =A1^2 + A2^2 |
| Basis | Formulae | Array Formulae |
|---|---|---|
| Processing | Uses single-value or cell references. | Multi-array or range processing. |
| Output | It only gives a result. | It can produce a single result or several results. |
| Syntax | Regular formulae (e.g. | Enter the code enclosed by using Ctrl+Shift+Enter. |
| Usage | Calculate the amount of money you need to spend. | You can use complex matrix or data analysis tasks. |
| Example | =A1+A2 | =SUM (A1:A5*B1:B5) |
| Aspect | Absolute Addressing | Relative Addressing |
|---|---|---|
| Definition / Behavior when copied | Cell reference remains fixed (does not change) when the formula is copied to another cell | Cell reference automatically adjusts based on the new position when the formula is copied |
| Symbol Used | Dollar signs $ lock the column and/or row Examples: • $A$1 – locks both column and row • A$1 – locks only row • $A1 – locks only column | No dollar signs. Example: A1 |
| Fixed / Constant reference: Ideal for referring to a single fixed value (e.g., tax rate, discount %, conversion factor) | Dynamic reference adjusts automatically – perfect for sequential or repetitive calculations across rows/columns. |