Computer Science
Class-VII
Chapter-7 Formatting Data in MS-Excel
A. Fill in the blanks:
1. One can give a tilt to your text using the option under the ______ tab of the ______ group.
Answer: Home, Font
2. One can choose the number of decimal places by selecting the ______ tab.
Answer: Home
3. Numbers are always _______ aligned, and text is always ______ aligned in MS-Excel.
Answer: Right, left
4. Alignment buttons are also available on the _______ tab.
Answer: Home
5. For wrapping text in multiple lines select _______ in the alignment tab.
Answer: WrapText
B. Write whether true or false:
1. One can apply vertical alignment to the cells.
Answer: True
2. Text is always right-aligned.
Answer: False
3. You cannot merge cells in MS-Excel.
Answer: False
4. One can use the font option of the format menu to change font formatting.
Answer: True
5. One can change the background color of the cells.
Answer: True
C. Tick the correct option:
1. What refers to the position in which data is placed within the boundary of a cell?
a. Pattern b. Alignment
Answer: Alignment
2. What changes the appearance of data?
a. Formatting b. Fonts
Answer: Formatting
3. The type of alignment of numbers in MS-Excel.
a. left-aligned b. right-aligned
Answer: right-aligned
4. The type of alignment of text in MS-Excel.
a. right-aligned b. left-aligned
Answer: left-aligned
D. Answer the following questions:
1. What is formatting?
Answer: Formatting means change the appearance of the data. The process of determining how data should be presented and how it will appear on the printed page is calledformatting.
2. Why is formatting of data necessary?
Answer: Formatting is necessary because formatting present data in an effective manner. It makes data more attractive and easy to read.
3. What do you mean by alignment?
Answer: The position in which data is placed within the boundary of a cell is called alignment. By default numbers are right align and text is left align in MS Excel.
4. What steps would you follow to format the font of data in a cell?
Answer: To format the font of data follow the steps:
1. Select the cells.
2. On the format cells dialog box click the font tab.
3. Make the appropriate changes in font, font style, font size, color and click on OK button.
5.Write the steps to apply a border to a group of cells.
Answer: Follow the steps to apply a border to a group of cells:
1. Select the cells.
2. Click on the border tab in the format cells dialog box.
3.Make your choices in the border, style and color group boxes. Then click the OK button.
You may like:
No comments:
Post a Comment