Chapter 4: Formatting in Excel -

Indian Public School Computer Class 6 Question Answer

A. Fill in the blanks.

Borders can be applied to cells in an Excel sheet from the …………..group. Answer: Font
Background Colour can be applied to a cell in an Excel sheet from options under the …………. tab . Answer: Home
The ………….. text alignment option is not available in Excel. Answer: Justified
The …………….. style is not present under the font group in Excel . Answer: Expand
The ………………… vertical alignment of text is available in Excel . Answer: Center
The …………………alignment of text is availble in excel. Center Answer : Center

B. Answer in one word

Fitting text in a cell by increasing the row height Answer : Wrapping
Adjusting the position of text in a cell in Excel . Answer : Alignment
Coloured grid for cells in an Excel sheet. Answer : Border
To join multiple cells to form a single cell . Answer : Merge
Alignment of text from bottom left corner to top right corner of a cell in Excel. Answer: Diagonal
This button displays numeric values with a thousand separator comma . Answer : Comma Style

C. Find the nearest match

Coloring the area inside a cell in Excel . Answer : Background
Fitting text by increasing row height in Excel. Answer : Wrap
Displayng a numeric value in a specific way. Answer : Currency
Fitting text by joining three cells in a row in Excel. Answer : Merge
Displaying a numeric value with a thousand saparator comma.. Answer : Comma Style
Displaying Gridline in the printed Excel Sheet . Answer : Border

C. Write T for True and F for False statements.