IT認証試験問題集
毎月、ITshikenは1500人以上の受験者が試験準備を助けて、試験に合格するために受験者にご協力します
 ホームページ / 77-420 問題集  / 77-420 問題練習

Microsoft 77-420 問題練習

Excel 2013 試験

最新更新時間: 2020/11/14,合計24問。

いい買物の日:77-420 最新真題を買う時、日本語版と英語版両方を同時に獲得できます。

実際の問題集を練習し、試験のポイントを了解し、テストに申し込むするかどうかを決めることができます。

さらに試験準備時間の35%を節約するには、77-420 問題集を使用してください。

 / 2

Question No : 1
CORRECT TEXT
Modify the text in the title. Cell A1.
Text "Math 1080 - Section 3 Assignments"

正解: Use the following steps to complete this task in
explanation:
Step 1:Click cell A1 Step 2:Change the text by typing to: Math 1080 - Section 3 Assignments

Question No : 2
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.

正解: 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.


Question No : 3
CORRECT TEXT
Formula. Find the average of each student's homework scores. Cell range C7:C29 Use Function AVERAGE Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"

正解: Use the following steps to complete this task in
explanation:
Step 1:Click cell C7, and the click the Insert Function Button.



Step 2:In the Insert Function dialog box select Category Statistical, select function AVERAGE, and click OK.



The function Arguments Dialog box appears:



Step 3:Click on the Section 3 tab (left bottom part of the window).



Step 4:Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.



Step 5:Copy cell C7 downwards until cell C29.



Result will be like:


Question No : 4
CORRECT TEXT
Add conditional formatting.
Color Scales: Green CWhite-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"

正解: Use the following steps to complete this task in
explanation:
Step 1:Click cell C3 Step 2:Shift-Click cell S25. Step 3:On the Home tab, under Format, choose Conditional Formatting, and choose New Rule...



Step 4:In the New Formatting Rule dialog box set Format Style to: 3-Color Scale, and set Minimum Color to Green.



Step 5:In the same dialog box set Midpoint type to Percentile, set Midpoint Value to 70, and set Midpoint Color to White. Also set Maximum Type to Number, Maximum value to 25, and Maximum Color to Red. Finally click OK.


Question No : 5
CORRECT TEXT
Rename the title of the chart. Chart
Text "All Zero Scores"

正解: Use the following steps to complete this task in
explanation:
Step 1:Click on the Chart. Step 2:Click on the Chart title. Step 3:Changeby typingthe title to:All Zero Scores


Question No : 6
CORRECT TEXT
Create a hyperlink to another worksheet. Cell A2. Cell reference "A3" Sheet reference "Section 3" worksheet.

正解: Use the following steps to complete this task in
explanation:
Step 1:Click cell A2. Step 2:On the Insert tab, in the Links group, click Hyperlink.



Step 3:In the Insert Hyperlink dialog box, in the Type the cell reference: type A3, select Cell Reference 'Section 3', and click OK.


Question No : 7
CORRECT TEXT
Apply a style to the chart. Chart. Chart Styles Style 7

正解: Use the following steps to complete this task in
explanation:
Step 1:Click on the chart.
Step 2:On the Design tab, in the Chart Styles group, click theStyle 7chart style.


Question No : 8
CORRECT TEXT
Crop the picture.
Books.jpg
Crop to Shape Snip Same Side Corner Rectangle.

正解: Use the following steps to complete this task in
explanation:
Step 1:Click on the picture. Step 2:In the Format menu (which is displayedautomatically) click the Crop Command, select Crop to Shape, and click Snip Same Side Corner Rectangle.


Question No : 9
CORRECT TEXT
Add a header and the date for each of the columns (assignments) in the range.
Cell B2.
Text "Date".
Cell Range C2: S2
Text: "22-Aug, 29-Aug,…12-Dec"

正解: Use the following steps to complete this task in
explanation:
Step 1:Click Cell B2. Type the text: Date Step 2: Click cell C2. Type the text: 22-Aug Step 3: Click cell D2. Type the text: 29-Aug Step 3:Click cell C2, then shift-click cell D2.



Step 4:Copy until cell S2(by dragging from cell D2 to cell S2).


Question No : 10
CORRECT TEXT
Formula. Insert text using a formula Cell K2 Use Function CONCATENATE Text1 : "Students with no " Text 2: header of column F Absolute Reference

正解: Use the following steps to complete this task in
explanation:
Step 1:Click K2andClick on the insert function button. Step 2:Select Category: Text, the CONCATENATE function, and click OK.



Step 3:In the Function Arguments dialog box in the Text1 box type: Students with no , and then click the Text2 reference button, and click on the header of column F in the worksheet, press the enter Key



Step 4:Press the OK button in the Function Arguments dialog box.

Question No : 11
CORRECT TEXT
Insert a picture.
To the right of the data
File source Books.jpg

正解: Use the following steps to complete this task in
explanation:
Step 1:Click in a cell to the right of the data. Step 2:Click the INSERT tab, and then the Pictures command.



Step 3:From the Insert Picture dialog box select the Books.jpg file.

Question No : 12
CORRECT TEXT
Create a table and modify the table styles. Cell range B6:F29 Table Style Medium 4 Enable the First Column Style

正解: Use the following steps to complete this task in
explanation:
Step 1:Click cell B6, and Shift-click cell F29. Step 2:Click theInserttab, and click the Table button.



Step 3:In the Create Table dialog box click OK. Step 4:In the Design tab, Table Styles select Table Style Medium 4.






Step 5:In the Design tab enable First Column.


Question No : 13
CORRECT TEXT
Modify the text in the title. Cell A1.
Text "Math 1080 - Section 3 Assignments"

正解: Use the following steps to complete this task in
explanation:
Step 1:Click cell A1 Step 2:Change the text by typing to: Math 1080 - Section 3 Assignments

Question No : 14
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.

正解: 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.


Question No : 15
CORRECT TEXT
Formula. Find the average of each student's homework scores. Cell range C7:C29 Use Function AVERAGE Number 1: all homework for each student on "Section 3" worksheet "22-Aug 12-Dec"

正解: Use the following steps to complete this task in
explanation:
Step 1:Click cell C7, and the click the Insert Function Button.



Step 2:In the Insert Function dialog box select Category Statistical, select function AVERAGE, and click OK.



The function Arguments Dialog box appears:



Step 3:Click on the Section 3 tab (left bottom part of the window).



Step 4:Locate the data for the first student. This well be cell range C2 to N2. Click C2 and then Shift-click cell N2. Then click the OK button.



Step 5:Copy cell C7 downwards until cell C29.



Result will be like:


 / 2