Click on the correct response for each question below.

1		When formatting cells in a worksheet, this is simple to apply but it lacks versatility.
			A)	Format Painter button
			B)	Style
			C)	AutoFormat
			D)	Columns
2		If you apply this type of format to the value, 2345.5678, the cell will display as $2,345.
			A)	Currency format with zero decimal places
			B)	Number format with zero decimal places
			C)	Accounting format with zero decimal places
			D)	General format with zero decimal places
3		This format style will align numbers on the right side of a cell, text on the left side, indicates negative numbers with a minus sign on the left side of a number, and displays as many digits in a number as a cell’s width allows.
			A)	Number
			B)	Currency
			C)	General
			D)	Accounting
4		The Currency format is similar to this format, except the currency symbol is just to the left of the most significant digit and negative values are enclosed in parentheses.
			A)	Percentage
			B)	Number
			C)	Accounting
			D)	General
5		You can remove all formatting from a cell or a cell range by using this menu command.
			A)	Format/Edit/Clear
			B)	Tools/Edit/Clear
			C)	Edit/Clear/Format
			D)	File/Edit/Clear
6		In the Accounting format, the default number of decimal places is
			A)	2.
			B)	3.
			C)	4.
			D)	5.
7		This formatting will align values in the same way as the Currency format by adding a character to the right side of each value.
			A)	Decimal
			B)	Numeric
			C)	Data
			D)	Comma
8		When you have a column of numeric values with different sizes, you should align the values so their decimal places
			A)	are lined up horizontally.
			B)	are lined up to the right of the cell.
			C)	are lined up vertically.
			D)	are centered in the cell.
9		When placing a title or text label describing several columns in a worksheet, it is often best to
			A)	center them over the columns using the Left Align button.
			B)	center them over the columns using the Center Align button
			C)	center them over the columns using the Right Align button.
			D)	center them over the columns using the Merge and Center button.
10		This is the menu command used to center a worksheet title and subtitle across several columns.
			A)	Tools/Cells/Alignment
			B)	Format/Cells/Alignment
			C)	Edit/Cells/Alignment
			D)	Insert/Cells/Alignment
11		Formatting cells in Excel changes both the appearance and contents of the cells.
			A)	True
			B)	False
12		To change how multiple cells look, right-click within the selected range and select the Format Cells command from the shortcut menu.
			A)	True
			B)	False
13		On the Formatting toolbar, a ScreenTip briefly describes the functionality of the selected button.
			A)	True
			B)	False
14		Within Excel, the number format is used to designate significant digits, comma separators, and how negative numbers are displayed.
			A)	True
			B)	False
15		A cell displaying a series of pound (#) signs indicates the column is too narrow to display its contents.
			A)	True
			B)	False
16		When using the Accounting format in a worksheet, currency symbols should be displayed on each value in a column.
			A)	True
			B)	False
17		The advantage of using AutoFormat commands on a worksheet's cells is that the formatting duplicates all of a cell's formats at once.
			A)	True
			B)	False
18		Excel automatically aligns text on the right side of a cell while aligning values and formula results to the left.
			A)	True
			B)	False
19		Text headings at the top of a column must be left-aligned above the data below.
			A)	True
			B)	False
20		The Accounting format can be used to align text as well as numbers.
			A)	True
			B)	False