Homework answers / question archive / Chapter 14: Formatting a Workbook   TRUE/FALSE        1) Formatting is the process of changing a workbook’s substance by changing the details and data within cells

Chapter 14: Formatting a Workbook   TRUE/FALSE        1) Formatting is the process of changing a workbook’s substance by changing the details and data within cells

Computer Science

Share With

---

 

TRUE/FALSE

 

     1) Formatting is the process of changing a workbook’s substance by changing the details and data within cells.

 

 

     2.   When choosing colors, you can specify a mixture of red, blue, and green color values, making available 16.7 million custom colors.

 

     3.   Excel stores dates and times as numbers.

 

     4.   Blending combines two or more cells into one cell.

 

     5.   You can specify the thickness and the number of lines in a border.

 

     6.   Background colors are also known as fill colors.

 

     7.   By default, the Total row adds the numbers in the last column of an Excel table, or counts the number of records if the data in the last column contains text.

 

     8.   Cell branding changes a cell’s font color or background fill color, or both, based on the cell’s value.

 

     9.   The region sent to the printer from the active sheet is known as the print area.

 

   10.   The image above shows a worksheet in Normal view.

 

MODIFIED TRUE/FALSE

 

     1.   A workbook’s theme contains 12 theme colors.

 

 

     2.   Excel formats numbers in the General number format.

 

     3.   The mm/dd/yyyy format is known as the Abbreviated Date format.

 

     4.   A(n) scheme is a selection of formatting options using a specific font and color from the current theme.

 

     5.   The buttons in the figure above can be found in the Alignment group on the Home tab.

 

 

     6.   Standard accounting practice is to apply a single top border and a double bottom border to subtraction rows to distinguish them from financial data.

 

 

     7.   The Format Cells dialog box provides more formatting choices than formats applied directly from the Home tab.

 

 

     8.   A column in an Excel table in which all cells in the column have the same formula copied to them is called a(n) calculated column.

 

     9.   A(n) hard title is information from a workbook that appears on every printed page.

 

   10.   A(n) footer is information that is printed in the bottom margin of each printed page.

MULTIPLE CHOICE

 

     1.   Excel organizes its formatting tools in terms of ____.

a.	panels	c.	themes
b.	labels	d.	styles

 

 

     2.   Formatting text involves changing all of the following EXCEPT ____.

a.	fonts	c.	font styles
b.	font layering	d.	font sizes

 

 

     3.   The text recommends all of the following to improve the appearance of your workbook EXCEPT ____.

a.	tightening text up so it all fits on one page of a worksheet	c.	using consistent formatting throughout the workbook
b.	placing the most important information first	d.	identifying each worksheet’s purpose

 

 

 

     4.   If you want to format text with a font that will not change when the theme is changed, use a(n) ____ font.

a.	ephemeral	c.	theme
b.	non-theme	d.	scheme

 

 

 

     5.   ____ of a theme’s theme colors is/are designated for text and backgrounds.

a.	None	c.	Four
b.	One	d.	Twelve

 

 

 

     6.   You can change number formats by using the Number group on the ____ tab.

a.	Formulas	c.	Insert
b.	Page Layout	d.	none of the above

 

 

 

     7.   The accounting style would render the number -56 as ____.

a.	-56.0	c.	-$5.6e1
b.	-56	d.	(56)

 

 

 

     8.   By default, when you format values as percentages, ____ digits will appear to the right of the decimal point.

a.	zero	c.	six
b.	two	d.	depends on the width of the cell

 

 

 

     9.   When you decrease the number of decimal places shown in a cell, the value ____.

a.	is rounded	c.	is shorn
b.	is truncated	d.	is recalculated

 

 

 

   10.   ____ format will display the day of the week and the full month name, in addition to the day of the month and the year.

a.	Extended Date	c.	Short Date
b.	Long Date	d.	Full Date

 

 

 

   11.   The figure above shows a(n) ____.

a.	number too long to display in a cell	c.	input field
b.	password field	d.	hidden cell

 

 

   12.   Applying AutoFit to the cell in the figure above would ____.

a.	shrink the font in the cell	c.	widen the column so that the value would fit
b.	have no effect	d.	apply a pre-recorded password to the field

 

 

 

   13.   In Excel, times are stored as ____.

a.	text	c.	numbers measuring the interval between midnight January 1, 1900 and the input times
b.	fractional parts of one day	d.	none of the above

 

 

 

   14.   A ____ is a selection of formatting options using a specific font and color from the current theme.

a.	style	c.	panel
b.	scheme	d.	layout

 

 

 

   15.   By default, cell values are aligned with the ____ and ____ borders of the cell.

a.	right, bottom	c.	right, middle
b.	left, bottom	d.	top, center

 

   16.   In the figure above, box ____ represents the Align Text Left button.

a.	A	c.	D
b.	C	d.	F

 

 

   17.   In the figure above, box ____ represents the Increase Indent button.

a.	B	c.	H
b.	G	d.	E

 

 

   18.   In the figure above, box ____ represents the Wrap Text button.

a.	E	c.	J
b.	I	d.	K

 

 

   19.   When you merge cells, only the content in the ____ cell in the range is retained.

a.	center	c.	upper-right
b.	upper-left	d.	largest

 

 

 

   20.   Choosing ____ orientation for cell content will rotate that content to appear stacked from the top of the cell to the bottom.

a.	Rotate Text Up	c.	Vertical Text
b.	Rotate Text Down	d.	either a or b

 

 

   21.   You can add a border to a ____.

a.	cell	c.	both a and b
b.	range	d.	neither a nor b

 

 

 

   22.   By default, gridlines ____ and borders ____.

a.	print, print	c.	don’t print, don’t print
b.	don’t print, print	d.	print, don’t print

 

 

 

   23.   You can add background colors, known as ____ colors, to a cell’s background.

a.	fill	c.	style
b.	theme	d.	contrast

 

 

 

   24.   When choosing colors, remember that ____ color blindness is the most common.

a.	blue-yellow	c.	red-green
b.	violet	d.	pastel

 

 

 

   25.   All of the following are tabs on the Format Cells dialog box EXCEPT ____.

a.	Alignment	c.	Link
b.	Fill	d.	Protection

 

 

 

   26.   The Paste option that opens a dialog box giving you the most control over how exactly to paste an object is ____.

a.	Paste Detailed	c.	Paste Options
b.	Paste	d.	Paste Special

 

 

 

   27.   When you create an Excel table, ____ appear next to each column label.

a.	arrows	c.	table icons
b.	asterisks	d.	none of the above

 

 

 

   28.   A ____ specifies formats for an entire table, rather than individual cells.

a.	table style	c.	global style
b.	table scheme	d.	format theme

 

 

 

   29.   ____ is formatting that displays alternate rows in an Excel table with different fill colors.

a.	Weatherstripping	c.	Fluted columns
b.	Banded rows	d.	Pinstriping

 

 

 

   30.   You find the Table Style Options group on the ____ tab.

a.	Home	c.	Page Layout
b.	Table Tools Design	d.	Excel Table

 

 

 

   31.   Conditional formatting applies formatting only when ____ meets a specified condition.

a.	a worksheet	c.	a cell’s value
b.	a cell’s layout	d.	a column’s position

 

 

 

   32.   You find the Conditional Formatting button within the ____ tab.

a.	Home	c.	Page Layout
b.	Insert	d.	Table Tools Design

 

 

 

   33.   Clearing a conditional formatting rule ____.

a.	deletes the contents of a cell	c.	either a or b, depending on the situation
b.	alters the contents of a cell	d.	neither a nor b

 

 

   34.   To reach the Hide & Unhide submenu, you must click the ____ button in the Cells group on the Home tab.

a.	Visualize	c.	Synchronize
b.	Format	d.	Conditions

 

 

 

   35.   The region sent to the printer from the active sheet is known as the ____.

a.	preview page	c.	gutter
b.	print area	d.	live sheet

 

 

 

   36.   A page break is inserted ____ a cell.

a.	above and to the left of	c.	below and to the left of
b.	above and to the right of	d.	below and to the right of

 

 

 

   37.   A(n) ____ is information from a worksheet that appears on every printed page.

a.	info header	c.	print title
b.	footer layer	d.	A-head

 

 

 

   38.   Headers and footers have ____ section(s) each.

a.	one	c.	four
b.	three	d.	six

 

 

   39.   A ____ is the space between the page content and the edges of the page.

a.	gutter	c.	rim
b.	border	d.	margin

 

 

 

   40.   You can center the content of the current sheet for printing by using the Margins tab in the ____ dialog box.

a.	Header & Footer Tools	c.	Page Setup
b.	Table Tools Design	d.	Page Layout

 

 

Case-Based Critical Thinking Questions

 

Case 14-1

You’ve taken the chapter’s five rules for formatting workbooks for readability and appeal to heart. For each of the following questions, choose the rule that is being followed in the question.

 

   41.   You put summary worksheets at the front, and save the highly detailed worksheets for the end of the workbook.

a.	Clearly identify each worksheet’s purpose.	c.	Use consistent formatting throughout the workbook.
b.	Don’t crowd a worksheet with too much information.	d.	none of the above

 

 

 

   42.   You found that one worksheet contains several large numbers that use the thousands separator. You made sure to use the thousands separator in the other worksheets.

a.	Always turn the Comma Style button on.	c.	Use consistent formatting throughout the workbook.
b.	Place the most important information first in the workbook.	d.	Pay attention to the formatting of the printed workbook.

 

 

 

   43.   You have gone back and inserted headers and footers in all of your worksheets with the title of the worksheet and information about that worksheet. You have also made sure to include descriptive column and row titles as well.

a.	More is better than less.	c.	Clearly identify each worksheet’s purpose.
b.	Don’t crowd a worksheet with too much information.	d.	Give each worksheet unique formatting.

 

 

 

Case-Based Critical Thinking Questions

 

Case 14-2

You’ve clearly not taken the chapter’s five rules for formatting workbooks for readability and appeal to heart! For each of the following questions, choose the rule that is being broken in the question.

 

   44.   In the first worksheets, you used green to denote increasing sales figures, and red to denote decreasing figures. However, in the last two worksheets, for emphasis you used blue for increasing and orange for decreasing.

a.	Remember the color wheel.	c.	Don’t crowd a worksheet with too much information.
b.	Use consistent formatting throughout the workbook.	d.	Pay attention to the formatting of the printed workbook.

 

 

 

   45.   You build slowly to your final point, beginning with worksheets filled with analysis up front, and finishing with a  brief “knockout” summary page.

a.	Place the most important information first in the workbook.	c.	Pay attention to the formatting of the printed workbook.
b.	Keep the workbook to five pages or less.	d.	Balance the information evenly across worksheets.

 

 

 

   46.   You have saved space by placing all of your topics on one long worksheet, which a reader can simply scroll left and right or up and down to view.

a.	Write for your audience, not yourself.	c.	Place the most important information first in the workbook.
b.	Use consistent formatting throughout the workbook.	d.	none of the above

 

 

 

Case-Based Critical Thinking Questions

 

Case 14-3

The chapter listed some specific highlighting rules and the conditions in which you might use them. For the following questions, choose the correct highlighting rule.

 

   47.   You wish to highlight all cells that have the value $4.53.

a.	Same	c.	Equal To
b.	Top 10%	d.	Is

 

 

 

   48.   You wish to highlight all cells from $50 to $499.

a.	Greater-Less	c.	Between
b.	Greater Than	d.	Within

 

 

 

   49.   You wish to highlight all cells that read “San Antonio”.

a.	This Word	c.	String Equals
b.	Text That Contains	d.	Equal To

 

 

 

   50.   You wish to highlight all cells with the date April 4, 2013.

a.	Equal To	c.	A Date Occurring
b.	Text That Contains	d.	This Day

 

 

 

COMPLETION

 

     1.   ____ can be formatted to display symbols such as $ and %, thousands separators, and decimal places.

 

 

     2.   By specifying a mixture of three colors—____, ____, and ____—you can make available 16.7 million custom colors.

 

 

     3.   You use the ____ button to add thousands separators.

 

 

     4.   Excel uses standard rounding practices; so if a number is ____ or higher, the value is rounded up and the number to its left is increased by one.

 

     5.   A date entered in mm/dd/yyyy format is said to be in ____ Date format.

 

 

     6.   You find Excel’s built-in styles in the ____ gallery.

 

     7.   Cell text is, by default, aligned with the ____ and ____ borders of a cell.

 

     8.   ____ combines two or more cells into one cell.

 

     9.   The ____ tab in the Format Cells dialog box provides options for creating and applying background colors and patterns to cells.

 

 

   10.   Excel tables can include optional elements such as a(n) ____ row that contains formulas summarizing the values in the table’s data.

 

 

   11.   Many tables display alternate rows with different fill colors, known as ____ rows.

 

 

   12.   After you apply a table style, you can change its settings using the Table Style Options group located on the ____ tab.

 

   13.   Each time you apply a conditional format, you are creating a(n) ____.

 

 

   14.   You can hide or unhide a row by right-clicking ____ and clicking Hide or Unhide on the shortcut menu.

 

 

   15.   By default, Excel prints as much of the content of a worksheet that fits on a single page without resizing the content, and then inserts ____ to continue printing the remaining worksheet content on successive pages.

 

MATCHING

 

 

a.	Comma Style button	g.	Orientation
b.	table style	h.	style
c.	Office	i.	border
d.	conditional formatting	j.	number format
e.	margin	k.	print area
f.	fill colors	l.	Long Date

 

 

     1.   the format displaying the day of week and full month

 

     2.   the space between page content and the edges of a page

 

     3.   adds thousands separator

 

     4.   the region sent to the printer from the active sheet

 

     5.   displays values in a way that makes it easy to be understood and interpreted

 

     6.   a line you add along an edge of a cell

 

     7.   specifies formats for an entire Excel table

 

     8.   background colors

 

     9.   the default theme

 

   10.   the format of a cell that depends on the value or content of that cell

 

   11.   the button that rotates the cell content to any angle within the cell

 

   12.   a selection of formatting options using a specific font and color from the current theme

 

ESSAY

 

     1.   How do the Accounting and Currency formats differ? And what is the subtle difference between using the Accounting Number Format button and the Comma Style button?

 

     2.   The text offers six guidelines for using color effectively to enhance a workbook. Name and briefly discuss at least four of them.

 

 

     3.   The text offers four guidelines for using conditional formatting effectively. Name and briefly discuss all four.