Deck 8: Excel Lesson 2: Changing the Appearance of a Worksheet

Question 1

The Cell Styles library includes many predefined styles.

Answer 1

False

Question 2

____ determines the best width for a column or the best height for a row, based on its contents.

A) MaxFit
B) FitAuto
C) FitNow
D) AutoFit

Answer 2

D

Question 3

The Format Cells dialog box also includes a Protection tab, which has options for locking and hiding cells in a protected workbook.

Answer 3

True

Question 4

Horizontal alignments do NOT include ____.

A) left
B) centered
C) right
D) bottom

Question 5

Standard accounting format uses a single border below a column of numbers and a double border below the total .

Question 6

If you want to specify a precise column width, use the Column Width ____.

A) wizard
B) task pane
C) status bar
D) dialog box

Question 7

The default number format is General, which displays numbers the way you type them.

Question 8

To change the background color of a cell, select the cell you want to change. On the Home tab of the Ribbon, in the Font group, click the Background Color button arrow.

Question 9

A format is the design of text.

Question 10

At times, you might need to remove, or clear, all the formatting applied to a cell or range of cells.

Question 11

Text that is too long to fit within a cell is displayed in the next cell, if it is empty.

Question 12

You can change the width of several columns at one time. Select the columns you want to resize. Then, use the pointer to click and drag the ____ edge of one of the selected column headings.

A) top
B) left
C) right
D) bottom

Question 13

Format Painter enables you to copy formatting from one worksheet cell to another without copying the cell's contents.

Question 14

You can use the Format Painter to copy formatting only to adjacent cells or ranges.

Question 15

Press the Ctrl+B keys to apply bold.

Question 16

Numbers that do not fit in the cell are shown as a series of question marks (??????).

Question 17

Number fills change the way data looks in a cell.

Question 18

To remove a style from the selected cell, simply click Good in the Good, Bad and Neutral section of the Cell Styles gallery.

Question 19

Unless you specify otherwise, numbers you enter in a cell are lined up along the ____ side of the cell.

A) bottom-right
B) upper-right
C) bottom-left
D) upper-left

Question 20

To resize a column, place the pointer on the right edge of the column heading until the pointer changes to a double-headed arrow. Click and drag to the right until the column expands to the width you want.

Question 21

FIGURE EX 2-1 In Figure EX 2-1 above, the cell that shows wrapped text is ____.

A) A16
B) A18
C) A19
D) A21

Question 22

By default, the ____ theme is applied to each workbook.

A) Excel
B) Office
C) Business
D) Blank

Question 23

You can select a different theme for your workbook. Click the ____ tab on the Ribbon. In the Themes group, click the Themes button to display a gallery of themes.

A) Page Layout
B) Layout
C) Format
D) Page Format

Question 24

You can remove the borders from a selected cell by clicking ____ in the border style menu.

A) Transparent
B) Border Off
C) Blank
D) No Border

Question 25

To change fonts and sizes, you must first select the cells you want to change. Then, on the Home tab of the Ribbon, in the ____ group, click the arrow next to the Font box to display a gallery of available fonts.

A) Font
B) Edit
C) Styles
D) Data

Question 26

FIGURE EX 2-1 In Figure EX 2-1 above, you can see that when you wrap text, the ____increases automatically to display additional lines until all the text is visible.

A) row width
B) row height
C) column width
D) column height

Question 27

Case EX 2-2 Josh wants to apply a cell style to certain cells in his worksheet. Josh wants to get to the Cell Styles gallery. How does he navigate to the Cell Style gallery?

A) In the Styles group on the Home tab of the Ribbon, click the Cell Styles button.
B) In the Editing group on the Themes tab of the Ribbon, click the Cell Styles button.
C) In the Editing group on the Home tab of the Ribbon, click the Cell Styles button.
D) None of the above

Question 28

As you format cells, ____ shows the results of the different formatting options you can choose.

A) Print Preview
B) Live Preview
C) Gallery Preview
D) Format Preview

Question 29

You can also center cell contents across several columns. Select the cells, and then click the ____ button in the Alignment group on the Home tab of the Ribbon.

A) Align
B) Merge
C) Center
D) Merge & Center

Question 30

Case EX 2-1 Tessa's boss has asked her to improve the appearance of a worksheet. Please answer the questions below. Once the Find and Replace dialog box appears, with the Replace tab displayed, what button should Tessa click to expand the dialog box so that she can enter in the formatting styles she wants to find and replace?

A) Expand
B) More
C) Continue
D) Options

Question 31

Press the ____ keys to apply underlining.

A) Ctrl+B
B) Ctrl+L
C) Ctrl+U
D) Ctrl+I

Question 32

Case EX 2-2 Josh wants to apply a cell style to certain cells in his worksheet. Josh previews some of the styles and clicks one to apply it to the cell. He now wants to remove it. To remove a style from the selected cell, he should simply click ____ in the Good, Bad and Neutral section of the Cell Styles gallery.

A) Neutral
B) Good
C) Bad
D) Normal

Question 33

To change text orientation, select the cells whose contents you want to rotate. Click the ____ button in the Alignment group on the Home tab of the Ribbon.

A) Move
B) Text
C) Orientation
D) Align

Question 34

To change the alignment of a cell, select the cell, and then click an alignment button in the Alignment group on the ____________________ tab of the Ribbon.

Question 35

Case EX 2-1 Tessa's boss has asked her to improve the appearance of a worksheet. Please answer the questions below. Tessa wants to find and replace italic text with bold text. Where can she find the dialog box to do this?

A) On the Home tab, in the Editing group, click the Find & Select button, and then click Replace.
B) On the Ribbon, in the Formatting group, click the Find & Select button, and then click Replace.
C) On the Home tab, in the Proofing group, click the Find & Select button, and then click Find.
D) None of the above.

Question 36

To open the Format Cells dialog box, you can click the Dialog Box Launcher in the Font, Alignment, or Number group on the Home tab of the Ribbon, or you can press the____ keys.

A) Ctrl+1
B) Ctrl+A
C) Ctrl+F
D) Ctrl+C

Question 37

Data can be indented (or ____ ) within cells to help distinguish categories or set data apart.

A) shifted to the right
B) shifted to the left
C) shifted up
D) shifted down

Question 38

A ____ is a preset collection of design elements, including fonts, colors, and other effects.

A) gallery
B) style
C) theme
D) group

Question 39

When you select the Merge & Center button, only the contents from the cell in the ____ corner of the range are kept. All other content is deleted from the worksheet.

A) upper-left
B) lower-left
C) upper-right
D) lower-right

Question 40

Excel ____ all numbers.

A) right-aligns
B) left-aligns
C) top-aligns
D) bottom-aligns

Question 41

If the next cell already contains data, any text that does not fit in the cell is ____________________, or hidden from view.

Question 43

You can add emphasis to a cell by placing a(n) ____________________ (or line) around its edges.

Question 44

The default ____________________ (or background) color of cells is white, but you can change this background color to help accentuate certain cells, such as descriptive labels or totals.

Question 45

The ____________________ format displays numbers with a dollar sign, a thousands separator, and two decimal places.

Question 46

Please briefly describe these three ways to position data within cells: Orientation, Wrap Text, and Merge. Also, include an example of when you would use each type of positioning.