NIOS Class 12 Data Entry Operations Chapter 7 Formatting Worksheets

NIOS Class 12 Data Entry Operations Chapter 7 Formatting Worksheets Solutions to each chapter is provided in the list so that you can easily browse throughout different chapters NIOS Class 12 Data Entry Operations Chapter 7 Formatting Worksheets and select need one. NIOS Class 12 Data Entry Operations Chapter 7 Formatting Worksheets Question Answers Download PDF. NIOS Study Material of Class 12 Data Entry Operations Notes Paper 336.

NIOS Class 12 Data Entry Operations Chapter 7 Formatting Worksheets

Also, you can read the NIOS book online in these sections Solutions by Expert Teachers as per National Institute of Open Schooling (NIOS) Book guidelines. These solutions are part of NIOS All Subject Solutions. Here we have given NIOS Class 12 Data Entry Operations Chapter 7 Formatting Worksheets, NIOS Senior Secondary Course Data Entry Operations Solutions for All Chapter, You can practice these here.

Formatting Worksheets

Chapter: 7

DATA ENTRY OPERATIONS

INTEXT QUESTIONS

1. Write True or False for the following statements:

(a) Format cells dialog box offers you more option than the alignment buttons on the formatting toolbar.

Ans. True.

(b) Click Edit to preview the formatting changes on the worksheet.

Ans. False.

(c) If the field is a time select time from the category box.

Ans. True.

(d) To unhide the column select format column unhide from the menu bar.

Ans. True.

(e) Choose Edit style to display the style dialog box.

Ans. False.

2. Fill in the blanks:

(a) Modify the attributes by clicking the _____________ button.

Ans. Modify.

(b) In Excel all styles are _____________.

Ans. cell styles.

(c) Hiding columns or rows will help you to ______________ unwanted changes.

Ans. Prevent/protect worksheet from.

(d) If the tool bar is not already visible on the screen select ______________.

Ans. view toolbar formatting.

(e) To change the data format select the _____________ from the format cells window.

Ans. number tab.

TERMINAL QUESTIONS

1. What is Format Painter? When do you think Format Painter is useful in Excel?

Ans. Format Painter: A handy feature on the standard toolbar for formatting text is the Format Painter.

If we have formatted a cell with a certain font style, date format, number format, border and other formatting options and want to format another cell or group of cells the same way, place the cursor within the cell containing the formatting we want to copy. Click the Format Painter button in the clipboard group of Home tab (notice that our pointer now has a paintbrush be side it). High light the cells we want to apply the same formatting. The formatting will change accordingly.

2. Explain different preset styles available in Excel.

Ans. Choose any of the following options for the border:

(i) In the Border area, click on any of the buttons to toggle its border.

(ii) Choose the border’s line style in the Style area.

(iii) If necessary, select a colour for the border in the Color Palette.

3. Explain steps to create a new style.

Ans. (i) Select the cells to apply a style on.

(ii) Choose Home tab. From Styles group, Click on Cell Styles. Here we have chosen Heading 1. See the effect.

4. How to copy styles from one open workbook file to another?

Ans. A handy feature on the standard toolbar for formatting text is the Format Painter. If you have formatted a cell with a certain font style, date format, number format, border and other formatting options and want to format another cell or group of cells the same way, place the cursor within the cell containing the formatting we want to copy. Click the Format Painter button in the clipboard group of Home tab (notice that our pointer now has a paintbrush be side it). High light the cells we want to apply the same formatting. The formatting will change accordingly.

Also, to copy the formatting to many groups of cells, double-click the Format Painter button. The format painter remains active until we press the ESC key to turn it off.

5. What are the different tabs available in Format Cells dialog box?

Ans. (i) Number Tab.

(ii) Alignment Tab.

(iii) Font Tab.

(iv) Border and Pattern Tabs.

6. What are the different features available in:

(a) Number tab.

(b) Border tab. and

(c) Patterns tab in Excel’s Format Cells dialog box?

Ans. (a) Number Tab: The data type can be selected from the options on this tab. Select the range we would like to format and click on one of the Category number as shown in figure to apply that style to our numbers. Select General if the cell contains text and number and it does not have any specific number format. If we select Number Category we can represent numbers as integers, decimals with number of decimal as option etc. For example, if we want to restrict the number of decimals to 2, choose Number Category and then decimal places as 2. We may try the other options in our computer.

(b) Alignment Tab: We can use the Formatting toolbar for adding borders, cell shading and font colour. These buttons are actually tear-off palettes. When we click on the picture portion of the button, the format of the picture displayed will be applied to the contents of the cell (s) we have selected in the worksheet. We can change the picture displayed on the button by clicking on the button’s small drop-down arrow to access the palette of samples from which to choose.

(c) Patterns tab: We can use the Formatting toolbar for adding borders, cell shading and font colour. These buttons are actually tear-off palettes. When we click on the picture portion of the button, the format of the picture displayed will be applied to the contents of the cell (s) we have selected in the worksheet. We can change the picture displayed on the button by clicking on the button’s small drop-down arrow to access the palette of samples from which to choose.

7. How do you:

(a) Hide a column.

(b) Unhide a column.

(c) Hide a worksheet

(d) Unhide a worksheet?

Ans. (a) Hide a column: To hide a column, follow these steps:

(i) Select the column you want to hide by clicking on the column header. Say you want to hide column C, i.e., column representing the marks in chemistry.

Right click on the column to hide and click on the Hide option.

See the following figure. Column C is not visible.

(b) Unhide Selected Column:

To unhide the column follow these steps:

(i) Select the visible range of columns that includes the hidden column (s).

(ii) Now Right Click on the selected Columns. Select Unhide from the pop-up menu.

(iii) We can observe, the Column C is visible again.

We can follows the some procedure to hide and unhide rows.

(c) Hiding a worksheet:

(i) Right click on the sheet tab which we want to hide.

(ii) Choose Hide option from the context menu, as shown figure below:

(d) Unhide a worksheet: To unhide the hidden sheet, right click on the any of the visible sheets. Unhide Dialog will appear. Choose the sheet from the list to unhide. In our case only one sheet is displayed to unhide.

8. How do you resize your worksheet columns or rows?

Ans. Set a column to a specific width:

(i) Select the column or columns that we want to change.

(ii) On the Home tab, in the Cells group, click Format.

(iii) Under Cell Size, click Column Width.

(iv) In the Column width box, type the value that we want.

OTHER IMPORTANT QUESTIONS AND ANSWERS