Excel Exam Flashcard

Question 1

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 1

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.

Question 2

Add a new worksheet to the left

Answer 2

Home tab, Cell group, click the “Insert” button arrow, and select “Insert Sheet.”

Question 3

Add a new worksheet to the right

Answer 3

Click the “New Sheet” button to the right of the last worksheet tab

Question 4

Add the word “TOTAL” to cell A9

Answer 4

Type “TOTAL” and then press “Enter”

Question 5

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

Answer 5

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

Question 6

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

Answer 6

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

Question 7

Apply the Accent1 cell style to the selected cell

Answer 7

Home tab, Style Group, click the “Cell Styles” button and click “Accent1” style

Question 8

Apply the Accounting Number Format to the selected cells.

Question 9

Apply the Style 7 Quick Style to the chart.

Answer 9

“Chart Tools Design Tab”, in the “Chart Styles” group, click Style 7

Question 10

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

Answer 10

“Home” tab, in “Font” group, click the “Border” button arrow and select “Top and Bottom” Border

Question 11

Apply the Total cell style to the selected cells.

Answer 11

“Home” tab, in the “Styles” group, clicks the “Cell Styles” button. Click the “total” style.

Question 12

Apply the Double Accounting underlined format to the selected cells

Answer 12

“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”

Question 13

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

Answer 13

On the “ChartToDesign” tab, in the “Chart Styles” group, click the “Change Colors” button. Click “Monochromatic Palette 1”

Question 14

AutoFit Column D to best fit the data

Answer 14

Double click the right column boundary for column D

Question 15

Center the content in the selected cells horizontally

Answer 15

“Home” tab, “Alignment” Group, click the “Center” button

Question 16

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)

Answer 16

Right-click the “worksheet tab,” and point to “Tab Color,” and Click “Dark Red”

Question 17

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 17

“Home” tab, “Font” group, click the “Font Color” arrow. Select “Blue”

Question 18

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

Answer 18

“Home” tab, “Number” group, click the “Number Format” arrow and select “Currency”

Question 19

Change the width of columns C: H to 14

Answer 19

“Home” tab, “Cells” groups, click the “Format” button, select “Column Width,” Type 14, and click OK

Question 20

Create a 3D pie chart from the selected data

Answer 20

“Insert” tab, in the “Chart” group, click the “Insert Pie Chart” button. Select the 3D Pie Chart Type

Question 21

Display the data labels on this chart above the data markers

Answer 21

“Chart Element” menus bar, in the mini toolbar in the data labels menu, click “above” menu item

Question 22

Display the data table, including the legend keys.

Answer 22

Open Chart Element, Click “Data Table”

Question 23

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.

Answer 23

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.

Question 24

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

Answer 24

Home tab, Editing group, Click the “Autosum” button arrow and select “Average.” Press “Enter”

Question 25

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)

Answer 25

Type: "=F4-F5" and press "Enter"

Question 26

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

Answer 26

Click cell D2, typed "=B6" in cell D2, and pressed "Enter"

Question 27

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

Answer 27

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

Question 28

Hide the chart title

Answer 28

Click the "Chart Element" button and click the "Chart Title," and check the box

Question 29

Hide the primary vertical axis

Answer 29

Click the "Chart Element" button and click the arrow next to "Axes," and select "Primary Vertical"

Question 30

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

Answer 30

Formula tab, in the Function Library group, click the "Autosum" arrow, click "Max" then press Enter

Question 31

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

Answer 31

Formula tab, in the Function Library group, clicks the "Autosum" arrow, click "Min," then press Enter

Question 32

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

Answer 32

"Home" tab, "Alignment" Group, and click the "Merge & Center" button

Question 33

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

Answer 33

"Home" tab, in "Number" group, click the "Decrease Decimal" button, clicked the "Decrease Decimal" button

Question 34

Remove the border from selected text with a single command.

Answer 34

"Home" tab, "Font" group, click the "Border" button arrow, and select "No border."

Question 35

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

Answer 35

In the "Design" tab, click the "Switch row/column" button

Question 36

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

Answer 36

Press Ctrl + Z

Question 37

Use Autofill to complete the series from cell B7 through cells E7

Answer 37

Click the "Fill Handle" tool in the selected cell and drag across the cell "E7."

Question 38

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

Answer 38

"Page Layout" tab, in the scale, to fit the group, click the "width" arrow. Click 1 page.