Lesson 20 - Creating Formulas and Charting Data

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

____	1.	To create a minus sign in a formula, use the hyphen key.

____	2.	When creating formulas, there must be a closing parenthesis for every opening parenthesis.

____	3.	You can change the order of evaluation by using hyphens.

____	4.	=$A1 is a formula with an absolute reference.

____	5.	A shortcut to entering cell references is to name a range of cells.

____	6.	The COUNT and SUM functions are interchangeable.

____	7.	3D references are often used in summary worksheets to condense and total data from other worksheets.

____	8.	An error value appears if the cell is not wide enough to show the result.

____	9.	Charts are not objects, like clip art images or photos.

____	10.	You can create multiple sparklines at the same time.

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

____	1.	All Excel formulas begin with ____.
a.	the equal sign	c.	a value	
b.	a number	d.	an operand	

____	2.	Which of the following is NOT true about creating formulas?
a.	Multiplication and division are performed before addition and subtraction.	
b.	When entering the cell reference, the column letters must be uppercase.	
c.	Calculations in parentheses are performed first.	
d.	Generally, cell references are used in formulas instead of the actual value.	

____	3.	A(n) ____ cell reference does not change when the formula is copied or moved.
a.	mixed	c.	absolute	
b.	complex	d.	relative	

____	4.	____ formulas perform calculations that you could perform using a scientific calculator.
a.	Complex	c.	Statistical	
b.	Embedded	d.	Mathematical	

____	5.	____ formulas perform calculations that describe large quantities of data.
a.	Complex	c.	Statistical	
b.	Embedded	d.	Mathematical	

____	6.	The ____ function multiples values in the specified cells.
a.	=PRODUCT	c.	=COUNT	
b.	=SUM	d.	=MEDIAN	

____	7.	The ____ is a value, cell reference, range, or text used in a function.
a.	operator	c.	operand	
b.	argument	d.	formula	

____	8.	Which of the following is NOT true about creating a function?
a.	Several common functions are available by clicking a button on the Ribbon.	
b.	You can collapse and expand the Function Arguments dialog box.	
c.	You can drag the fill handle to copy a formula across a column.	
d.	All of the above are true.	

____	9.	Two non-adjacent cells are distinguished in a function using a ____.
a.	comma	c.	semi-colon	
b.	colon	d.	hyphen	

____	10.	____ refers to the ability to connect worksheets by creating formulas that reference the same cell or range in multiple worksheets.
a.	Length	c.	Depth	
b.	Width	d.	All of the above.	

____	11.	The ____ error occurs when the column is not wide enough or a negative date is entered.
a.	#VALUE!	c.	####	
b.	#N/A	d.	#REF!	

____	12.	The ____ error occurs when the wrong type of argument or operand is used.
a.	#VALUE!	c.	####	
b.	#N/A	d.	#REF!	

____	13.	The ____ error occurs when the contents of cells referred to by other formulas are deleted.
a.	#VALUE!	c.	####	
b.	#N/A	d.	#REF!	

____	14.	Which of the following is NOT true about charts?
a.	Charts are used to draw or present conclusions about data.	
b.	If a chart is not set up correctly, the representation can be confusing or misleading.	
c.	The first step is to decide what type of chart you want to create.	
d.	All charts have a horizontal and vertical axis.	

____	15.	The accompanying figure shows ____ in column F.
a.	sparklines	c.	chart sheets	
b.	embedded charts	d.	functions	

____	16.	Which of the following is NOT true about the contents of column F in the accompanying figure?
a.	They can be used to show a trend.	
b.	You can use built-in formats to apply a color scheme.	
c.	You can customize the graphic to choose a color for high, low, first, and last values.	
d.	All of the above are true.	

Rajit wants to display the data in his worksheet using graphics.

____	17.	Rajit knows that all of the following is true about charts, EXCEPT: ____.
a.	You cannot change the type of a chart.	
b.	You can resize a chart by dragging a sizing handle on the canvas.	
c.	To remove a chart element, select it, then press Delete.	
d.	An embedded chart is useful if you want to view the chart and data at the same time.	

____	18.	Rajit decides to show snapshots of the data for each row in his worksheet. He inserts ____.
a.	functions	c.	charts	
b.	sparklines	d.	graphics	

Tyler is teaching Eleni how to perform calculations in her Excel worksheet.

____	19.	Tyler tells Eleni that the * (asterisk) character is used to represent ____.
a.	addition	c.	multiplication	
b.	subtraction	d.	division	

____	20.	Tyler tells Eleni that ____ is an absolute cell reference.
a.	A1	c.	A$1	
b.	$A1	d.	$A$1	

Lesson 20 - Creating Formulas and Charting Data
Answer Section

TRUE/FALSE

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

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

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

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

	5.	ANS:	T	PTS:	1	REF:	Mod 2-307

	6.	ANS:	F	PTS:	1	REF:	Mod 2-310

	7.	ANS:	T	PTS:	1	REF:	Mod 2-313

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

	9.	ANS:	F	PTS:	1	REF:	Mod 2-324

	10.	ANS:	T	PTS:	1	REF:	Mod 2-325

MULTIPLE CHOICE

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

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

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

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

	5.	ANS:	C	PTS:	1	REF:	Mod 2-306

	6.	ANS:	A	PTS:	1	REF:	Mod 2-307

	7.	ANS:	B	PTS:	1	REF:	Mod 2-308

	8.	ANS:	D	PTS:	1	REF:	Mod 2-310|Mod 2-311

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

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

	11.	ANS:	C	PTS:	1	REF:	Mod 2-316

	12.	ANS:	A	PTS:	1	REF:	Mod 2-316

	13.	ANS:	D	PTS:	1	REF:	Mod 2-316

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

	15.	ANS:	A	PTS:	1	REF:	Mod 2-326

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

	17.	ANS:	A	PTS:	1	REF:	Mod 2-323|Mod 2-324
TOP:	Critical Thinking	

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

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

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