Computer Applications

Conditional formatting can be changed in spreadsheet applications like Microsoft Excel or Google Sheets by following these steps:
1. Select the range of cells where conditional formatting has been applied.
2. Go to the Home tab and click on Conditional Formatting in the toolbar.
3. Choose “Manage Rules” or “Clear Rules” depending on the required action.
4. In the Manage Rules dialog box, you can:
\hspace*{0.5cm}– Edit an existing rule by clicking on it and choosing “Edit Rule”
\hspace*{0.5cm}– Change the condition, cell range, or formatting style
\hspace*{0.5cm}– Rearrange rule priority using the arrows
5. Click OK or Apply to confirm changes.
6. You can also use the “New Rule” option to add more formatting criteria.
Changing conditional formatting allows users to visually analyze data by applying colors or icons based on updated criteria.

Internal margin in MS Excel refers to the spacing between the text in a cell and the cell boundary.
It affects how text is positioned within the cell and ensures proper readability without overlapping edges.
Available Internal Margin Options:
These can be adjusted via Format Cells → Alignment tab → Text alignment → Cell Margins.


Top Margin – Space between text and top of the cell

Bottom Margin – Space between text and bottom edge

Left Margin – Indentation from the left edge of the cell

Right Margin – Space from right boundary

This is especially helpful when printing or creating reports for better alignment and professional formatting.

Batch Processing is a method where data is collected and stored over time and then processed together in one go.
It is useful when:
- Large volumes of data are handled
- Immediate output is not required
- Example: Payroll run, Bank clearing, Utility billing
In contrast:
- Real-time processing handles data instantly as it arrives
- Data validation checks for correctness
- Processing and Revalidation is not a formal processing method
Thus, the correct term for accumulated, grouped processing is Batch Processing.