Rajasthan Board Class 10 Information Technology Chapter 2 Solution Formatting A Worksheet RBSE Class 10 Information Technology Solution for Chapter 2
Q1) Multiple choice question
1) Format painter is use
a) To print pretty pictures on your slides
b) To copy formatting from one object or piece
c) To change the background colour of your slides
d) To paint pretty pictures on background of slides
Ans – b) To copy formatting from one object or piece
2) On an Excel sheet the active cell is indicated by?
a) A Dotted border
b) Dark dark wide border
c) a blinking border
d) By italic text
Ans – b) a dark wide border
3) How are data organised in a spreadsheet?
a) Lines and space
b) layer and planes
c) row and columns
d) height and width
Ans – c) Row and columns
4) You can launch format cell Dialogue box using command
a) Ctrl +1
b) Ctrl+ 5
c) Ctrl+2
d) Ctrl+3
Ans- a) ctrl +1
5) There are .—-Types of fonts styles in Excel
a) 8
b) 6
c) 4
d) 2
Ans- c) 4
6) Which tab is not available in format cell dialogue box?
a) Number
b) Font
c) Fill
d) Margins
Ans- d) margins
Q2) Very short answer type questions
1) What is the use of format painter?
Ans- The use of format painter to copy formatting one things in a document to another quickly it can be done at the second,
2) Does custom number format affect the underlying value of the number?
Ans- Custom number format not affect the underlying value of the number
3) Write the name of font style in Excel
Ans – regular, italic, bold, and bold italic are the type of font style
4) What is cell style?
Ans- a set of formatting characteristics that is number formatting cell border, cell shading font and font sizes it is an cell style
5) What is cell alignment?
Ans- Cell alignment is defined as in Excel by the cell alignment how your text end number of cell can we positioned in the cell horizontally and vertically.
Q3) Short answer type question
1) Write down the step for changing row height and column width
Ans- following are the steps Which is used for changing row height and column width
Step 1 click on the home tab and then in the home tab click on the cell group and in the cell group click on the format
Step 2 in the format under cell size and then click on row height
step 3 In the row height dialogue box then type the appropriate value that you want
These are the steps which is used to changing row height and column with
2) What is the use of format cell dialogue box?
Ans – Use of format cell dialogue box is to apply more and more Or less any type of formatting style and numbers are formatting by using format cell dialogue box, the format selected from format cell dialogue box will be effective to the cell that are selected
3) What do you mean freeze and unfreeze of rows ?
Ans- The meaning of freeze explain as when we use the freeze option a column or row in Excel then you are able to scroll that column or row
The unfreeze is defined as when we use freeze option and after you use the unfreeze option in the column or row when you scroll the window then the row and column will not be seen.
4) What is conditional formatting?
Ans- The conditional formatting is allows you to format only a cell or range of cells which is meet to the certain criteria or certain conditions, it is more flexible
5) Explain the number formats in Excel?
Ans – To show or display the number in the cell that is depends on the format of that cell, the number formats provides many option for displaying numbers, date , currency , percentage etc by using number formats you can customize a built in number format to create your own to apply the number format in a specific way number of steps are use.
Q4) Essay type questions
1) How you can apply number format in Excel?
Ans- Following are the steps which is used to apply the number format in Excel
Step 1 in the Excel firstly select the cells that you want to format
Step 2 then right click and the select format cells from the pop up menu And the go to number group of home tab
Step 3 then select the number tab from the format cells of the dialogue box
Step 4 And in the last step choose an appropriate category and other options and then click on the option
These are the steps which is used to apply number format.
2) What is the custom number formats ? and explain the steps to create custom number formats?
Ans – If you create the any number formats and it is does not meet to your needs at that condition you can create a new number format or you can customize the number format that is based on an existing number format and add it to the list of custom number formats
Following are the steps which is used to custom number format
Step 1 in the number format Click on the right and then select format cell from the pop up menu or then go to the number group of home tab
Step 2 in the home tab select the number tab from format cell dialogue box
Step 3 then in dialogue box select the custom category
Step 4 in this type list select the Built in format that most resembles the one that you want to create
Step 5 in the type box modify the number format codes to create the exact format that you want
Step 6 when you have finished click OK.
3) Explain cell styles and steps to create your own cell style
Ans – A set of formatting characteristics that is number , format, cell borders , cell shading , font and font size it is called as a cell styles the cell styles is used to quickly format cell by choosing from predefined styles
Following are the steps off cell style
Step 1 firstly select the cell to apply a style on
Step 2 then go to style group of home tab
Step 3 Click to desire cell style
4) How you can add border and colors to cell explain it
Ans – To apply or to add border and colours to cell some steps are use that steps are follows
- Step 1 in the home tab click on the cell group and then click on the format option
- Step 2 And then under the protection click on the format cell and then to display the format cells dialogue box
- Step 3 then select the border tab
- Step 4 Then choose the None outline or inside in the present area to specify the location for the border
- Step 5 then there are 3 options are present and choose one of or any one of them Of options for the board
a) In the border area click on any of the buttons to toggle its border
b) Choose the borders line style in the style area
c) If necessary select a colour or the border in the colour palette
- Step 6 select the patterns tab and then choose the option
a) Select colour for background from the colour palette of section
b) And if it is necessary then select a pattern for the background of the section from the pattern palette
- step 7 then click on the okay option to apply the border and colour
5) Write short note on worksheet formatting
Ans- In Ms Excel sheet there are many type of formatting that can be applied in Excel which can make available numerous formatting option for creating of professional and official looking worksheets, which is display the worksheet is effectively and attractive to the work in the formatting worksheet font formats to change the typeface and style of the characters from your worksheet and we can use cell formats to change the colour number and size of cell and so on In the worksheet to specify formats other than general we can apply a number of built in number formats , if some time we can do not find the number format as we want then we can create our own custom number formats.