DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Right-click the tab to the right of the spot where you want to insert a worksheet, and then click Insert.
|
|
|
Click Insert on the Home menu tab, and then click Insert Sheet.
|
|
|
Click Worksheet on the Insert menu tab.
|
|
|
Click Worksheet in the Insert dialog box, and then click OK.
|
Detailed explanation-1: -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.
Detailed explanation-2: -Copy all the data on the sheet by pressing CTRL+C. Open the workbook in which you want to paste the data, then click the + in the status bar to add a new blank worksheet. Click the first cell in the new worksheet, then press CTRL+V to paste the data into that worksheet.
Detailed explanation-3: -Which of the following isn’t a part of a spreadsheet? Explanation: The answer is column number. There are no column numbers in a spreadsheet. Columns are represented using letters.
Detailed explanation-4: -On the worksheet, click a cell. Type the numbers or text that you want to enter, and then press ENTER or TAB. To enter data on a new line within a cell, enter a line break by pressing ALT+ENTER.