USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
<Ctrl+X>
|
|
<Alt+V>
|
|
<Ctrl+B>
|
|
<Ctrl+A>
|
Detailed explanation-1: -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. Repeat the arrow and Ctrl+Space steps to select additional sheets. Right-click a sheet tab, and then click the Select All Sheets option.
Detailed explanation-2: -After entering the text you want to find, select Workbook in the “Within” drop-down list. Then, you can click Find Next to go through all matches, or click Find All to see all matches. You can use the keyboard shortcut Ctrl + F to open the Find and Replace box.
Detailed explanation-3: -Selecting means making a part or parts of the worksheet active. You can select cells, groups of cells, rows, columns, graphical objects, column and row headings. In general, you must select a cell or object before changing anything about it.