Deck 2: Formatting a Workbook

Question 1

Background images do not print in Excel.

Answer 1

True

Question 2

You can rotate cell contents in Excel so that they appear at any angle or orientation.

Answer 2

True

Question 3

If you use colors that are not part of a theme,changing the theme will not change those colors.

Answer 3

True

Question 4

If you insert a new row at the top of the table,the new row becomes the header row and is formatted with the table style.

Question 5

After you merge a range into a single cell,you cannot realign its content.

Question 6

Formatting changes only the appearance of data - it does not affect the data itself.

Question 7

You can use a picture or image as the background for all the cells in a worksheet.

Question 8

Excel has only two conditional formats-data bars and highlighting.

Question 9

It is not good practice to include descriptive information,such as the company name,logo,and worksheet title on each page of a printout in case a page gets into the wrong hands.

Question 10

Red-green color blindness is the most common,so avoid using red text on a green background or green text on a red background.

Question 11

When you use conditional formatting to highlight cells in a worksheet,you do not need to include a legend.

Question 12

When you add a table style,be sure that all formatting is as you want it because table styles in Excel cannot be formatted once applied.

Question 13

If you revise a style in Excel,the appearance of any cell formatted with that style must be updated manually.

Question 14

Top/Bottom Rules is a form of Conditional Formatting that allows you options to select the bottom 10% of data.

Question 15

By default,text is black and cells have no background fill color.

Question 16

A conditional format can make negative numbers red and positive numbers black.

Question 17

When a worksheet is printed,the gridlines that surround the cells are printed by default.

Question 18

Modifying the number format affects the value stored in the workbook.

Question 19

Conditional formats are dynamic,so a cell's appearance will change to reflect its current value.

Question 20

A table style treats the table as a single object rather than a collection of cells.

Question 21

Calculated values too large to fit into the cell are displayed in scientific notation._________________________

Question 22

MATCHING
Match each of the following icons with the description that most closely matches its function.

Decreases the size of the indentation used in the cell

Question 23

A conditional format applies formatting only when a cell's value meets a specified condition._________________________

Question 24

MATCHING
Match each of the following icons with the description that most closely matches its function.

Increases the size of the indentation used in the cell

Question 25

Although dates and times in Excel appear as text,they are actually numbers._________________________

Question 26

In Microsoft Excel,you can open an extended color palette of 134 standard colors._________________________

Question 27

To filter data in an Excel table,use filter blocks in the header row._________________________

Question 28

The Banded Columns element formats alternating columns in different colors._________________________

Question 29

A frame is a line you add along an edge of a cell to improve readability of the data._________________________

Question 30

A sans serif font,such as Arial,does not include decorative strokes on each character._________________________

Question 31

Excel uses themes to maintain a consistent look within a workbook._________________________

Question 32

A print area can cover an adjacent or nonadjacent range._________________________

Question 33

MATCHING
Match each of the following icons with the description that most closely matches its function.

Vertically centers the cell content within the cell

Question 34

Applying a table theme also marks the range as an Excel table._________________________

Question 35

MATCHING
Match each of the following icons with the description that most closely matches its function.

Aligns the cell content with the cell's bottom edge

Question 36

Table styles have six elements that can be turned on or off._________________________

Question 37

Font sizes are measured in points,where one is approximately 1/72 of an inch._________________________

Question 38

The appearance of text is determined by its type character._________________________

Question 39

MATCHING
Match each of the following icons with the description that most closely matches its function.

Aligns the cell content with the cell's top edge

Question 40

If contents do not fit across the Excel page,change the orientation to Portrait orientation._________________________

Question 41

A ____ is not a type of font.

A) serif
B) sans serif
C) theme
D) true type

Question 42

MATCHING
Match each of the following icons with the description that most closely matches its function.

Merges the selected cells into a single cell

Question 43

To change the font size one point at a time,in the Font group on the Home tab,click the ____ button.

A) Increase Font Size
B) Decrease Font Size
C) Change Font Size
D) either a or b

Question 44

MATCHING
Match each of the following icons with the description that most closely matches its function.

Forces the cell text to wrap within the cell borders

Question 45

One of the benefits of Live Preview is that ____.

A) it lets you see and evaluate different formats as you develop your workbook
B) it shows you what a document will look like when printed
C) it applies thematic styles to your document
D) it allows you to track changes in your document

Question 46

In the above figure,the ____ indicates the font is 11pt.

A) Font arrow
B) Font size arrow
C) Font color
D) Font graphic

Question 47

You can create a ____ color by specifying a mixture of red,blue,and green color values.

A) standard
B) custom
C) theme
D) automatic

Question 48

MATCHING
Match each of the following icons with the description that most closely matches its function.

Decreases decimal place

Question 49

MATCHING
Match each of the following icons with the description that most closely matches its function.

Horizontally centers the cell content within the cell

Question 50

MATCHING
Match each of the following icons with the description that most closely matches its function.

Aligns the cell content with the cell's right edge

Question 51

In the figure above,an example of a theme font is ____.

A) Algerian
B) Calibri
C) Arial
D) Batang

Question 52

In the figure above,an example of a non-theme font is ____.

A) Algerian
B) Calibri
C) Arial
D) all of the above

Question 53

MATCHING
Match each of the following icons with the description that most closely matches its function.

Aligns the cell content with the cell's left edge

Question 54

____ theme colors are designated for text and background,____ colors are used for accents and highlights,and ____ colors are used for hyperlinks.

A) Four,two,six
B) Two,four,six
C) Four,six,two
D) Six,four,two

Question 55

Italic,bold,bold italic,and underline are examples of ____.

A) font themes
B) font styles
C) graphics
D) character settings

Question 56

When you don't want to associate a font with a particular design,you use a ____ font.

A) theme
B) serif
C) sans serif
D) non-theme

Question 57

Typeface is the specific design used for characters and includes ____.

A) lettering
B) numbering
C) punctuation marks and symbols
D) all of the above

Question 58

To add a ____ to a sheet tab,click the Format button,point to Tab color,and then click a color.

A) fill color
B) tab setting
C) format color
D) formatting style

Question 59

In the above figure,it shows that ____ is the theme font used for headings.

A) Algerian
B) Batang
C) Cambria
D) Calibri

Question 60

MATCHING
Match each of the following icons with the description that most closely matches its function.

Rotates the cell content to any angle within the cell

Question 61

In Excel,dates are ____-aligned in the cell by default,regardless of date format.

A) right
B) left
C) center
D) not

Question 62

In Excel,to merge cells A1,B1,C1,D1,and E1,____ is the correct reference for the merged cell.

A) A1!E1!
B) A1$E1$
C) A1:E1
D) A1-E1

Question 63

In the above figure,the preset button labeled ____ removes all borders.

A) None
B) Outline
C) Inside
D) none of the above

Question 64

Options to rotate cells in Excel are available using the ____ button in the Alignment group on the Home tab.

A) Format
B) Orientation
C) Sorter
D) Alignment

Question 65

The background image does not affect any cell's ____.

A) format
B) content
C) both a.and b.
D) neither a.nor b.

Question 66

In the above figure,the preset button labeled ____ adds lines within the range.

A) None
B) Outline
C) Inside
D) none of the above

Question 67

Dates and times in Excel measure intervals between the specified date and time and ____.

A) January 1,2000 at 12:00pm
B) January 1,2000 at 12:00am
C) January 1,1900 at 12:00am
D) January 1,1900 at 12:00pm

Question 68

____ merges each of the rows in the selected range across the columns in the range.

A) Merge build
B) Merge and Center
C) Merge Across
D) Merge Cells

Question 69

In the Format Cells dialog box,the ____ tab allows you to format currency by choosing decimal places,comma separators,and regular number displays.

A) Number
B) Font
C) Alignment
D) Protection

Question 70

You can add a border in Excel ____.

A) to enhance readability
B) to the top,right,or bottom of a cell
C) and specify the thickness
D) all of the above

Question 71

Which of the following can you format using the Number group in Excel's home tab?

A) currency formats
B) numbers to percentages
C) commas as a thousands separator
D) all of the above

Question 72

Selecting the Font Color button arrow will display ____.

A) 10 theme colors
B) a standard color bar
C) a ScreenTip displaying the color name
D) all of the above

Question 73

The information shown in the box under the heading "Style:" are ____.

A) cell line styles
B) data line styles
C) heading line styles
D) border line styles

Question 74

When creating an Excel document,you should avoid using ____ text and background together,since this is the most common form of color blindness.

A) red and green
B) yellow and blue
C) black and white
D) red and yellow

Question 75

By default,numbers appear in the ____ and generally display values exactly as you type them.

A) Home tab
B) General number format
C) General number toolbar
D) currency format

Question 76

In the above figure,the preset button labeled ____ adds a border around the entire cell or range.

A) None
B) Outline
C) Inside
D) none of the above

Question 77

All of the following options are available on the Format Cells dialog box except ____.

A) number
B) font
C) border
D) size

Question 78

Because Excel stores dates and times as ____,you can apply different formats without affecting the date and time value.

A) numbers
B) text
C) both a.and b.
D) neither a.nor b.

Question 79

As a general rule,you should ____.

A) center column titles,left-align text,and right-align numbers
B) center column titles,right-align text,and left-align numbers
C) right-align column titles,left-align text,and right-align numbers
D) left-align column titles,left-align text,and right-align numbers

Question 80

In the figure above the border line color is ____.

A) green
B) dashed
C) outlined
D) you cannot tell from the figure