USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
AutoFill
|
|
|
Filter
|
|
|
Find and Replace
|
|
|
Sort
|
Detailed explanation-1: -Press the Ctrl + H shortcut to open the Replace tab of the Excel Find and Replace dialog. Alternatively, go to the Home tab > Editing group and click Find & Select > Replace… If you’ve just used the Excel Find feature, then simply switch to the Replace tab.
Detailed explanation-2: -Copy a tab in Excel using the ribbon. The ribbon contains all the features available in Excel, you just need to know where to look :) To copy a sheet, go to the Home tab > Cells group, click Format, and then click Move or Copy Sheet: The Move or Copy dialog box appears, and you follow the same steps as described above.
Detailed explanation-3: -Locate the last cell that contains data or formatting on a worksheet. To locate the last cell that contains data or formatting, click anywhere in the worksheet, and then press CTRL+END.