NIOS Class 12 Data Entry Operations Chapter 7 Formatting Worksheets

Join Telegram channel

Follow us:

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

Q. 1. What is Format Painter?

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 you want to copy. Click the Format Painter button in the clipboard group of Home tab (notice that your pointer now has a paintbrush beside it). Highlight the cells you want to apply the same formatting. The formatting will change accordingly.

Q. 2. What do you mean by Auto Format?

Ans. Excel’s Auto Format feature uses table styles, which are predefined collections of number formats, fonts, cell alignments, patterns, shading, column widths, and row heights to have a polished look of ranges of cells you specify.

Q. 3. Write down the steps to reorder the slides in MS-Power Point.

Ans. To reorder a slide in Slide Sorter View, simply click on the slide you wish to move and drag it to the new location. In Normal or Outline View, click on the slide in the slide pane and move and drag the slide to a new location.

Q. 4. Write the steps to protect and unprotect the worksheets.

Ans. To protect worksheets: You can protect your worksheet against unauthorized editing. For this you can give password protection to your worksheet contents.

Steps to protect worksheet:

(i) Select Home tab and then click Format in cells group.

(ii) Choose Protect sheet from Drop Down Menu. Protect sheet dialog box will appear. Enter password to protect sheet. Reenter same password in the confirm password dialog box.

Steps to unprotect worksheet:

(i) Select Home tab and then Click Format in cells group.

(ii) Choose Unprotect sheet from Drop Down Menu. Unprotect sheet dialog box will appear. Enter password to unprotect sheet. Password must be same as used for protecting the worksheet. Press OK.

Q. 5. Write the steps to add auto format style to your Excel worksheet.

Ans. You can Add the auto format styles by following these steps:

(i) Highlight the cells that will be formatted.

(ii) Select Home tab, Style group, Format as Table from the Ribbon. It will show many predefined Table formats.

(iii) Select any one format.

(iv) It will show a dialog box. Check My Table has headers check box and click OK.

Q. 6. What do you mean by Cell Style?

Ans. Excel 2007 provides cell styles to quickly format a cell by choosing from predefined styles. Styles help to give a professional look to your worksheets. In Excel, all styles are cell styles. However, a defined style can be applied to an entire worksheet. Cell styles can include any of the formatting that can be applied to a cell using the options available.

Q. 7. Write the steps to apply Cell Style to your Excel worksheet.

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

(ii) Choose Home tab.

(iii) From Styles group, Click on Cell Styles.

Q. 8. Write any five effects available in the Cell Styles tab.

Ans. (i) Comma: Adds commas to the number and two digits beyond a decimal point.

(ii) Comma [0]: Comma style that rounds to a whole number.

(iii) Currency: Formats the number as currency with a dollar sign, commas, and two digits beyond the decimal point.

(iv) Currency [0]: Currency style that rounds to a whole number.

(v) Percent: Changes the number to a percent and adds a percent sign.