Excel Exam

Change the value in cell B6 to 725.

Change to 725 and then press enter

Hide the chart title.

Click the Chart Elements button and click the Chart Title check box.

Display the data table, including the legend keys.

Click the Chart Elements button and click the Data Table check box.

Hide the primary vertical axis.

Click the Chart Elements button and click the arrow next to Axes and select Primary Vertical.

Display the data labels on this chart above the data markers.

Click the Chart Elements button. Click the Data Labels arrow and select Above.

Use AutoFill to complete the series from cell B7 through cell E7.

Click the Fill Handle tool in the selected cell and drag across to cell E7. Release the mouse button.

Add a new worksheet to the right of the Dec 9 sheet.

Click the New Sheet button to the right of the last worksheet tab.

Edit the formula in cell D2 so the references to cell C2 will update when the formula is copied, and the reference to cell B9 will remain constant. Use AutoFill to copy the formula to cells D3:D6.

Double-click cell D2 to edit the formula. Change the formula to be =C2+(C2*$B$9). Press Enter. Click the Fill Handle tool and drag down to cell D6. Release the mouse button.

Autofit column D to best fit the data.

Double-click the right column boundary for column D.

Apply the Style 7 Quick Style to the chart.

On the Chart Tools Design tab, in the Chart Styles group, click Style 7. It is the seventh option in the Quick Styles gallery.

Apply the Monochromatic Palette 1 color scheme (the first option in the Monochromatic section) to the chart.

On the Chart Tools Design tab, in the Chart Styles group, click the Change Colors button. Click Monochromatic Palette 1, it is the first option in the Monochromatic section.

Switch the rows and columns in the chart, so the data points are grouped into data series by year.

On the Chart Tools Design tab, in the Data group, click the Switch Row/Column button.

In cell E15, enter a formula to find the highest line item cost this month (cells E2:E14).

On the Formulas tab, in the Function Library group, click the AutoSum arrow, and click Max. Press Enter.

In cell E15, enter a formula to find the lowest line item cost this month (cells E2:E14).

On the Formulas tab, in the Function Library group, click the AutoSum arrow, and click Min. Press Enter.

Center the content in the selected cells horizontally.

On the Home tab, in the Alignment group, click the Center button.

Merge the cells so the text appears centered across the merged cells.

On the Home tab, in the Alignment group, click the Merge & Center button.

The selected cells have been merged and centered. Unmerge them.

On the Home tab, in the Alignment group, click the Merge & Center button.

Change the width of the columns C:H to 14.

On the Home tab, in the Cells group, click the Format button. Select Column Width... Type 14, and click OK.

Add a new worksheet to the left of the Dec 9 sheet.

On the Home tab, in the Cells group, click the Insert button arrow, and select Insert Sheet.

Enter a formula in cell B7 to calculate the average value of cells B2:B6.

On the Home tab, in the Editing group, click the AutoSum button arrow and select Average. Press Enter.

Filter the Category column so only rows with Coffee are shown.

On the Home tab, in the Editing group, click the Sort & Filter button and select Filter. Click the arrow at the top of the Category column. Click the (Select All) check box to remove all the checkmarks. Click the check box in front of Coffee. Click OK.

Add a Blue (in the row of standard colors, the third color from the right) bottom border to the selected cells. Use the thickest single line style available.

On the Home tab, in the Font group, click the Borders button arrow, and select More Borders... In the Format Cells dialog, Border tab, click the thickest line available in the Style section. Expand the Color palette and select Blue. In the Border section, click the button representing a bottom border.

Remove the borders from the selected cells with a single command.

On the Home tab, in the Font group, click the Borders button arrow, and select No Border.

Apply the Top and Bottom Border to the selected cells with a single command.

On the Home tab, in the Font group, click the Borders button arrow, and select Top and Bottom Border.

Change the font color of the selected cells to the Blue standard color (it is the third option from the right in the row of standard colors).

On the Home tab, in the Font group, click the Font Color arrow, and select Blue.

Change font size for the selected cells to 18.

On the Home tab, in the Font group, click the Font Size arrow, and select 18.

Change the font for the selected cell to Cambria.

On the Home tab, in the Font group, click the Font arrow, and select Cambria.

Apply the Double Accounting underline format to the selected cells.

On the Home tab, in the Font group, click the Font dialog launcher to open the Format Cells dialog. On the Font tab, in the Underline section, expand the Underline list and select Double Accounting. Click OK.

Apply the Accounting Number Format to the selected cells.

On the Home tab, in the Number group, click the Accounting Number Format button.

Modify the number format so no decimal places are visible after the decimal point.

On the Home tab, in the Number group, click the Decrease Decimal button twice.

Change the number format for the selected cell to the Currency number format.

On the Home tab, in the Number group, click the Number Format arrow and select Currency.

Apply the Accent1 cell style to the selected cell.

On the Home tab, in the Styles group, click the Cell Styles button. Click the Accent1 style.

Apply the Total cell style to the selected cells.

On the Home tab, in the Styles group, click the Cell Styles button. Click the Total style.

Apply conditional formatting to the selected cells so cells with the 10 lowest values are formatted with green fill and dark green text.

On the Home tab, in the Styles group, click the Conditional Formatting button. Point to Top/Bottom Rules, and click Bottom 10 Items¿ Expand the format selector box and select Green Fill with Dark Green Text. Click OK.

Create a 3-D pie chart from the selected data.

On the Insert tab, in the Charts group, click the Insert Pie Chart button. Select the 3-D Pie chart type .

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

On the Page Layout tab, in the Scale to Fit group, click the Width arrow. Click 1 page.

Apply bold and italic formatting to the selected cell.

Press bold and Italic

Rename Sheet1: Dec 16

Right-click the Sheet1 worksheet tab, and click Rename. Type Dec 16 and press Enter.

Change the color of the sheet tab for the Dec 9 worksheet to Dark Red (the first option at the left in the row of standard colors).

Right-click the worksheet tab and point to Tab Color. Click Dark Red (the first color at the left in the row of standard colors).

Enter a formula in the selected cell to display the owner's draw percentage (cell B6).

Type =B6. Press Enter.

Enter a formula in the selected cell to calculate the profit projection for 2020: total sales (cell F4) minus the cost of goods sold (cell F5).

Type =F4-F5. Press Enter.

Name cell B9 as follows: COLA

Type COLA in the Name box to the left of the formula bar. Press Enter.

Add the word TOTAL to cell A9.

Type TOTAL, and then press Enter.

Enter the number 530 in cell C7.

Type and press enter

Remove just the italic formatting from the selected cell.

take off italic