77-420試験無料問題集「Microsoft Excel 2013 認定」
CORRECT TEXT
Hide columns.
Column A.
Columns O through R.
Hide columns.
Column A.
Columns O through R.
正解：
Use the following steps to complete this task in
Explanation:
Step 1:Right-click on the A column header, and select Hide from the context menu.
Step 2:Click on the O columns header, and then Shift-click on the R Column Header. Step 3:Right-click in one of the cells in the high-lighted area, and select Hide from the Context menu.
Explanation:
Step 1:Right-click on the A column header, and select Hide from the context menu.
Step 2:Click on the O columns header, and then Shift-click on the R Column Header. Step 3:Right-click in one of the cells in the high-lighted area, and select Hide from the Context menu.
CORRECT TEXT
Insert data from a text file.
Cell A1.
File source Autumn.txt
Tab-delimited
Insert data from a text file.
Cell A1.
File source Autumn.txt
Tab-delimited
正解：
Use the following steps to complete this task in
Explanation:
Step 1:Click cell A1.
Step 2:Click the Data tab, and click the From Text button.
The Text Import Wizard starts. Step 3:Make sure Delimited is select, and click Next.
Step 4:Make sure Delimiters: Tab is selected. Then click Next.
Step 5:Finish the wizard by click the Finish Button. Step 6: Confirm with OK in the Import Data dialog box.
Explanation:
Step 1:Click cell A1.
Step 2:Click the Data tab, and click the From Text button.
The Text Import Wizard starts. Step 3:Make sure Delimited is select, and click Next.
Step 4:Make sure Delimiters: Tab is selected. Then click Next.
Step 5:Finish the wizard by click the Finish Button. Step 6: Confirm with OK in the Import Data dialog box.
CORRECT TEXT
Rename a table.
Cell range B6:F29
Name: "Overview"
Rename a table.
Cell range B6:F29
Name: "Overview"
正解：
Use the following steps to complete this task in
Explanation:
Step 1:Click cell B6, and shift-click cell F29.
Step 2: Click the Name box at the left end of the formula bar.
Step 3: Type: Overview. Press ENTER.
Explanation:
Step 1:Click cell B6, and shift-click cell F29.
Step 2: Click the Name box at the left end of the formula bar.
Step 3: Type: Overview. Press ENTER.