# Excel Exam

## Unlock all answers in this set

Unlock answers (41)
question
Enter the number 530 in cell C7.
answer
Type and press enter
question
Add the word TOTAL to cell A9.
answer
Type TOTAL, and then press Enter.
question
Change the value in cell B6 to 725.
answer
Change to 725 and then press enter
question
Apply the Accounting Number Format to the selected cells.
answer
On the Home tab, in the Number group, click the Accounting Number Format button.
question
Modify the number format so no decimal places are visible after the decimal point.
answer
On the Home tab, in the Number group, click the Decrease Decimal button twice.
question
Change the number format for the selected cell to the Currency number format.
answer
On the Home tab, in the Number group, click the Number Format arrow and select Currency.
question
Use AutoFill to complete the series from cell B7 through cell E7.
answer
Click the Fill Handle tool in the selected cell and drag across to cell E7. Release the mouse button.
question
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).
answer
Type =F4-F5. Press Enter.
question
Enter a formula in the selected cell to display the owner's draw percentage (cell B6).
answer
Type =B6. Press Enter.
question
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.
answer
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.
question
Merge the cells so the text appears centered across the merged cells.
answer
On the Home tab, in the Alignment group, click the Merge & Center button.
question
The selected cells have been merged and centered. Unmerge them.
answer
On the Home tab, in the Alignment group, click the Merge & Center button.
question
Apply bold and italic formatting to the selected cell.
answer
Press bold and Italic
question
Remove just the italic formatting from the selected cell.
answer
take off italic
question
Apply the Double Accounting underline format to the selected cells.
answer
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.
question
Change the font for the selected cell to Cambria.
answer
On the Home tab, in the Font group, click the Font arrow, and select Cambria.
question
Change font size for the selected cells to 18.
answer
On the Home tab, in the Font group, click the Font Size arrow, and select 18.
question
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).
answer
On the Home tab, in the Font group, click the Font Color arrow, and select Blue.
question
Remove the borders from the selected cells with a single command.
answer
On the Home tab, in the Font group, click the Borders button arrow, and select No Border.
question
Apply the Top and Bottom Border to the selected cells with a single command.
answer
On the Home tab, in the Font group, click the Borders button arrow, and select Top and Bottom Border.
question
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.
answer
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.
question
Apply the Accent1 cell style to the selected cell.
answer
On the Home tab, in the Styles group, click the Cell Styles button. Click the Accent1 style.
question
Apply the Total cell style to the selected cells.
answer
On the Home tab, in the Styles group, click the Cell Styles button. Click the Total style.
question
Enter a formula in cell B7 to calculate the average value of cells B2:B6.
answer
On the Home tab, in the Editing group, click the AutoSum button arrow and select Average. Press Enter.
question
In cell E15, enter a formula to find the lowest line item cost this month (cells E2:E14).
answer
On the Formulas tab, in the Function Library group, click the AutoSum arrow, and click Min. Press Enter.
question
In cell E15, enter a formula to find the highest line item cost this month (cells E2:E14).
answer
On the Formulas tab, in the Function Library group, click the AutoSum arrow, and click Max. Press Enter.
question
Name cell B9 as follows: COLA
answer
Type COLA in the Name box to the left of the formula bar. Press Enter.
question
Add a new worksheet to the right of the Dec 9 sheet.
answer
Click the New Sheet button to the right of the last worksheet tab.
question
Add a new worksheet to the left of the Dec 9 sheet.
answer
On the Home tab, in the Cells group, click the Insert button arrow, and select Insert Sheet.
question
Rename Sheet1: Dec 16
answer
Right-click the Sheet1 worksheet tab, and click Rename. Type Dec 16 and press Enter.
question
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).
answer
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).
question
Autofit column D to best fit the data.
answer
Double-click the right column boundary for column D.
question
Change the width of the columns C:H to 14.
answer
On the Home tab, in the Cells group, click the Format button. Select Column Width... Type 14, and click OK.
question
Without adjusting the column widths, guarantee that all columns will print on one page.
answer
On the Page Layout tab, in the Scale to Fit group, click the Width arrow. Click 1 page.
question
Switch the rows and columns in the chart, so the data points are grouped into data series by year.
answer
On the Chart Tools Design tab, in the Data group, click the Switch Row/Column button.
question
Create a 3-D pie chart from the selected data.
answer
On the Insert tab, in the Charts group, click the Insert Pie Chart button. Select the 3-D Pie chart type .
question
Hide the chart title.
answer
Click the Chart Elements button and click the Chart Title check box.
question
Hide the primary vertical axis.
answer
Click the Chart Elements button and click the arrow next to Axes and select Primary Vertical.
question
Display the data table, including the legend keys.
answer
Click the Chart Elements button and click the Data Table check box.
question
Display the data labels on this chart above the data markers.
answer
Click the Chart Elements button. Click the Data Labels arrow and select Above.
question
Apply the Style 7 Quick Style to the chart.
answer
On the Chart Tools Design tab, in the Chart Styles group, click Style 7. It is the seventh option in the Quick Styles gallery.
question
Apply the Monochromatic Palette 1 color scheme (the first option in the Monochromatic section) to the chart.
answer
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.
question
Apply conditional formatting to the selected cells so cells with the 10 lowest values are formatted with green fill and dark green text.
answer
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.
question
Filter the Category column so only rows with Coffee are shown.
answer
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.
question
Center the content in the selected cells horizontally.
answer
On the Home tab, in the Alignment group, click the Center button.