NIOS Class 10 Data Entry Operation Chapter 7 Formatting Worksheets

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

NIOS Class 10 Data Entry Operation Chapter 7 Formatting Worksheets

Join Telegram channel

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 10 Data Entry Operation Chapter 7 Formatting Worksheets, NIOS Secondary Course Data Entry Operation Solutions for All Chapters, You can practice these here.

Formatting Worksheets

Chapter: 7


1. Write True or False for the following statements.

(a) Format cells dialog box offers you more options 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.


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

Ans: Format Painter is a tool that allows you to copy the format you use in a section of your Word document and apply it to another area. This feature is similar to the copy and paste keyboard shortcut, but it duplicates visual formatting instead of text content.

Use Format Painter to quickly apply the same formatting, such as colour, font style and size, or border style, to multiple pieces of text or graphics. With format painter, you can copy all of the formatting from one object and apply it to another one—think of it as copying and pasting for formatting.

2. Explain different preset styles available in Excel.

Ans: In Microsoft Excel, there are several preset styles available for formatting cells, ranges, tables, and charts. These styles help users quickly apply consistent and professional- looking formatting to their data. 

Some of the common preset styles in Excel include:

(i) Title.

(ii) Heading 1, Heading 2, Heading 3, etc.

(iii) Total.

(iv) Good, Bad, and Neutral (for conditional formatting).

(v) Currency.

(vi) Percent.

(vii) Comma.

(viii) Date.

(ix) Time.

(x) Table styles (various predefined formats for tables).

(xi) Chart styles (various predefined formats for charts).

(xii) Accent 1, Accent 2, Accent 3, etc. (for colour schemes).

(xiii) Linked Cell (for data linked to external sources).

(xiv) These preset styles can be accessed from the “Styles” group on the “Home” tab in Excel.

3. Explain steps to create a new style.

Ans: You can create a custom style by selecting the text you want to use as a style, going to the “Styles” or “Format” menu, and choosing the option to create a new style. In the dialog box that appears, you can specify the formatting attributes you want to apply and give the style a name.

(i) Right-click the text on which you want to base a new style.

(ii) In the mini toolbar that appears, click Styles, and then click Create a Style.

(iii) In the Create New Style from Formatting dialog box, give your style a name and click OK.

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

Ans: (i) Open the workbook that contains the cell styles that you want to copy.

(ii) Open the workbook that you want to copy the styles into.

(iii) On the Home tab, in the Styles group, click the More button next to the cell styles box that contains previews of styles. 

(iv) Click Merge Styles.

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

Ans: There are six tabs in the Format Cells dialog box: Number, Alignment, Font, Border, Patterns, and Protection. The following sections describe the settings available in each tab.

(i) Alignment tab: These options allow you to change the position and alignment of the data with the cell. The Format Cells dialog box offers you more options than the alignment buttons on the Formatting toolbar. For example, you can change the orientation of the text.

(ii) Font tab: All of the font attributes are displayed in this tab including font face, size, style, and effects. Using Formatting toolbar you can bold, italicise, and underline your cell entries. For even more formatting options you can use the Format Cells dialog box.

(iii) Border and Pattern tabs: You can use the Formatting toolbar for adding borders, cell shading, and font colour. These buttons are actually tear-off palettes. When you click on the picture portion of the button, the format of the picture displayed will be applied to the contents of the cell(s) you have selected in the worksheet. You 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.

Follow these steps to apply a border and colour to a selection sing the options in the Format Cells dialog box.

(a) Select Format → Cells to display the Format Cells dialog box.

(b) Select the Border tab.

(c) In the Presets area, choose None, Outline, or Inside to specify the location for the border.

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: The different features available in below: 

(a) Number tab: The data type can be selected from the options on this tab. Select the range you would like to format and click on one of the Category number as shown in  to apply that style to your numbers. Select General if the cell contains text and number and it does not have any specific number format. If you select Number Category you can represent numbers as integers, decimals with number of decimal as option etc. For example, if you want to restrict the number of decimals.

(b) Border tab: The Border tab in the Properties dialog box lets you modify table borders. It appears when you right-click a table and then select Properties. This tab contains controls for: Lines and Curves.

(c) The Format Cells dialog box appears with the Patterns tab on top, as shown on the following page. You can click the down arrow to the right of the Fill Colour button on the Formatting toolbar and click a shade of grey or a colour from the colour palette that appears. colours. 4 Click the Pattern down arrow.

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: When columns are hidden, they are not deleted and they will only be hidden in the current View. Information in hidden columns can still be seen when you expand a row.

(b) Unhide a column:  To unhide column A, right-click the column B header or label and pick Unhide Columns. To unhide row 1, right-click the row 2 header or label and pick Unhide Rows. 

Tip: If you don’t see Unhide Columns or Unhide Rows, make sure you’re right-clicking inside the column or row label.

(c) Hide a worksheet: (i) Right click on the sheet tab which you want to hide.

(ii) Choose Hide option from the context menu, as shown.

(d) Unhide a worksheet: To unhide the hidden sheet, right click on 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: In Microsoft Excel, you can resize worksheet columns or rows by following these steps:

(i) To Resize Columns:

(a) Select the column(s) you want to resize.

(b) Go to the “Home” tab on the ribbon menu.

(c) In the “Cells” group, click on the “Format” dropdown menu.

(d) Choose “Column Width…” option.

(e) Enter the desired width in the “Column Width” dialog box and click “OK”.

(ii) To Resize Rows:

(a) Select the row (s) you want to resize.

(b) Go to the “Home” tab on the ribbon menu.

(c) In the “Cells” group, click on the “Format” dropdown menu.

(d) Choose “Row Height…” option.

(e) Enter the desired height in the “Row Height” dialog box and click “OK”.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top