Excel Exam Flashcard
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.
Home tab, Font group, click the border button arrow and select “More Borders” In the “Format Cells” dialog Border tab, click the thickest line available in the “style” section.
Add a new worksheet to the left
Home tab, Cell group, click the “Insert” button arrow, and select “Insert Sheet.”
Add a new worksheet to the right
Click the “New Sheet” button to the right of the last worksheet tab
Add the word “TOTAL” to cell A9
Type “TOTAL” and then press “Enter”
Apply conditional formatting to the selected cells so cells with the 10 lowest values are formatted with green fill and dark green text
Home tab, Style group, click the “conditional formatting” button and point to “Top Bottom Rules”, and click “Bottom 10 Item.” Expand the format selector box, and select “Green Fill with Dark Green Text”, then click OK
Apply conditional formatting to the selected cells, so cells with the 10 lowest values are formatted with green fill and dark green text
Home tab, Style group, click the “conditional formatting” button and point to “Top Bottom Rules,” and click “Bottom 10 Item.” Expand the format selector box, select “Green Fill with Dark Green Text,” then click OK
Apply the Accent1 cell style to the selected cell
Home tab, Style Group, click the “Cell Styles” button and click “Accent1” style
Apply the Accounting Number Format to the selected cells.
Apply the Style 7 Quick Style to the chart.
“Chart Tools Design Tab”, in the “Chart Styles” group, click Style 7
Apply the Top and Bottom Border to the selected cells with a single command.
“Home” tab, in “Font” group, click the “Border” button arrow and select “Top and Bottom” Border
Apply the Total cell style to the selected cells.
“Home” tab, in the “Styles” group, clicks the “Cell Styles” button. Click the “total” style.
Apply the Double Accounting underlined format to the selected cells
“Home” tab, “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 Monochromatic Palette 1 color scheme (the first option in the Monochromatic section) to the chart.
On the “ChartToDesign” tab, in the “Chart Styles” group, click the “Change Colors” button. Click “Monochromatic Palette 1”
AutoFit Column D to best fit the data
Double click the right column boundary for column D
Center the content in the selected cells horizontally
“Home” tab, “Alignment” Group, click the “Center” button
Change the color of the sheet tab for the 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,” and Click “Dark Red”
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)
“Home” tab, “Font” group, click the “Font Color” arrow. Select “Blue”
Change the number format for the selected cell to the “Currency”.
“Home” tab, “Number” group, click the “Number Format” arrow and select “Currency”
Change the width of columns C: H to 14
“Home” tab, “Cells” groups, click the “Format” button, select “Column Width,” Type 14, and click OK
Create a 3D pie chart from the selected data
“Insert” tab, in the “Chart” group, click the “Insert Pie Chart” button. Select the 3D Pie Chart Type
Display the data labels on this chart above the data markers
“Chart Element” menus bar, in the mini toolbar in the data labels menu, click “above” menu item
Display the data table, including the legend keys.
Open Chart Element, Click “Data Table”
Edit the formula in cell D2 so the references to cell C2 will update when the procedure 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 “=C2+C2*$3$9).” Press Enter. Click the “Fill Handle” tool and drag it down to Cell D6. Release the mouse afterward.
Enter a formula in cell B7 to calculate the average value of cells B2:B6
Home tab, Editing group, Click the “Autosum” button arrow and select “Average.” Press “Enter”
Enter a formula in the selected cell to calculate the profit projection for total sales (cell F4) minus the cost of goods sold (cell F5)
Type: “=F4-F5” and press “Enter”
Enter a formula in the selected cell to display the owner’s draw percentage (cell B6)
Click cell D2, typed “=B6” in cell D2, and pressed “Enter”
Filter the “Category” column so only rows with “Coffee” are shown
1) Home tab
2) Editing group
3) Click Sort and Filter button and select “Filter”
4) Click the arrow at the top of the “Category” column
5) Click the “Select All” and check box to remove all checkmarks
6) Click checklist “Coffee” and click OK
Hide the chart title
Click the “Chart Element” button and click the “Chart Title,” and check the box
Hide the primary vertical axis
Click the “Chart Element” button and click the arrow next to “Axes,” and select “Primary Vertical”
In cell E15, enter a formula to find the highest line item cost this month (cells E2:E14)
Formula tab, in the Function Library group, click the “Autosum” arrow, click “Max” then press Enter
In cell E15, enter a formula to find the lowest line item cost this month (cells E2:E14)
Formula tab, in the Function Library group, clicks the “Autosum” arrow, click “Min,” then press Enter
Merge the cells so the text appears centered across the merged cells
“Home” tab, “Alignment” Group, and click the “Merge & Center” button
Modify the number format, so no decimal places are visible after the decimal point
“Home” tab, in “Number” group, click the “Decrease Decimal” button, clicked the “Decrease Decimal” button
Remove the border from selected text with a single command.
“Home” tab, “Font” group, click the “Border” button arrow, and select “No border.”
Switch the rows and columns in the chart so the data points are grouped into data series by year.
In the “Design” tab, click the “Switch row/column” button
The selected cells have been merged and centered. Unmerge them.
Press Ctrl + Z
Use Autofill to complete the series from cell B7 through cells E7
Click the “Fill Handle” tool in the selected cell and drag across the cell “E7.”
Without adjusting the column widths, guarantee that all columns will print on one page.
“Page Layout” tab, in the scale, to fit the group, click the “width” arrow. Click 1 page.