Question

what are the step required to insert a new worksheet before existing worksheet

Answer 1

Insert a new worksheetTo insert a new worksheet, do one of the following:To quickly insert a new worksheet at the end of the existing worksheets, click the Insert Worksheet tab at the bottom of the screen.To insert a new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cellsgroup, click Insert, and then click Insert Sheet.TIP: You can also right-click the tab of an existing worksheet, and then click Insert. On the General tab, click Worksheet, and then click OK.NOTE: To change the order of the worksheets in a workbook, click the tab of the worksheet that you want to move, and then drag it to the location that you want.Top of PageInsert multiple worksheets at the same timeHold down SHIFT, and then select the same number of existing sheet tabs of the worksheets that you want to insert in the open workbook.For example, if you want to add three new worksheets, select three sheet tabs of existing worksheets.On the Home tab, in the Cells group, click Insert, and then click Insert Sheet.TIP: You can also right-click the selected sheet tabs, and then click Insert. On the General tab, click Worksheet, and then click OK.To change the order of the worksheets in a workbook, click the tab of the worksheet that you want to move, and then drag it to the location that you want.Top of PageChange the default number of worksheets in a new workbookClick the File tab.What and where is the Microsoft Backstage Button?For more information about the Microsoft Backstage Button, see What and where is the Backstage?Under Excel, click Options.In the General category, under When creating new workbooks, in the Include this many sheets box, enter the number of sheets that you want to include by default when you create a new workbook.Click any other tab to return to your file.Top of PageInsert a new sheet that is based on a custom templateIf needed, create the worksheet template that you want to base a new worksheet on.How to create a worksheet templateSelect the worksheet that you want to use as a template.Click the File tab.Under Info, click Save As.In the File name box, type the name of the worksheet template.To create a custom worksheet template, type the file name that you want to use.To create the default worksheet template, type sheet.NOTE: Custom templates are automatically saved in the Templates folder. The default worksheet template, sheet.xltx or sheet.xltm, should be saved in the XLStart folder, which is usually C:\Program Files\Microsoft Office\Office14\XLStart.Do one of the following:On a computer that is running Windows Vista, in the list, click Excel Template or Excel Macro-Enabled Template.On a computer that is running Microsoft Windows XP, in the Save as type box, click Excel Template or Excel Macro-Enabled Template.Click Save.Right-click the sheet tab of a worksheet, and then click Insert.Double-click the template for the type of sheet that you want.Top of PageRename a worksheetOn the Sheet tab bar, right-click the sheet tab that you want to rename, and then click Rename Sheet.Select the current name, and then type the new name.TIP: You can include the name of the sheet when you print the worksheet.How to print sheet namesOn the Insert tab, in the Text group, click Header & Footer.In the Page Layout View, click the location where you want the sheet name to appear.In the Header & Footer elements group, click Sheet Name  .Top of PageDelete one or more worksheetsSelect the worksheet or worksheets that you want to delete.How to select worksheetsTo selectDo thisA single sheetClick the sheet tab.If you don't see the tab that you want, click the tab scrolling buttons to display the tab, and then click the tab.Two or more adjacent sheetsClick the tab for the first sheet. Then hold down SHIFT while you click the tab for the last sheet that you want to select.Two or more nonadjacent sheetsClick the tab for the first sheet. Then hold down CTRL while you click the tabs of the other sheets that you want to select.All sheets in a workbookRight-click a sheet tab, and then click Select All Sheets on the shortcut menu.Tip    When multiple worksheets are selected, [Group] appears in the title bar at the top of the worksheet. To cancel a selection of multiple worksheets in a workbook, click any unselected worksheet. If no unselected sheet is visible, right-click the tab of a selected sheet, and then click Ungroup Sheets on the shortcut menu.On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Sheet.TIP: You can also right-click the sheet tab of a worksheet or a sheet tab of any selected worksheets that you want to delete, and then clickDelete Sheet.

Answer 2

Answer:

Call Us For Solved  :: Assignment || Notes || Practical Files

NIOS / CBSE / IGNOU / JNU / DU / DU-SOL / and Others

Call us  : 9953056766

Mission Guide Institute  

www.missionguide.in

Explanation:

Ques 5 : (a) What are the steps required to insert a new worksheet before existing worksheet?

(b)  

Ans: (a)  

Insert a new worksheet

To insert a new worksheet, do one of the following:

To quickly insert a new worksheet at the end of the existing worksheets,  

click the Insert Worksheet tab at the bottom of the screen.

To insert a new worksheet in front of an existing worksheet,  

select that worksheet and then, on the Home tab, in the Cellsgroup,  

click Insert, and then click Insert Sheet.

TIP: You can also right-click the tab of an existing worksheet, and then click Insert. On the General tab, click Worksheet, and then click OK.

(b) THERE ARE 5 TYPES OF TAB STOPS

LEFT TAB

RIGHT TAB

CENTER TAB

DECIMAL TAB

BAR TAB

Explanation:

left tab: it left alings the text at the tab stop

right tab: it right alings the text at the tab stop

center tab: it centers the text around the tab stop

decimal tab: the tab alings the decimal numbers using the decimal point

bar tab: it draws a vertical line on the document.