DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
top middle of your worksheet
|
|
There aren’t worksheet names, just a workbook/file name.
|
|
bottom left of the worksheet
|
|
bottom right of the worksheet
|
Detailed explanation-1: -Whenever you open an Excel workbook, by default, Excel will take you to the Sheet1 worksheet. As you can see in the below image, the name of the worksheet ‘Sheet1’ is displayed on its sheet tab at the bottom of the windowpane.
Detailed explanation-2: -The status bar at the bottom of Office programs displays status on options that are selected to appear on the status bar. Many options are selected by default. If you want to customize the status bar, right-click it, and then click the options that you want.
Detailed explanation-3: -Hover the mouse pointer at the edge of the scrollbar until you see the double-headed arrow (see the figure). Click-and-drag the arrow to the right, until you see the complete tab name and any other tabs. The worksheet itself is hidden. To unhide a worksheet, right-click on any visible tab and then click Unhide.
Detailed explanation-4: -In Microsoft Excel, a sheet, sheet tab, or worksheet tab is used to display the worksheet that a user is currently editing. By clicking a worksheet tab (located at the bottom of the window), users may move between the various worksheets.
Detailed explanation-5: -To locate the last cell that contains data or formatting, click anywhere in the worksheet, and then press CTRL+END.