Excel Exam Flashcard

1
Q

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.

A

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.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Add a new worksheet to the left

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Add a new worksheet to the right

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Add the word “TOTAL” to cell A9

A

Type “TOTAL” and then press “Enter”

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Apply the Accent1 cell style to the selected cell

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Apply the Accounting Number Format to the selected cells.

A
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Apply the Style 7 Quick Style to the chart.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Apply the Total cell style to the selected cells.

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Apply the Double Accounting underlined format to the selected cells

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

AutoFit Column D to best fit the data

A

Double click the right column boundary for column D

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Center the content in the selected cells horizontally

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

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)

A

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

17
Q

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)

A

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

18
Q

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

A

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

19
Q

Change the width of columns C: H to 14

A

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

20
Q

Create a 3D pie chart from the selected data

A

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

21
Q

Display the data labels on this chart above the data markers

A

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

22
Q

Display the data table, including the legend keys.

A

Open Chart Element, Click “Data Table”

23
Q

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.

A

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.

24
Q

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

A

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

25
Q

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)

A

Type: “=F4-F5” and press “Enter”

26
Q

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

A

Click cell D2, typed “=B6” in cell D2, and pressed “Enter”

27
Q

Filter the “Category” column so only rows with “Coffee” are shown

A

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

28
Q

Hide the chart title

A

Click the “Chart Element” button and click the “Chart Title,” and check the box

29
Q

Hide the primary vertical axis

A

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

30
Q

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

A

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

31
Q

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

A

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

32
Q

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

A

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

33
Q

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

A

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

34
Q

Remove the border from selected text with a single command.

A

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

35
Q

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

A

In the “Design” tab, click the “Switch row/column” button

36
Q

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

A

Press Ctrl + Z

37
Q

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

A

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

38
Q

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

A

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