Rajasthan Board Class 10 Information Technology Chapter 1 Solution Introduction to MS Excel RBSE Class 10 Information Technology Solution for Chapter 1
Q1) MCQ
1) Features that display only the data in columns according to the specified criteria
a) Formula b) sorting c) filtering d) pivot
Ans – c) filtering
2) The process of arranging items of a column in a same sequence order is known as
a) Arranging b) Auto fill c) sorting d) filtering
Ans- c) sorting
3) How many seats are there by default when we create new Excel file
a) 1 b) 3 c) 5 d) 10
Ans- b) 3
4) Which of the following is not true regarding conditional formatting
a) You can add move then one condition to check
b) You can set condition to look for bold and apply italics on them
c) We can apply font border and pattern formatting that meets the specified conditions
d) You can delete any conditions formatting dialogue box if it is not required
Ans – b) You can set condition to look for bold and apply italics on the in
5) One cell format can be copied to another cell by using
a) Format painter
b) Format setting
c) Format showing
d) Format checking
Ans- a) format painter
6) Which symbol must all formula begins with ?
a) = b) + c) ( d) @
Ans- a) =
7) Which key do you press check spelling?
a) F3 b) F5 c) F7 d) F9
Ans – c) F7
Q2) Very short answer type questions
1) Does Ms word have advanced formatting facilities?
Ans- yes, Ms word have advanced formatting facilities
2) By default excel provides how many worksheet in a workbook?
Ans – by Default excel provides three worksheet in the work book
3) Which command is used to save the workbook?
Ans- ctrl +5 Is the command which is used to save the workbook
4) Navigation buttons are presented in the?
Ans- Navigation buttons are presented in the lower left corner of the Excel workbook
5) Headers and footers are only displaying in……… view and on the printed pages
Ans- Headers and footers are only display in Page layout view and on the printed pages
6) In Excel text entries and values are aligned to which side of the cell?
Ans- In Excel text entries and values are aligned to the left border of the cell while numbers are align to the right side of the cell .
7) Which Command is used to display the go to dialogue box?
Ans- F5 Is the command is used to display the go to dialogue box
8) Which button is used to check the spelling of text entries in the worksheet?
Ans – F7 Is the button which is used to check spelling of text entries in the worksheet
9) Why do you hide rows or columns in Excel ?
Ans- To display the specific content in Excel we are hide rows and columns , to hide the rows and columns in Excel,
Select home tab then click on the format in cell groups then under the visibility hide and unhide option is present
Then click on the hide sheet option and your rose and columns are hide.
Q3) Short answer type questions
1) What is Microsoft Excel?
Ans- Microsoft Excel is an application which is developed by Microsoft. It is a Spread sheet applications, it is most widely used spreadsheet. Application an part of Microsoft Office suite. Use of Excel is editing sorting, analysing , entering it can use to do arithmetic operations and numerical operation it can display number graphically.
2) Compare Ms world with Ms Excel
Ans- MS word
It is an word processing application which have advanced formatting Facilities
It can be inserted inside a word document
MS excel
It is an spreadsheet application which does not have the advanced formatting facilities
It can be inserted inside a Excel table
3) Define worksheet and workbook
Ans- Workbook – An ordinary Excel file is called as workbook, that contains different things such as worksheet chatsheet and small programs.
Worksheet – An Excel worksheet is a single spreadsheet that contains matrix of row which is denoted by number and columns which is denoted by letters are called as worksheet.
4) What do you mean by labelling in Excel?
Ans- Letters and numbers denote the columns and rows respectively called as labels, which are displaying grey boxes across top and left side of worksheet column having heading as a alphabets which are beginning from a alphabet and row are heated by numbers beginning from one
5) How can you add new sheet in Excel?
Ans – When we work in new workbook we can add the new worksheet by inserting new sheet and also rename it
click the insert worksheet tab at the bottom of screen to insert new worksheet
6) What are the navigation key in Ms Excel?
Ans- In the bottom left corner of workbook you will see four navigation buttons to the left of worksheet by right clicking on this buttons we can find all worksheet identified by name select one of them will take you to that worksheet
Some short keys also available to navigate workbook
Ctrl + page down – move to next sheet
Ctrl +page up – Move to previous sheet
Ctrl + f6/ tab – who to next workbook window
7) Discuss merge and split in Excel hey
Ans- Merge -a cell merge means conversion of selected cells into the single cell
We can merge one or more cell to create titles and also we can combine or merge the text from more than one cell into a one cell, firstly select all cells that we want to merge go to alignment group of home tab click on merge and centre for merge of selected cells
Splitting – Splitting means separation of merged cell in to separate cells, we can’t separate unmerge cell . Select the merged cells that we want to split go to alignment of home tab click merge and centre and click the unmerge cell option
8) Explain the step for creating header and footer in Excel
Ans – By using page layout view we can add or change the header and footer by the following steps it’s as follows
Step 1 – Firstly click the worksheet to which header and footer you want to add
Step 2 click on insert app click on header and footer Excel will display worksheet in Page layout view
Step 3 click the left, centre or right header text box add top or the bottom of worksheet
Step 4 type the text that we want to add or to change
Step 5 to close the header and footer click the anywhere in the worksheet.
9) What do you mean by sorting and write down steps for sorting in Excel
Ans- Sorting means the reorder of data in spreadsheet which can do in ascending or descending order
step 1 Select the cell in the column you want to sorting data
Step 2 click the salt and filter command, option available in the editing group of home tab
Step 3 select right option
By sorting data we head rows That we do not want to display, display only rows that meet criteria that we have to specify
10) What is the benefit off using formula in Excel
Ans- In the Excel sheet we can use formula to calculate values automatically. We can make all numerical calculation by using formulas in Excel. it save our time for calculation, it have accuracy in calculation due to use of formula, the different numerical operations is possible simultaneously by use of formula in excel
11) Short notes on header and footer
Ans- Header and footer is used to identify the specific document the header is the section of information printed on top portion of sheet and footer is the section of information which is printed at bottom portion of sheet, information in header and footer is shown static through out the document
Header and footer display only in page layout few on the printed page only, we can insert header and footer in the page layout view or we can use ppage set up box, if we want to insert header and footer for more worksheet at same time.
12) What is GO TO command
Ans – Go to command is used to move to a specific cell of the worksheet and moving between ranges by using F5 display the go to dialogue box Flowing are the steps to use GO TO command
Step 1 click anyone cell in the worksheet
Step 2 click go to command or click F 5
step 3 type the cell location in dialogue box
step 4 Click OK
Q4) essays type question
1) Explain information entering into Excel in detail?
Ans – Entering of data or information or information in Excel is feeling off data or entering of data in cell of Excel. To enter the information in Excel select cell by clicking on it and begins typing, we will see the text appears both cell and in the formula bar above. To enter typed data in Excel press the enter button the information will entered in immediately, Then move cursor on down one cell, we can also press Tab key instead of enter key, If we press tab the cursor move to the right cell, at the time of typing if we want to cancel then press escape key to cance, this make Excel back to the previous state it was before we starting typing, If we want to delete the data that we have entered in Excel then click on the cell for select the cell and press delete key to delete the data
2) What is the track changes? write down steps to turn on change tracking for a workbook.
Ans – Track change is used to log detail about work book changes Every time that we save our book. it gives the detail about what data are changed as compared to the saved workbook. After identifying data changed in workbook then we can accept or reject that data. Track changing is used when several users edit the workbook then we can check the changed data and reject or accept it , if we turn on track change feature it indicate the data edited by highlighting with unique border and indicators
Following are the steps to turn on track change
Step 1 click on share workbook in the review tab
Step 2 Select the allow changes by more than one user at same time Check box
Step 3 click on advanced tab
Step 4 click on “ keep change history for” and in the day box add the number of days change history that we want keep this track change
Step 5 click ok and save workbook and again click on ok.
3) What is the use of find and replace features ? and explain the steps to perform find and replace operation.
Ans – Use of find and replace features
- Find and replace features useful to change content rapidly in the worksheet
- Find and replace features used to find and change the values and replace the text in worksheet
- Find and replace features is used to find specific cell in the worksheet
- Find and replace feature is rapidly process to search and change the data
steps to find or replace text and number
step 1 click on any cell in the worksheet
Step 2 click find and select option in the editing group
Step 3 To find text and number click find, and to find and replace the content click on replace
Step 4 click on option to find defined research.
4) Explain Steps to insert cell, rows columns in the worksheet
Ans –
a) Step to Insert blank cell in the worksheet –
- Step 1 To insert new blank cell select the cell where you want to insert that blank cell
- Step 2 click on insert in the cell group
- Step 3 click on insert cell
- Step 4 choose the appropriate option in the insert dialogue box to insert more rows select the multiple cell in worksheet where we want to insert new blank row
b) step To insert blank column in worksheet
- Step 1 To insert the single row in worksheet select the row above which we want to insert new row for inserting more rows Select more row where you want to insert new row
- Step 2 click on insert
- Step 3 then click on insert sheet row
c) Step to insert blank column in worksheet
- To insert one single column select the column in the worksheet right of where you want to insert a new blank column and to insert more column select number of column immediately to right of where we want to insert new column
- Click on insert
- Click on insert sheet column
5) How you can set margins for header and footer?
Ans – If the problems found in header and footer to display we can fix footer and header by adjusting their margins hey
There are two way to adjust margins
a) With the help of mouse
step 1 click on office button select the print and then select the print preview option
Step 2 select the show margin option
Step 3 click and drag the margin to desired point by using mouse
Step 4 After drawing margin click on close print preview
b) With the help of page setup dialogue box
Step 1 select print and click print preview
Step 2 click page setup dialogue box
Step 3 select margins tab
Step 4 display page shows top, left, right, bottom header or footer text boxes by typing the size of margins you can set up margins
Step 5 after setup margin click OK
Step 6 click on close print preview.
6) Explain filters and sort operation in details?
Ans – Shorting is the process by which we reorder the data. The common spreadsheet task. the alphabetical ordering sorting is the common task of sorting, We can sort the data by sorting operation in ascending or descending order following are the steps to sort data in alphabetical order
Step 1 Select the cell from column that we want to sort
Step 2 click the sort and filter option which is displayed in the editing group of home tab
Step 3 select appropriate option
We can filter the data that meet criteria that we specify to display. That display the row only that meet criteria that we specify sort operation hide that data which are not meet criteria that we specify, after sorting the data we can print, move , edit , format the data without any changes or without re arranging the data we can filter the data present in more than one column.
7) What is the difference between function and formula in Excel
Ans –
- Formula calculate the values of cell while functions are predefined formulas which are available in Excel
- Function are called be a formulas but a formula not be a function
- Developers can update the functions but formula cant be updated by developers it is calculation of numerical
- Function begins with = sign but we can’t begins formula with = sign
8) Explain locking row and column by splitting panes and freezing panes
Ans – We can hold some portion of Excel while We scrolling through worksheet. Hold data are visible at all time during scrolling. It is useful in large size Excel we can hold the heading at all pages while we scroll the spreadsheet
If we freeze some data in our spreadsheet it shows at all time while we scroll the data. Steps for the freeze row or columns is follows
step 1 Click the row that should remain frozen on the top of spreadsheet while scrolling.
Steep 2 click on freeze panes.
Step 3 to freeze the row only click on freeze top row to freeze the column only then click freeze first column to lock more row beginning the row which are selected from and last row we want to freez , click the freeze panes to freeze more column Select the right off last column and click on freeze panes.
step 4 to Remove freezing features from data click on unfreeze panes.