simnet 2

Add an element to the center section of the header to display just the current date (not Dec 2, which is the worksheet name).

?

This worksheet has validation rules applied. Find and circle cells that violate those rules.

In the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Data Validation button arrow. In the Data Validation menu, you clicked the Circle Invalid Data menu item.

Apply data validation rules to the selected cells to allow only decimal numbers between 2.5 and 4.0. Do not allow blanks.

In the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Data Validation button arrow. In the Data Validation menu, you clicked the Data Validation... menu item. Inside the Data Validation dialog in the Allow drop-down, you selected Decimal. Inside the Data Validation dialog, you typed 2.5 in the Minimum: input, typed 4.0 in the Maximum: input, unchecked the Ignore blank check box, and clicked the OK button.

Use the Flash Fill command to autofill the remaining cells in this column with the pattern from cell F2.

In the Data Ribbon Tab in the Data Tools Ribbon Group, you clicked the Flash Fill button.

Add another data series to the chart to represent gross profit. Use the value of cell A2 as the series name and cells B2:D2 as the series values. Do not rebuild the chart from scratch.

In the Design Ribbon Tab in the Data Ribbon Group, you clicked the Select Data button. Inside the Select Data Source dialog, you clicked the Add button. You clicked cell A2. Inside the Edit Series dialog, you pressed Backspace. You clicked cell B2. Inside the Edit Series dialog, you clicked the OK button. Inside the Select Data Source dialog, you clicked the OK button.

Clear the selected Sparklines from the worksheet.

In the Design Ribbon Tab in the Group Ribbon Group, you clicked the Clear button arrow, clicked the Clear button.

Add markers for just the highest values in this Sparkline group.

In the Design Ribbon Tab in the Show Ribbon Group, you checked the High Point check box.

Modify the chart so the Owner Draw data series is plotted along the secondary axis.

In the Design Ribbon Tab in the Type Ribbon Group, you clicked the Change Chart Type button. Inside the Change Chart Type dialog, you checked the Series 2 - Secondary Axis check box, clicked the OK button.

The Anne Cole data point has been selected for you. Rotate the pie chart exactly 200° so this data point appears at the left side of the chart near the legend.

In the Format Ribbon Tab in the Current Selection Ribbon Group, you clicked the Format Selection button. Inside the Format Data Point dialog from the Trendline options list, you clicked the Series Options list item, typed 200 in the Angle of first slice input, and pressed the Enter key.

Apply conditional formatting to the selected cells using the red gradient fill data bar.

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. In the Conditional Formatting menu in the Data Bars menu, you selected the Red Data Bar (Gradient) option.

The selected cells C2:C15 have conditional formatting rules applied. Edit the data bar rule so the data bars use the Orange, Accent 2, Lighter 80% color.

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. In the Conditional Formatting menu, you clicked the Manage Rules... menu item. Inside the Conditional Formatting Rules Manager dialog from the Data Bar list, you clicked the exDataBarConditionalRuleIcon item. Inside the Conditional Formatting Rules Manager dialog, you clicked the Edit Rule... button. In the Color menu, you selected the Orange, Accent 2, Lighter 80% color option. Inside the Edit Formatting Rule dialog, you clicked the OK button. Inside the Conditional Formatting Rules Manager dialog, you clicked the OK button.

Create and apply a new conditional formatting rule for the selected cells C2:C15 to apply bold font formatting to only cells that are equal to or below the average for the selected range.1

In the Home Ribbon Tab in the Styles Ribbon Group, you clicked the Conditional Formatting button. In the Conditional Formatting menu, you clicked the New Rule... menu item. Inside the New Formatting Rule dialog from the Select a Rule Type list, you selected Format only values that are above or below average. Inside the New Formatting Rule dialog in the Format values that are: drop-down, you selected equal or below. Inside the New Formatting Rule dialog, you clicked the Format... button. Inside the Format Cells dialog from the Font style list, you selected Bold. Inside the Format Cells dialog, you clicked the OK button. Inside the New Formatting Rule dialog, you clicked the OK button.

Insert a clustered column-line combination chart based on the selected data. The line chart should represent the Owner Draw data series. Both data series should be on the primary axis.

In the Insert Ribbon Tab in the Charts Ribbon Group, you clicked the Insert Column or Bar Chart button, clicked the Insert Waterfall or Stock Chart button, clicked the Insert Hierarchy Chart button, and clicked the Insert Combo Chart button. In the Insert Combo Chart menu, you selected the Clustered Column - Line option.

From Page Break Preview view, insert a page break immediately above the row 12.

In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Breaks button. In the Breaks menu, you clicked the Insert Page Break menu item.

Without adjusting the column widths, guarantee that all columns will print on one page.

In the Page Layout Ribbon Tab in the Scale To Fit Ribbon Group, you clicked the Width: drop-down arrow. In the Width: menu, you clicked the 1 page menu item.

Use the spelling checker to find and change all instances of any misspelled words.

In the Review Ribbon Tab in the Proofing Ribbon Group, you clicked the Spelling button. Inside the Spelling: English (United States) dialog, you clicked the Change All button. Inside the Microsoft Excel dialog, you clicked the OK button.

Modify this worksheet so you can see four different areas of the worksheet at the same time and scroll each area independently of the others.

In the View Ribbon Tab in the Window Ribbon Group, you clicked the Split button.

Add column Sparklines to cells F2:F11 to represent the values in B2:E11.

You clicked the Quick Analysis Tool button, clicked the Sparklines tab header, and clicked the Column button.

Add a linear trendline to this chart. Use the default trendline formatting.

You launched the Chart Elements menu. In the Mini Toolbar, you checked the Trendline check box.

Use Flash Fill to autofill the cells in this column. Start by entering the pattern ECN Department in cell B2.

You typed ECN Department in cell B2, pressed Enter, typed Eng in cell B3, and pressed Enter.