IT Planet Class 6 Computer Chapter 6 Solution – Formatting Worksheet in Ms – Excel
IT Planet Class 6 Solution: IT Planet Class 6 Computer Chapter 6 Formatting Worksheet in Ms – Excel all Question Answer Solution by Expert Computer Teacher. Here Students can here all Questions Accurate Answers of Chapter Formatting Worksheet in Ms – Excel Solution.
Q1) Tick the (√) the correct answer :-
a) You can make a worksheet look more attractive and legible by
Ans ii) Formatting
b) The position in which data is placed within the boundary of a cell is referred to
Ans iii) Alignment
c) The number of styles offered by Excel 2010 is
Ans i) 12
d) To apply a combination of formatting settings, …………………………. is used.
Ans iii) Theme gallery
Q2) Write ‘T’ for True and ‘F’ for False Statement :-
a) You can change the font of the text in Excel. T
b) The conditional formatting is used to format the data according to only one condition. F
c) Excel offers 10 number styles to format the numbers. F
d) By default, Excel aligns text data to the left of the cells. T
e) General number format add rupees sign and decimal to display monetary value. F
Q3) Fill in the blanks :-
a) Percentage number format multiples cell value by 100.
b) Alignment is used for centering titles over the data.
c) Borders can be added to the cells for separating the data from surrounding cells.
d) To control the appearance of numerical data number formatting is done.
e) Special number format style works with a list and database values.
f) You can control number of decimals that appear with numeric data using Increase
Decimal and Decrease Decimal commands.
Q4) Answer the following questions :-
a) Solution:
Formatting means to make changes to the worksheet data in the form of changing
font, its size, color and shading etc, after which the worksheet gets a professional and
attractive look.
b) Solution:
Conditional formatting is a feature that is used to apply the formatting to value
which fulfils the required/specified condition.
c) Solution:
Alignment means changing the position of the text within the selected cell. Basically there
are 3 types of alignment such as Left, Center, Right. By clicking on Right align will help you to place you selected text a the right side of the cell/document, center means the selected text will be moved to the middle of the cell/document and left align will move to the left side. By default in Excel the text data is aligned to the left and number to the right.
d) Solution:
There are 12 different number formats in Excel which are :-
i) General – It is the by default category (no specific formatting is applied)
ii) Number – General number is displayed with decimal points.
iii) Currency – Add Rupees signs and decimals to display monetary values.
iv) Accounting – Lines up currency symbols and decimal points in a column.
v) Date – Display the date values
vi) Time – Display the time values
vii) Percentage – Multiplies cell value by 100 and displays percent sign
viii) Fraction – Displays value as a specified fraction
ix) Scientific – Uses scientific or exponential notation
x) Text – Treats values as Text
xi) Special – Works with list and database values
xii) Custom – Enables you to create your own custom format
e) Solution:
In Excel to give a professional or attractive look to the worksheet, Theme Gallery is
used to apply the mixture of formatting settings like colors, fonts and effects etc.
f) Solution:
The previewing/ displaying of themes in the worksheet when the mouse pointer is
moved upon/over Themes. Such feature is called Live Preview.
g) Solution:
Borders can be added to the cells in the worksheet for separating the data from
surrounding cells.
Q5) Application Based Questions:-
a) solution:
If the teacher has given an Excel worksheet of 50 students along their marks obtained
in different subjects. She has also asked us to accomplish the task of highlighting the marks which is 40. So I will make use of conditional formatting that you will find under Home Tab. Select the option as Click on Home tab ———- select the conditional formatting option —— Highlight cell rules ——- less than.