Lesson 19 - Organizing and Enhancing Worksheets

True/False
Indicate whether the statement is true or false.

____	1.	Common uses of spreadsheets include reporting finances and managing expenses.

____	2.	The default Zoom setting is 75%.

____	3.	To remove a split in a worksheet, double-click the dividing line.

____	4.	When you use the Insert Sheet button, the new sheet tab appears to the right of the active sheet tab.

____	5.	By default, Excel prints comments that are added to the worksheet.

____	6.	When you use the Cut and Copy commands, the data and formats are also moved or copied.

____	7.	Excel automatically adjusts the cell width when the font size changes.

____	8.	You can use the Format Painter feature to copy formats.

____	9.	If the text does not fit on one line of a cell, you can wrap to new lines.

____	10.	When you sort data, you screen data that matches specified criteria; the data that does not meet the criteria is hidden.

Multiple Choice
Identify the choice that best completes the statement or answers the question.

____	1.	A(n) ____ contains column headings or field names in a data source.
a.	header row	c.	table header	
b.	column header	d.	footer	

____	2.	When you ____ columns and/or rows, you lock them so you can keep an area visible as you scroll through the worksheet.
a.	split	c.	hide	
b.	freeze	d.	unhide	

____	3.	In the above figure, the worksheet has been ____.
a.	merged	c.	split	
b.	frozen	d.	unhidden	

____	4.	Which of the following is NOT true about working with multiple worksheets?
a.	When you need to add a new category to a workbook, you add a new worksheet.	c.	You can copy and paste data from one worksheet to another.	
b.	Sheet tabs are located at the top of the workbook window.	d.	All of the above are true.	

____	5.	By default, new blank workbooks include ____ worksheets.
a.	zero	c.	two 	
b.	one	d.	three	

____	6.	Which of the following is NOT true about changing the page setup?
a.	Page Break Preview shows you how the worksheet will be printed.	c.	The default setting is landscape orientation.	
b.	You can drag the page break to a new location.	d.	The Fit to command fits the worksheet to a specific number of pages.	

____	7.	Which of the following is TRUE about the figure above?
a.	The workbook is in Page Break Preview.	c.	The workbook contains hidden columns.	
b.	The workbook is split.	d.	There are frozen panes.	

____	8.	The header and footer commands are located on the ____ tab.
a.	Home	c.	Page Layout	
b.	File	d.	Insert	

____	9.	Which of the following is NOT true about default print options in Excel?
a.	Gridlines, row numbers, and column letters are printed.	c.	When you create a print area, the print setting is saved with the workbook.	
b.	Excel prints the entire worksheet	d.	You can choose to print the row and/or column headings on every page.	

____	10.	You can easily change the print settings using commands in the ____.
a.	Page Layout dialog box	c.	Home tab	
b.	Backstage view	d.	Either A or B.	

____	11.	The font size is a measurement in ____ that determines the height of the font.
a.	characters	c.	pixels	
b.	points	d.	millimeters	

____	12.	A(n) ____ is the design of the typeface.
a.	point	c.	font	
b.	style	d.	format	

____	13.	By default, Excel aligns numbers at the ____ of the cell.
a.	right	c.	center	
b.	left	d.	top	

____	14.	Which of the following is NOT true about changing alignment?
a.	By default, Excel aligns text at the left of the cell.	c.	You can decrease the margin between the edge of the cell and cell contents.	
b.	You can adjust the alignment of the content of a cell vertically.	d.	All of the above are true.	

____	15.	The default date style is ____.
a.	1/20/14	c.	20-Jan-14	
b.	1-20-2014	d.	January 20, 2014	

____	16.	Which of the following is NOT true about table styles?
a.	If you convert the table to a regular range, the table style formatting is removed.	c.	You can choose from 60 table styles in the Quick Styles gallery.	
b.	A table style is a set of predefined formats you can apply to worksheet data.	d.	All of the above are true.	

Cate has finished entering data and formatting her worksheet and is ready to print and share it with others.

____	17.	Cate wants to share her workbook electronically, but doesn’t want the recipients to be able to modify the data. One of her options is to save it as a(n) ____ file.
a.	PDF	c.	.xlsx	
b.	HTML	d.	template	

____	18.	Cate wants to print her workbook. By default, which of the following will print?
a.	Comments	c.	Column letters	
b.	Header row	d.	Gridlines	

Santiago has entered data in his worksheet and is working on fine-tuning the display.

____	19.	Santiago applies conditional formatting. Which of the following is NOT one of the options?
a.	Data Bars	c.	Quick Styles	
b.	Color Scales	d.	Icon Sets	

____	20.	Santiago wants to be able to view and scroll through different parts of the worksheet at the same time. He ____ the worksheet.
a.	hides	c.	freezes	
b.	filters	d.	splits	

Lesson 19 - Organizing and Enhancing Worksheets
Answer Section

TRUE/FALSE

	1.	ANS:	T	PTS:	1	REF:	Mod 2-266

	2.	ANS:	F	PTS:	1	REF:	Mod 2-267

	3.	ANS:	T	PTS:	1	REF:	Mod 2-270

	4.	ANS:	F	PTS:	1	REF:	Mod 2-271

	5.	ANS:	F	PTS:	1	REF:	Mod 2-276

	6.	ANS:	T	PTS:	1	REF:	Mod 2-279

	7.	ANS:	F	PTS:	1	REF:	Mod 2-279

	8.	ANS:	T	PTS:	1	REF:	Mod 2-279

	9.	ANS:	T	PTS:	1	REF:	Mod 2-281

	10.	ANS:	F	PTS:	1	REF:	Mod 2-291

MULTIPLE CHOICE

	1.	ANS:	A	PTS:	1	REF:	Mod 2-266

	2.	ANS:	B	PTS:	1	REF:	Mod 2-268

	3.	ANS:	C	PTS:	1	REF:	Mod 2-270

	4.	ANS:	B	PTS:	1	REF:	Mod 2-270

	5.	ANS:	D	PTS:	1	REF:	Mod 2-270

	6.	ANS:	C	PTS:	1	REF:	Mod 2-272

	7.	ANS:	A	PTS:	1	REF:	Mod 2-273

	8.	ANS:	D	PTS:	1	REF:	Mod 2-275

	9.	ANS:	A	PTS:	1	REF:	Mod 2-276

	10.	ANS:	D	PTS:	1	REF:	Mod 2-276

	11.	ANS:	B	PTS:	1	REF:	Mod 2-279

	12.	ANS:	C	PTS:	1	REF:	Mod 2-279

	13.	ANS:	A	PTS:	1	REF:	Mod 2-281

	14.	ANS:	D	PTS:	1	REF:	Mod 2-281

	15.	ANS:	C	PTS:	1	REF:	Mod 2-282

	16.	ANS:	A	PTS:	1	REF:	Mod 2-288

	17.	ANS:	A	PTS:	1	REF:	Mod 2-293	TOP:	Critical Thinking

	18.	ANS:	B	PTS:	1	REF:	Mod 2-276	TOP:	Critical Thinking

	19.	ANS:	C	PTS:	1	REF:	Mod 2-285	TOP:	Critical Thinking

	20.	ANS:	D	PTS:	1	REF:	Mod 2-268	TOP:	Critical Thinking