Deck 17: Excel 2007 Unit C: Formatting a Worksheet

Question 1

The Increase Decimal button automatically adds dollar signs and two decimal places to your data.

Answer 1

False

Question 2

When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.

Answer 2

False

Question 3

You can add words to the dictionary of the spelling checker.

Answer 3

True

Question 4

Using the mouse, you can drag or double-click the right edge of a column heading to change the column width .

Question 5

To format a cell or range, first you select it, and then you apply the formatting using the ____ or a keyboard shortcut.

A) Name box
B) formula box
C) Ribbon
D) Sheet tabs

Question 6

The Bold and Underline buttons are found in the Font group on the Home tab of the Ribbon.

Question 7

You can apply formatting before or after you enter data in a cell or range.

Question 8

As shown in the figure above, item 1 is the ____ list arrow.

A) Number Format
B) Accounting Format
C) Commands in Number
D) Decimal Number

Question 9

The font size is measured in units called pixels .

Question 10

Cells and ranges in a worksheet can be formatted ____.

A) only before data is entered
B) only after data is entered
C) before or after data is entered
D) at the same time data is entered

Question 11

The Format Painter button copies both the cell's content and formatting.

Question 12

You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.

Question 13

With Excel, you can adjust the width of one or more columns by using the Ribbon.

Question 14

Formatting can change the actual data of a cell.

Question 15

The ____ of a cell determines how the labels and values look.

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

Question 16

To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.

Question 17

To add a clip to a worksheet, click Clip Art in the Illustrations group on the Home tab.

Question 18

Cell templates are sets of attributes based on themes; they are automatically updated if you change a theme.

Question 19

You can change the font and font size of any cell or range using the Mini toolbar.

Question 20

The default Accounting Number format adds dollar signs and ____ decimal places to the data.

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

Question 21

A ____ is an individual media file, such as art, sound, animation, or a movie.

A) point
B) cell style
C) clip
D) template

Question 22

To apply a table style, select the data to be formatted or click anywhere within the intended range (Excel can automatically detect a range of cells), click the Format as Table button in the ____ group on the Home tab, and then click a style in the gallery.

A) Alignment
B) Styles
C) Cells
D) Editing

Question 23

As shown in the figure above, item 2 points to the ____ button in the Styles group on the Home tab of the Ribbon.

A) Format as Table
B) Cell Styles
C) Format Painter
D) Conditional Formatting

Question 24

As shown in the figure above, item 2 is the ____ button.

A) Number Format
B) Accounting Format
C) Currency Style
D) Percent Style

Question 25

You can change the ____ of labels and values in cells to be left, right, or center.

A) font
B) font size
C) cell style
D) alignment

Question 26

You can apply attributes and alignment options using the ____ tab of the Ribbon.

A) Insert
B) Home
C) Page Layout
D) View

Question 27

As shown in the figure above, item ____ points to the button that underlines text.

A) 3
B) 4
C) 7
D) 8

Question 28

As shown in the figure above, item ____ points to the button that italicizes text.

A) 1
B) 2
C) 4
D) 6

Question 29

The ____ size is the physical size of the text.

A) style
B) format
C) point
D) font

Question 30

As shown in the figure above, item ____ points to the Center button.

A) 4
B) 5
C) 6
D) 8

Question 31

As shown in the figure above, item ____ points to the Merge Center button.

A) 4
B) 5
C) 6
D) 8

Question 32

As shown in the figure above, item 3 points to the ____ button in the Styles group on the Home tab of the Ribbon.

A) Format as Table
B) Cell Styles
C) Format Painter
D) Conditional Formatting

Question 33

The arrow shown in the figure above indicates the ____.

A) effects size in points
B) currently selected font
C) line length in picas
D) currently selected font size

Question 34

____ are styling formats such as bold, italic, and underlining that you can apply to affect the way text and numbers look in a worksheet.

A) Attributes
B) Formats
C) Fonts
D) Clip arts

Question 35

As shown in the figure above, item 1 points to the ____ button in the Styles group on the Home tab of the Ribbon.

A) Format as Table
B) Cell Styles
C) Format Painter
D) Conditional Formatting

Question 36

As shown in the figure above, the currently selected font is ____.

A) Regular
B) Calibri
C) Times New Roman
D) font 11

Question 37

As shown in the figure above, item 1 points to the ____ button.

A) Bold
B) Border
C) Box
D) Styles

Question 38

The dialog box shown in the figure above is opened by right-clicking a cell and then clicking ____ on the shortcut menu.

A) Format
B) Format Cells
C) Cells
D) Fonts

Question 39

You can apply attributes and alignment options using the ____ dialog box.

A) Format Cells
B) Insert
C) Conditional Formatting
D) AutoCorrect

Question 40

The Format Painter button is found in the ____ group on the Home tab of the Ribbon.

A) Alignment
B) Styles
C) Clipboard
D) Font

Question 41

The ____________________ is the box at the top of each column containing a letter.

Question 42

What does the Format Painter button do? Where is the Format Painter button found?

Question 43

____________________ refers to images such as a corporate logo, a picture, or a photo.

Question 44

The ____________________ feature automatically corrects some spelling errors as you type.

Question 45

Double-clicking the column line to the right of a column activates the ____ feature for the column.

A) AutoCorrect
B) Format
C) AutoFit
D) Format as Table

Question 46

You can change colors, patterns, and borders of cells by using the Fill tab and the Border tab in the ____ dialog box.

A) Page Setup
B) AutoCorrect
C) Insert
D) Format Cells

Question 47

Explain conditional formatting.

Question 48

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

A) Home
B) Data
C) Page Layout
D) Review

Question 49

The Find & Select button is found in the Editing group on the ____ tab on the Ribbon.

A) Home
B) Page Layout
C) Review
D) Data

Question 50

You can use colors, patterns, and borders to enhance the overall appearance of a worksheet and to make it easier to read. One of the ways of adding these enhancements is by using the Border and Fill Color buttons in the Font group on the ____ tab of the Ribbon.

A) Home
B) Data
C) Page Layout
D) Review

Question 51

As shown in the figure above, item ____ points to the button that adds lines or borders.

A) 3
B) 4
C) 7
D) 8

Question 52

The formatting due to ____ formatting is automatically updated if you change data in the worksheet.

A) conditional
B) spatial
C) dynamic
D) data

Question 53

What are the different ways of changing the font and font size of a cell or range?

Question 54

The ____________________ format adds dollar signs and two decimal places to the data.

Question 55

As shown in the figure above, item 3 is the ____________________ button and item 4 is the ____________________ button.

Question 56

What is meant by the format of a cell? How do you format a cell or range?

Question 57

The Spelling button is found in the Proofing group on the ____ tab on the Ribbon.

A) Home
B) Page Layout
C) Review
D) Data

Question 58

A small, ____ triangle appears in the upper-right corner of a cell containing a comment.

A) red
B) blue
C) green
D) yellow

Question 59

You insert a comment in a worksheet by using the ____ tab on the Ribbon.

A) Home
B) Review
C) Insert
D) View

Question 60

Explain why you would add colors, patterns, and borders to a worksheet. How do you add these enhancements in Excel?

Question 62

You are the administrator of a small hospital. You have been asked by some governmental agencies to keep track of the average waiting times for some of the types of procedures being performed at the hospital. You have created the following worksheet for this purpose. You have been asked by the government to highlight all the procedures in which the waiting time is greater than 10 days. Write the procedure for doing this using conditional formatting.

Question 63

You are the administrator of a small hospital. You have been asked by some governmental agencies to keep track of the average waiting times for some of the types of procedures being performed at the hospital. You have created the following worksheet for this purpose. You realize that you have left an empty row, row 7, in the middle of the data by mistake. Write the procedure for deleting row 7.

Question 64

Susan is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created the worksheet shown below. But she is not familiar with the formatting features of Excel and has asked you for help. You now need to further format the worksheet title and resize all the columns. a) Write the procedure for centering and merging the worksheet title over the columns A, B, C, and
d. b) Write the procedure for resizing columns A, B, and C using the AutoFit feature so that the widest entry in each column fits.

Question 65

Susan is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created the worksheet shown below. But she is not familiar with the formatting features of Excel and has asked you for help. The worksheet title and the labels would look better if they stood out more from the data. a) Write the procedure for changing the font of the worksheet title to Times New Roman and the font size to 16 using the Format Cells dialog box. b) Write the procedure for making the three labels bold using the Ribbon.

Question 66

Susan is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created the worksheet shown below. But she is not familiar with the formatting features of Excel and has asked you for help. You notice that the prices of the items would be easier to understand if they were shown with a dollar sign and all the values having two decimal places. Write the procedure for applying the Accounting Number format to the prices values.