USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
cell styles
|
|
|
form controls
|
|
|
macros
|
|
|
themes
|
Detailed explanation-1: -In order to make a check box in Excel, you need to go to Developer Tab—> Controls—> Insert—> Form Controls—> Check Box. Now, click on the cell where you want to place the checkbox; you can position the checkbox by dragging it.
Detailed explanation-2: -On the Insert tab, click Header & Footer. Excel automatically changes to Page Layout view. On Header & Footer tab, click either the Header or Footer, and then select the page number format you want. Header page numbers appear at the top of the printed page, and footer page numbers appear at the bottom.
Detailed explanation-3: -Located just above the Ribbon, the Quick Access Toolbar lets you access common commands no matter which tab is selected. By default, it includes the Save, Undo, and Repeat commands.
Detailed explanation-4: -To insert a new worksheet in front of an existing worksheet, select that worksheet and then, on the Home tab, in the Cells group, 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.