最新的Microsoft Excel 2013 - 77-420免費考試真題
CORRECT TEXT
Sort and Filter.
Apply a sort and a filter to the table.
Cell range B6:F29
Sort Column Zero Scores Order Largest to Smallest Column IDs Order Smallest to Largest Filter Hide students ids with no zero scores.
Sort and Filter.
Apply a sort and a filter to the table.
Cell range B6:F29
Sort Column Zero Scores Order Largest to Smallest Column IDs Order Smallest to Largest Filter Hide students ids with no zero scores.
正確答案:
Use the following steps to complete this task in
Explanation:
Step 1:Click a cell in the table.
Step 2:On the Home tab select the Sort & Filter button, and select Custom sort (needed to
sort on more than one column at a time).
Step 3:In the Sort dialog box select Sort by: Zero Scores, Order: Largest to Smallest, and click the Add Level button.
Step 4:Select then by: Ids, Order: Smallest to Largest, and click the OK button.
Step 5:Click the Zero Scores column header header arrow, select Number Filters, and clickDoes not Equal.
Step 6: In the Custom AutoFilter enter 0, and click OK The result will look like:
Explanation:
Step 1:Click a cell in the table.
Step 2:On the Home tab select the Sort & Filter button, and select Custom sort (needed to
sort on more than one column at a time).
Step 3:In the Sort dialog box select Sort by: Zero Scores, Order: Largest to Smallest, and click the Add Level button.
Step 4:Select then by: Ids, Order: Smallest to Largest, and click the OK button.
Step 5:Click the Zero Scores column header header arrow, select Number Filters, and clickDoes not Equal.
Step 6: In the Custom AutoFilter enter 0, and click OK The result will look like:
CORRECT TEXT
Formula Find the average score of all student ids without a zero homework score. Cell L2
Use Function AVERAGEIF
Range F7:F29
Criteria: "0"
Average_range: "Homework"
Formula Find the average score of all student ids without a zero homework score. Cell L2
Use Function AVERAGEIF
Range F7:F29
Criteria: "0"
Average_range: "Homework"
正確答案:
Use the following steps to complete this task in
Explanation:
Step 1:Click cell L2, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGEIF, and click OK.
Step 3:In the function Arguments dialog box click the reference button. Step 4:Click cell F7, shift-click cell F29, and press the enter key.
Step 5:In the Function Arguments dialog box in the Criteria box type: 0, in the Average_range box type: Homework, and click the OK button.
Explanation:
Step 1:Click cell L2, and the click the Insert Function Button.
Step 2: In the Insert Function dialog box select Category Statistical, select function AVERAGEIF, and click OK.
Step 3:In the function Arguments dialog box click the reference button. Step 4:Click cell F7, shift-click cell F29, and press the enter key.
Step 5:In the Function Arguments dialog box in the Criteria box type: 0, in the Average_range box type: Homework, and click the OK button.
CORRECT TEXT
Create a chart. To the right of the data Chart 3-D Clustered Column Exclude all filtered rows
Horizontal Axis Labels: "IDs" column in table
Series 1: "Zero Scores" column in table.
Create a chart. To the right of the data Chart 3-D Clustered Column Exclude all filtered rows
Horizontal Axis Labels: "IDs" column in table
Series 1: "Zero Scores" column in table.
正確答案:
Use the following steps to complete this task in
Explanation:
Step 1:Click in a cellin the data table, and then click on the INSERT tab.
b
Step 2:Click Insert Column Chart, and select 3-D Clustered Column.
Step 3:If necessary move the chart to the right of the table.
Step 4:Click the Select Data button.
Step 5:In the Select Data Source dialog box click the Switch Row/Column button, Deselect everything except IDs for Horizontal Axis Labels, deselect everything excepts Series1 for Legend Entries (series), and click OK.
Explanation:
Step 1:Click in a cellin the data table, and then click on the INSERT tab.
b
Step 2:Click Insert Column Chart, and select 3-D Clustered Column.
Step 3:If necessary move the chart to the right of the table.
Step 4:Click the Select Data button.
Step 5:In the Select Data Source dialog box click the Switch Row/Column button, Deselect everything except IDs for Horizontal Axis Labels, deselect everything excepts Series1 for Legend Entries (series), and click OK.