Lesson 18 - Getting Started with Excel Essentials

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

____	1.	Excel 2010 uses the Microsoft Office Fluent user interface.

____	2.	The Ribbon in Excel is similar to the Ribbon used in Word.

____	3.	You can minimize the Ribbon by triple-clicking any of the Ribbon tabs.

____	4.	1A is an example of a cell reference.

____	5.	Press the down arrow to move to the next screen.

____	6.	To enter data in a cell, the cell must be active.

____	7.	The Enter and Cancel buttons appear in the formula bar even if you are not entering data.

____	8.	To select an entire row, click the row heading.

____	9.	All cells in a range touch each other and form a rectangle.

____	10.	By default, Excel includes the Repeat command on the Quick Access Toolbar.

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

____	1.	Excel refers to a spreadsheet as a ____.
a.	worksheet	c.	table	
b.	workbook	d.	database	

____	2.	Which of the following is NOT true about workbooks?
a.	Worksheets are always stored in workbooks.	
b.	You can only have one Excel workbook open at a time.	
c.	When working with large amounts of data, you can organize the data into multiple worksheets.	
d.	When you open a new blank workbook, Sheet1 appears in the worksheet window.	

____	3.	When you move the mouse pointer over the cells in the worksheet window, the mouse pointer changes to (a)n ____.
a.	one-sided arrow	c.	white plus sign	
b.	double-sided arrow	d.	I-beam	

____	4.	When you move the mouse pointer over the formula bar, the mouse pointer changes to a(n) ____.
a.	one-sided arrow	c.	white plus sign	
b.	double-sided arrow	d.	I-beam	

____	5.	In the accompanying figure, the text A1 is located in the ____.
a.	name box	c.	title bar	
b.	active cell	d.	formula bar	

____	6.	In the accompanying figure, the space to the right of “fx” is called the ____.
a.	name box	c.	title bar	
b.	active cell	d.	formula bar	

____	7.	To move to the right one cell, press ____.
a.	Right arrow	c.	Enter	
b.	Tab	d.	Either A or B	

____	8.	To move to the first cell in a row, press ____.
a.	Left arrow	c.	Home	
b.	Ctrl+Home	d.	Shift+Tab	

____	9.	The ____ view displays the column and row labels separated from the worksheet cells.
a.	Normal	c.	Full Screen Reading	
b.	Page Layout	d.	Page Break Preview	

____	10.	The ____ view hides the Ribbon, formula bar, and status bar.
a.	Normal	c.	Full Screen	
b.	Page Layout	d.	Page Break Preview	

____	11.	When you enter more numbers than can fit in a cell, ____.
a.	a series of number signs is displayed in the cell	
b.	you cannot enter any more numbers	
c.	by default, the column automatically widens to fit the new data	
d.	a dialog box opens	

____	12.	As data is entered in the cell, the ____ bar shows the content.
a.	title	c.	status	
b.	formula	d.	name	

____	13.	The ____ feature compares the first few characters you enter in a cell with existing entries in the same column and proposes text.
a.	AutoFill	c.	AutoComplete	
b.	AutoCorrect	d.	AutoFit	

____	14.	Which of the following is NOT true about inserting and deleting rows and columns?
a.	When you add a new column, the existing data shifts to the right.	
b.	When you insert or delete a row or column, it affects the entire worksheet.	
c.	To insert or delete multiple columns and rows, select the desired number of columns and rows before executing the command.	
d.	All of the above are true.	

____	15.	Which of the following is NOT true about copying and moving data?
a.	You can move or copy multiple cells of data at the same time.	
b.	When you paste data to a spreadsheet cell that already contains data, the existing data moves to make room for the new data.	
c.	The Clipboard is used to copy and paste data.	
d.	All of the above are true.	

____	16.	Which of the following is NOT true about the AutoFill command?
a.	Filling data is another method for copying data in a worksheet.	
b.	The Fill button is located in the Editing group on the Home tab.	
c.	AutoFill is faster than copying and pasting.	
d.	The AutoFill command can be used on nonadjacent cells.	

Amy is new to using Excel and is learning how to enter data.

____	17.	Amy learns that all of the following is true about using AutoFill to fill in a series, EXCEPT: ____.
a.	When you drag the fill handle down or to the right, the series is continued in descending order.	
b.	To fill a series, a pattern must be established in the initial selection of cells.	
c.	When you drag the fill handle, the pattern or series is continued.	
d.	You can modify the Fill settings in the Series dialog box.	

____	18.	Amy learns that when you point to the fill handle, the pointer changes to a(n) ____.
a.	white plus sign	c.	double-headed arrow	
b.	crosshair	d.	single-headed arrow	

Grant is modifying the structure of his worksheet.

____	19.	Grant presses F8 to enable the ____ mode.
a.	Edit	c.	Select	
b.	Insert	d.	Delete	

____	20.	Grant knows that the default column width is 8.43 ____.
a.	points	c.	kilobytes	
b.	pixels	d.	characters	

Lesson 18 - Getting Started with Excel Essentials
Answer Section

TRUE/FALSE

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

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

	3.	ANS:	F	PTS:	1	REF:	Mod 2-242

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

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

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

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

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

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

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

MULTIPLE CHOICE

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

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

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

	4.	ANS:	D	PTS:	1	REF:	Mod 2-241

	5.	ANS:	A	PTS:	1	REF:	Mod 2-241

	6.	ANS:	D	PTS:	1	REF:	Mod 2-241

	7.	ANS:	D	PTS:	1	REF:	Mod 2-243

	8.	ANS:	C	PTS:	1	REF:	Mod 2-243

	9.	ANS:	B	PTS:	1	REF:	Mod 2-245

	10.	ANS:	C	PTS:	1	REF:	Mod 2-246

	11.	ANS:	A	PTS:	1	REF:	Mod 2-247

	12.	ANS:	B	PTS:	1	REF:	Mod 2-247

	13.	ANS:	C	PTS:	1	REF:	Mod 2-249

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

	15.	ANS:	B	PTS:	1	REF:	Mod 2-254

	16.	ANS:	D	PTS:	1	REF:	Mod 2-256

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

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

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

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