Deck 6: Formatting a Worksheet

Question 1

You can apply number formats to any cell.

Answer 1

False

Question 2

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

Answer 2

False

Question 3

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

Answer 3

False

Question 4

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

Question 5

Like Word, Excel allows you to work with styles.

Question 6

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

Question 7

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

Question 8

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

Question 9

By default, values are always centered within the cell.

Question 10

After a chart is selected, you cannot resize it.

Question 11

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

Question 12

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

Question 13

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

Question 14

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

Question 15

Photographs can be inserted only from a file.

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

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

Question 21

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 22

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

A)
B)
C)
D)

Question 23

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 24

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 25

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 26

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

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

Question 27

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

A)
B)
C)
D)

Question 28

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 29

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 30

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

A)
B)
C)
D)

Question 31

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

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

Question 32

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 33

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 34

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 35

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 36

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 37

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 38

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 39

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 40

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 41

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

A)
B)
C)
D)

Question 42

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 43

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 44

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 45

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

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

Question 46

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 47

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 48

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 49

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

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

Question 50

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 51

Which of the following buttons represents the Format Painter tool?

A)
B)
C)
D)

Question 52

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 53

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

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

Question 54

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

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

Question 55

_____ 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 56

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 57

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 58

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 59

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 60

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 61

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

Question 62

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 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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 70

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

Question 71

Case-Based Critical Thinking Questions Case 6-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 72

Case-Based Critical Thinking Questions Case 6-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 73

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

Question 74

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

Question 75

Case-Based Critical Thinking Questions Case 6-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