Deck 13: Formatting a Worksheet

Question 1

Borders and background colors define areas of a worksheet and call attention to important information.

Answer 1

True

Question 2

To change the width of a cell, you must increase the width of the entire column .

Answer 2

True

Question 3

An effectively formatted worksheet is more approachable and helps readers understand the meaning of values and formulas.

Answer 3

True

Question 4

The Worksheet Styles button displays formatting options that you can apply to sections of a worksheet.

Question 5

Like Word, Excel allows you to work with styles.

Question 6

By default, values are always centered within the cell.

Question 7

The square handle that appears at the top of a graphic allows you to rotate the graphic.

Question 8

After you've finished formatting a worksheet cell, click inside the cell to complete the process.

Question 9

You have to manually modify your formulas if blank rows or columns are inserted or deleted.

Question 10

A(n) line chart is used to show the proportions of parts to a whole.

Question 11

If a label is too long to fit into a cell it is always truncated.

Question 12

Photographs can be inserted only from a file.

Question 13

By default, labels are aligned along the left edge of a cell.

Question 14

You can change to a different chart type by clicking the FORMAT tab, then clicking the Change Chart Type button.

Question 15

The most commonly used number formats are available as buttons in the Data group on the HOME tab.

Question 16

After a chart is selected, Excel displays only the FORMAT contextual tab.

Question 17

After a chart is selected, you cannot resize it.

Question 18

To add borders around the outside and inside edges of selected cells, click both the Outside and Inside border buttons in the Preset section.

Question 19

Font attributes can be applied only to the entire contents of a cell.

Question 20

You can apply number formats to any cell.

Question 21

In the accompanying figure, which callout points to the button used to center cell contents?

A) A
B) B
C) F
D) E

Question 22

To manually adjust the width of a column, position the pointer over the vertical line between two column headings so that the pointer changes to a shape. _____ while you drag the vertical line left or right to manually adjust the width of the column.

A) Double-click the right mouse button
B) Press and hold the right mouse button
C) Double-click the left mouse button
D) Press and hold the left mouse button

Question 23

In the accompanying figure, which callout points to the Merge and Center button?

A) A
B) B
C) C
D) D

Question 24

Which of the following buttons displays one more digit after the decimal point?

A)
B)
C)
D)

Question 25

You can use buttons in the Font group on the _____ tab to select different font attributes for any data in worksheet cells.

A) HOME
B) VIEW
C) FORMAT
D) INSERT

Question 26

Which of the following is displayed in the cell if the value is too long to fit into a cell?

A) &&&&&&&
B) ***********
C) $$$$$$$$ $$
D) #########

Question 27

To change the font for a range of cells, click the _____ cell, then drag the mouse to select the cells.

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

Question 28

If a label is too long to fit into a cell and the next cell is empty, _____.

A) it extends into the next cell on the right
B) it extends into the previous cell on the left
C) the end of the label is cut off
D) it automatically moves to the next line

Question 29

To put borders between individual cells you should click the _____ button in the Format Cells dialog box.

A) Inside
B) Outside
C) Between
D) Outline

Question 30

If your computer is configured for use in the U.S., the Comma Style button adds a comma every three digits to the left of the decimal point and displays _____ digits to the right of the decimal point.

A) one
B) two
C) three
D) none

Question 31

After selecting the cell you want to format, you can apply _____ font attribute(s).

A) only one
B) not more than three
C) multiple
D) two

Question 32

The Percent Style button displays cell contents as a percentage, which means .35 is displayed as _____.

A) 0.35%
B) 3.5%
C) 350%
D) 35%

Question 33

Excel automatically adjusts the height and width of selected cells when you use the _____ command located in the HOME tab's Format button.

A) AutoFormat
B) AutoAdjust
C) AutoFit
D) Auto

Question 34

To manually adjust the width of a column, position the pointer over the vertical line between two column headings so that the pointer changes to a _____ shape.

A)
B)
C)
D)

Question 35

To display the Format Cells dialog box you also can use the Format Cells Dialog Box Launcher in the _____ group.

A) Number
B) Cells
C) Styles
D) Font

Question 36

To add borders around the outside and inside edges of selected cells, click both Outline and Inside buttons in the _____ section in the Format Cells dialog box.

A) Border
B) Presets
C) Style
D) Line

Question 37

To add a colored background to a selected cell or cells, click the _____ tab in the Format Cells dialog box.

A) Border
B) Fill
C) Format
D) Background

Question 38

The most commonly used number formats are available as buttons in the _____ group on the HOME tab.

A) Value
B) Cells
C) Number
D) Data

Question 39

The _____ Accounting Number Format button displays cell contents in your local currency format.

A)
B)
C)
D)

Question 40

Which of the following buttons should you use to add and remove border lines inside vertical lines?

A)
B)
C)
D)

Question 41

Which of the following is a button that allows you to customize a chart?

A)
B)
C)
D)

Question 42

In the accompanying figure, which label was centered using the Merge and Center button?

A) Description
B) Invoice
C) Price
D) Item #

Question 43

The formula  =D5+D6 changes to _____ if rows 1 and 2 are deleted.

A) =D4+D5
B) =D2+D3
C) =D3+D4
D) The formula does not change

Question 44

To delete more than one row at a time, drag down over the rows you want to delete. Click the down-arrow button next to Delete in the _____ group, then click Delete Sheet Rows to delete the rows.

A) Alignment
B) View
C) Data
D) Cells

Question 45

The _____ button displays formatting options that you can apply to sections of a worksheet.

A) Cell Styles
B) Format Painter
C) Style Selection
D) Format as Section

Question 46

The buttons that allow you to customize a chart appear in the _____ of the chart.

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

Question 47

To delete a row, first click _____.

A) any cell in the row
B) only the first cell in the row
C) only the cell letter
D) none of the above

Question 48

Which of the following buttons represents the Format Painter tool?

A)
B)
C)
D)

Question 49

In general, you begin most modifications on the chart by _____ the chart element you want to change.

A) left-clicking
B) right-clicking
C) double-clicking
D) pointing to

Question 50

Which of the following is aligned on the left edge of a cell by default?

A) value
B) label
C) formula
D) number

Question 51

Which of the following chart types is used to show data that changes over time?

A) Pie chart
B) Line chart
C) Bar chart
D) Column chart

Question 52

Which of the following chart types is used to illustrate the proportion of parts to a whole?

A) Pie chart
B) Line chart
C) Bar chart
D) Column chart

Question 53

You can use the Charts group on the _____ tab to chart or graph data in your worksheet.

A) REVIEW
B) PAGE LAYOUT
C) INSERT
D) HOME

Question 54

A variety of predefined themes that improve the appearance of your worksheets are located on the _____ tab.

A) REVIEW
B) PAGE LAYOUT
C) INSERT
D) HOME

Question 55

The formula =D3+D4 changes to _____ if the original column C is deleted.

A) =E3+E4
B) =C3+C4
C) =F3+F4
D) The formula does not change

Question 56

In the accompanying figure, which callout points to the button that is used to change the source cells for a chart?

A) E
B) D
C) C
D) B

Question 57

_____ can be inserted from a file or imported directly from imaging devices.

A) Vector drawings
B) Photographs
C) Clip art
D) Both photographs and clip art

Question 58

In the accompanying figure, which callout points to the charting tabs?

A) D
B) C
C) B
D) A

Question 59

In the accompanying figure, which callout points to the charting buttons?

A) D
B) C
C) B
D) A

Question 60

To quickly select all cells in a column, _____.

A) click the column header at the top of the column
B) click any cell in the column
C) click on the first cell in the column and then drag mouse down
D) individually click all cells in the column

Question 61

As you insert and delete rows and columns, Excel adjusts _____ cell references in formulas to keep them accurate.

Question 62

Each type of data has special ____________________ characteristics that help to identify its purpose.

Question 63

Excel gives you the ability to apply number formats to your values. Please describe the Accounting Number Format, Percent Style, and Comma Style formats and give an example of how a number would appear in each case.

Question 64

Excel gives you the ability to chart or graph data in your worksheet. Describe the main chart types (line, pie, and bar) and their purpose. Also describe how to insert a chart in your worksheet.

Question 65

Case-Based Critical Thinking Questions Case 13-1 Gabe is learning how to add graphics to a worksheet. Kyra, who has more experience, answers several questions Gabe has. Gabe asks Kyra how to insert clip art. She tells him to _____.

A) click the EDITING tab, select Illustrations, then click the Online Pictures button
B) click the INSERT tab, select Illustrations, then click the Online Pictures button
C) click the INSERT tab, select Clip Art, then click the Online Pictures button
D) click the INSERT tab, select Illustrations, then click the Clip Art button

Question 66

Case-Based Critical Thinking Questions Case 13-1 Gabe is learning how to add graphics to a worksheet. Kyra, who has more experience, answers several questions Gabe has. Gabe asks Kyra where he can find tools that will allow him to draw simple lines and shapes. She advises him to use the _____.

A) Shapes tools from the Illustrations group on the INSERT tab
B) Lines and Shapes tools from the Illustrations group on the HOME tab
C) Shapes tools from the Drawings group on the INSERT tab
D) Vector Graphic tools from the Illustrations group on the INSERT tab

Question 67

When you click the ____________________ Decimal button, one fewer digit is displayed after the decimal point.

Question 68

To quickly select all cells in a column, click the column _____ at the top of the column.

Question 69

Case-Based Critical Thinking Questions Case 13-1 Gabe is learning how to add graphics to a worksheet. Kyra, who has more experience, answers several questions Gabe has. Gabe asks Kyra how he can resize a graphic inserted into his worksheet. Kyra says he can _____.

A) use the round handle at the top of the graphic
B) use the handles that appear on the edges of a selected graphic
C) use the Zoom option
D) drag the graphic

Question 70

Predefined _____ are built into the software, and include formats for displaying currency, percentages, and general numbers.

Question 71

Excel automatically adjusts the height and width of selected cells when you use the ____________________ command.

Question 72

You can quickly add simple borders using the Borders button in the ____________________ group on the HOME tab.

Question 73

Font ____________________ are typically applied to the entire contents of a cell.

Question 74

In general, you begin most modifications by _____ the chart element you want to change.

Question 75

A(n) _____ chart (sometimes called a column chart) is used to show comparisons.