DATABASE FUNDAMENTALS
HOW TO INSERT HEADERS FOOTERS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Scenario You create a worksheet with multiple columns of data. One column stores inventory using a standard format combining Region and Part Number, like 1RFDXL. The region number is always designated by a single digit at the front of the value. The part number is the following letters. You want to do a search across regions for a single part number.Based on the scenario above, which text do you enter into the Find Text field?
|
|
?RFDXL
|
|
|
1*
|
|
|
|
|
|
#1RFDXL
|
|
|
!RFDXL!
|
Explanation:
Detailed explanation-1: -Open the workbook (A) with the pivot table that has the custom style applied. Press the Ctrl key, and drag a copy of the pivot table sheet from workbook A, into the workbook B. The custom style is now copied into the new workbook, and you can see it in the PivotTable Style palette.
Detailed explanation-2: -Double-click the cell that contains the data that you want to move or copy. You can also edit and select cell data in the formula bar. Select the row or column that you want to move or copy. In the cell, click where you want to paste the characters, or double-click another cell to move or copy the data.
There is 1 question to complete.