PART-B Unit-4 Electronic Spreadsheet-LibreOffice(2025-26)
Chapter-3 Format data in the spreadsheet
A. Fill in the Blanks
1.The Formatting tool in LibreOffice Calc allows users to quickly apply formatting styles.
Answer: Formatting
2.The Format Cells dialog box is used to apply specific formats to numbers, text and dates.
Answer: Format Cells
3.To format a range of cells with a specific number of decimal places, use the Number tab in the Format Cells dialog box.
Answer: Number
4.Formatting a range of cells as Text ensures the display of text instead of numbers.
Answer: Text
5.The Scientific format is used to represent very large or very small numbers in scientific notation.
Answer: Scientific
B. Write True / False
1.The Format Cells dialog box is used to align text in a spreadsheet.
Answer: True
2.Decimal places cannot be customized in any range of cells.
Answer: False
3.You can use the Fill Handle to copy formulas across multiple cells.
Answer: True
4.Cells formatted as Scientific display numbers in decimal notation.
Answer: False
5.The Fill Handle cannot extend number sequence automatically.
Answer: False
C. Choose the Correct Answer
1.How can you display time in a range of cells?
A) By using the Time format
B) By typing numbers manually
C) By using the Fill Handle
Answer: A) By using the Time format
2.What happens when you format cells as Text?
A) Numbers are treated as numeric values
B) Leading zeros are preserved
C) Formulas are disabled
Answer: B) Leading zeros are preserved
3.Which feature helps speed up data entry and fill patterns?
A) Options
B) Fill Handle
C) Format Cells dialog box
Answer: B) Fill Handle
4.The option to format decimal places is available under which tab?
A) Number
B) Alignment
C) Borders
Answer: A) Number
5.How can you copy a formula across multiple cells?
A) By typing it repeatedly
B) By using the Fill Handle
C) By using the Alignment tab
Answer: B) By using the Fill Handle
D. Short Answer Questions:
1.What is the purpose of the Format Cells dialog box?
Answer: It is used to change the appearance of data such as number format, alignment, font style, border and background colour.
2.How can you change the alignment of text within a cell?
Answer: Select the cells → Right-click → Format Cells → Click Alignment tab → Choose Left/Center/Right or Top/Middle/Bottom alignment.
3.What is the role of the Fill Handle in Calc?
Answer: It helps to copy formulas, continue patterns, and extend number or date sequences quickly to adjacent cells.
4.How can you format a range of cells to display time values?
Answer: Select cells → Format Cells → Number tab → Select Time → Apply.
5.What steps are needed to format a cell to display a fixed number of decimal places?
Answer: Select cells → Format Cells → Number tab → Set Decimal places → OK.
E. Long Answer Questions
1.What are the benefits of using the Fill Handle to copy formulas across rows or columns?
- → The Fill Handle reduces time and effort by automatically copying the formula to multiple cells.
- → It maintains correct cell references using AutoFill.
- → It helps extend number sequences or patterns without rewriting data.
2.Explain the use of Format Cells dialog box for data alignment and presentation.
- → The Format Cells dialog box allows alignment of text horizontally and vertically to improve viewing.
- → Users can set font style, border, background color, number format and text wrapping.
- → Proper formatting makes data neat, readable, and professional.
3.Discuss how formatting tools in Calc improve readability and usability of data.
- → Formatting highlights important data, organizes information clearly, and makes analysis easier.
- → Different number formats (currency, percentage, scientific) help interpret values correctly.
- → Borders, colours and alignment help in better presentation.
4.Illustrate with examples how to format salary for consistent data display.
- → Select salary column → Format Cells → Select Currency (₹) → Set decimal places as needed.
- → Example: ₹10,000.00
- → It gives a uniform currency format and makes comparison easier.
5.Describe the advantages of using predefined formats in Calc for faster data processing.
- → Predefined formats save time by applying common formatting styles quickly.
- → They ensure accuracy in data interpretation such as Date, Time, Percentage, Currency formats.
- → They improve consistency of spreadsheet appearance.
SOME OTHER LINKS YOU MAY LIKE:
No comments:
Post a Comment