DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
true
|
|
false
|
|
Either A or B
|
|
None of the above
|
Detailed explanation-1: -Press and hold down the Ctrl key, and click the worksheet tabs you want to group. Tip: If you want to group consecutive worksheets, click the first worksheet tab in the range, press and hold the Shift key, and click the last worksheet tab in the range.
Detailed explanation-2: -Click the tab for the first sheet, then hold down CTRL while you click the tabs of the other sheets that you want to select. By keyboard: First, press F6 to activate the sheet tabs. Next, use the left or right arrow keys to select the sheet you want, then you can use Ctrl+Space to select that sheet.
Detailed explanation-3: -A workbook is a spreadsheet program file that you create in Excel. A workbook contains one or more worksheets. A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows.
Detailed explanation-4: -Moving or Copying Multiple Sheets Simply select the sheets you want to move or copy before dragging them over. You can select multiple sheets by holding down the Shift or Ctrl key while clicking on the sheets you want to work with.
Detailed explanation-5: -Click the Insert Worksheet tab at the bottom of the screen. Press and hold the CTRL key, and then click Sheet1, Sheet2, and so on till you finish selecting all your worksheets.