77-420 Online Practice Questions and Answers

Correct Answer: 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

Correct Answer: 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.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click the File menu.

Step 2:Select Info (if necessary) and click Show All Properties,

Step 3:In the Subject textbox type: HomeWork and click theReturn button.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click cell B3.

Step 2:Shift-click cell B25

Step 3:Right-click somewhere in the B3-B25 cell range, and choose Format Cells from the context menu.

Step 4:In the Format Cells dialog box click the Alignment Tab, change Horizontal: to Right (Indent), change Indent: to 1, and then click the OK button.

Correct Answer: 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.

Correct Answer: 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.

Correct Answer: 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.

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.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Open the correct worksheet (Summary Worksheet).

Step 2:Click in cell B5.

Step 3:Click on the insert function button.

Step 4:In the Insert Function Dialog box select the Category Text, scroll down and click on the function RIGHT, and click OK.

Step 5:In the Function Arguments Dialog box in the Text box type B2, in the Num_chars type 16, and click OK.

Correct Answer: 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:

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click on the New sheet button (in the left bottom corner).

Step 2:Right-click on the new worksheet, and click Rename from the context menu.

Step 3:Type: Section 5 Step 4:Press the enter key.

Correct Answer: 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 and 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 Answer: 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.

Correct Answer: 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.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1: Open the correct worksheet (Section 3 Worksheet)

Step 2: Click on a cell in row 2.

Step 3: Right-click in the cell, and select Insert from the context menu.

Step 4: In the Insert Dialog box select Entire row, and click OK.

Correct Answer: Use the following steps to complete this task in explanation:

Step 1:Click the PAGE LAYOUT tab, click Colors, scroll down and select Slipstream.