Q1. CORRECT TEXT
Apply a style to the chart.
Chart.
Chart Styles Style 7
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click on the chart.
Step 2:On the Design tab, in the Chart Styles group, click theStyle 7chart style.
Q2. CORRECT TEXT
Modify the cell format to date.
Cell range C2:S2
Type: 14-Mar
Locale (location): English (United States)
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1: Open the correct worksheet(Section 3 Worksheet).
Step 2: Click in cell A2.
Step 3: Press down the Shift key and click in cell S2.
Step 4:On the.Home.tab, under.Format, choose Format Cells.
Step 5: In the Format Cells dialog box, choose Date, 14-Mar, and Locale (location): English (United States). Click OK.
Q3. 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.
Answer: Use the following steps to complete this task in explanation:
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.
Q4. CORRECT TEXT
Add conditional formatting.
Color Scales: Green –White-Red Color Scale
Midpoint: Percentile, "70"
Maximum: Number, "25"
Answer: Use the following steps to complete this task in explanation:
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.
Q5. CORRECT TEXT
Apply a cell style
Cell range A2:S2
Style 40% - Accent3
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1: Open the correct worksheet(Section 3 Worksheet).
Step 2: Click in cell A2.
Step 3: Press down the Shift key and click in cell S2.
Step 4:On the.Home.tab, under.Format, scroll down until you see 40% . Accent3, and click
on it.
Q6. CORRECT TEXT
Create a hyperlink to another worksheet.
Cell A2.
Cell reference "A3"
Sheet reference "Section 3" worksheet.
Answer: Use the following steps to complete this task in explanation:
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.
Q7. CORRECT TEXT
Insert the instructor's name for column B.
Cell B5.
Use Function RIGHT
Text: B2
Absolute reference
Num_chars: "16"
Answer: Use the following steps to complete this task in explanation:
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.
Q8. CORRECT TEXT
Modify the cell format to date.
Cell range C2:S2
Type: 14-Mar
Locale (location): English (United States)
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1: Open the correct worksheet(Section 3 Worksheet).
Step 2: Click in cell A2.
Step 3: Press down the Shift key and click in cell S2.
Step 4:On the.Home.tab, under.Format, choose Format Cells.
Step 5: In the Format Cells dialog box, choose Date, 14-Mar, and Locale (location): English (United States). Click OK.
Q9. 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"
Answer: Use the following steps to complete this task in explanation:
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).
Q10. CORRECT TEXT
Configure page layout options.
Cell range B3:S25.
Set Print Area.
Enable the Gridlines Print option.
Answer: Use the following steps to complete this task in explanation:
Explanation:
Step 1:Click in cell B3, and then shift-click in cell S25.
Step 2:On the Page Layout tab, in the Page Setup group, click Print Area, and then click
Set Print Area.
Step 3:Still in the Page Layout tab, Enable the Gridlines Print option.