Question

_________ helps in making the content in electronic spreadsheet look neat and easy to read.

• A. Alignment
• B. Sorting
• C. Filtering
• D. Formatting

Hint:

Remember: Formatting alters the "looks" (colors, styles, borders), whereas sorting and filtering alter the "arrangement" of the data.

Answer 1

The Correct Option is D

Step 1: Concept
Formatting in electronic spreadsheets refers to modifying the visual presentation of data to improve its overall appearance and readability.

Step 2: Meaning
It involves changing attributes like font styles, sizes, colors, cell borders, shading, and number layouts without altering the actual underlying data values.

Step 3: Analysis

• Alignment adjusts the positioning of text within a specific cell (left, right, center), which is just one minor subset of presentation.

• Sorting simply reorders the existing data systematically (e.g., alphabetical or highest to lowest) but doesn't change how the text visually looks.

• Filtering hides specific rows that do not meet certain criteria to narrow down data sets.

• Formatting encompasses all visual layout tools designed to make the entire sheet look neat, professional, and easy to read.

Step 4: Conclusion
Therefore, "Formatting" is the correct, comprehensive term for enhancing the neatness and readability of a spreadsheet.

Final Answer: (D)