CPS 104 Charts Practice Test

"); document.writeln("Name: " + studentName + "
"); document.write("Score: " + numCorrect + " / " + numPossible + " (" + scorePercent + "%)"); if (numSubjective > 0) { document.write(" [" + numSubjective + " subjective "); if (numSubjective == 1) document.write("question"); else document.write("questions"); document.write(" not graded]"); } document.writeln("

"); document.writeln("

" + titleString + "

"); document.writeln(""); currentInstruction = 0; currentNarrative = 0; for (i=0; i < numQuestions; ++i) { if (currentInstruction < numInstructions) { if (instructionIndex[currentInstruction] == i) { document.writeln(""); ++currentInstruction; } } if (currentNarrative < numNarratives) { if (narrativeIndex[currentNarrative] == i) { document.writeln(""); ++currentNarrative; } } document.writeln(""); document.writeln(""); document.writeln(""); document.writeln(""); } document.writeln("

"); document.writeln(instructionText[currentInstruction]); document.writeln("

"); document.writeln("

"); document.writeln(narrativeText[currentNarrative]); document.writeln("

"); document.writeln("

" + prefixText[i] + "

" + numberText[i] + "

" + questionText[i]); document.writeln("

"); document.writeln(""); if (listMap.charAt(i) != "1") { document.writeln(""); document.writeln(""); } document.writeln(""); document.writeln(""); if (showNotes) { document.writeln(""); document.writeln(""); } if (showRef) { document.writeln(""); document.writeln(""); } document.writeln("

RESPONSE:	" + responseText[i] + "
ANSWER:	" + answerText[i] + "
NOTES:	" + notesText[i] + "
REF:	" + refText[i] + "

"); document.writeln("

"); document.writeln("
"); document.writeln(""); document.writeln(""); document.write(""); document.writeln("


"); document.writeln("	"); document.write(""); document.writeln(""); document.writeln("

"); document.writeln(""); document.writeln("

Hosted by www.Geocities.ws

"); document.close(); return(false); } function GetResponse(answerIndex, answer) { var listIndex; var responseText; if (listMap.charAt(answerIndex) == "1") { listIndex = answer.selectedIndex; responseText = answer.options[listIndex].text; } else responseText = answer.value; return(responseText); } function ScoreAnswer(answerIndex, responseText) { var listIndex; var answerText; answerText = ansMap[answerIndex]; if (qtypeMap.charAt(answerIndex) == "4") return(NumericCompare(responseText, answerText)); else if (qtypeMap.charAt(answerIndex) == "5") return(MultiCompare(responseText, answerText)); else if (responseText.toUpperCase() == answerText.toUpperCase()) return(true); else return(false); } function BuildPrefixText(answerIndex, responseText, isCorrect) { var text; var listIndex; text = "

"
		if (isCorrect)
			text += ""
		else
			text += ""

		if (listMap.charAt(answerIndex) == "1") {
			if (responseText.length == 0)
				responseText = " ";
			text += " " + responseText + " ";
		}

		text += "

" return(text); } function StripSpaces(s) { var len; var i; len = s.length; for (i=len - 1; i >= 0 && s.charAt(i) == " "; --i) len = i; if (len == 0) s = ""; else if (len != s.length) s = s.substring(0, len); return(s); } function TranslateHtmlString(text) { var newText; var replaceString; var position; var length; var breakPos; var skipExtra; var i; newText = ""; position = 0; length = text.length; while (position < length) { skipExtra = 0; breakPos = -1; for (i=position; i < length && breakPos < 0; ++i) { switch(text.charAt(i)) { case '>': replaceString = ">"; breakPos = i; break; case '<': replaceString = "<"; breakPos = i; break; case '&': replaceString = "&"; breakPos = i; break; case '\r': if ((i + 1) < length && text.charAt(i + 1) == '\n') skipExtra = 1; replaceString = "
"; breakPos = i; break; case '\n': replaceString = "
"; breakPos = i; break; case ' ': if ((i + 1 < length) && text.charAt(i + 1) == ' ') { replaceString = " "; breakPos = i; } break; } } if (breakPos < 0) { newText += text.substring(position, length); position = length; } else { if (breakPos > position) newText += text.substring(position, breakPos); newText += replaceString; position = breakPos + 1 + skipExtra; } } return(newText); } function FixMCNotes(notesText, studentText) { var displayText; var searchText; var upperNotes; var charCode; var startIndex; var endIndex; displayText = ""; if (notesText.length > 0) { if (studentText.length > 0) { upperNotes = notesText.toUpperCase(); studentText = studentText.toUpperCase(); charCode = studentText.charCodeAt(0); searchText = "/" + String.fromCharCode(charCode) + "/"; startIndex = upperNotes.indexOf(searchText); if (startIndex >= 0) { startIndex += searchText.length; searchText = "/" + String.fromCharCode(charCode + 1) + "/"; endIndex = upperNotes.indexOf(searchText, startIndex); if (endIndex < startIndex) endIndex = notesText.length; displayText = notesText.substring(startIndex, endIndex); } } if (displayText.length == 0 && notesText.charAt(0) != "http://www.geocities.com/") displayText = notesText; } return(displayText); } function NumericCompare(s1, s2) { var s1Sign; var s2Sign; var tempString; var decimalCount; var decimalPos; var numToDelete; var len; var ch; var i; s1.toUpperCase(); s2.toUpperCase(); if (s1 == s2) return(true); else { s1Sign = 1; s2Sign = 1; tempString = ""; for (i=0; i < s1.length; ++i) { ch = s1.charAt(i); if (ch == "-" && tempString.length == 0) s1Sign = -1; else if ((ch >= "0" && ch <= "9") || ch == ".") tempString += ch; } s1 = tempString; decimalCount = 0; decimalPos = -1; for (i=0; i < s1.length; ++i) { if (s1.charAt(i) == '.') { ++decimalCount; if (decimalPos < 0) decimalPos = i; } } if (decimalCount == 1 && decimalPos >= 0) { len = s1.length; for (i=len - 1; i >= decimalPos; --i) { if (i == decimalPos || s1.charAt(i) == '0') len = i; else break; } if (len < s1.length) s1 = s1.substring(0, len); if (s1.length == 0) s1 = "0"; } numToDelete = 0; for (i=0; i < s1.length; ++i) { if (s1.charAt(i) == "0") ++numToDelete; else break; } if (numToDelete > 0) { if (numToDelete == s1.length) --numToDelete; if (numToDelete > 0) s1 = s1.substring(numToDelete); } ///////////////////////////////////////////// tempString = ""; for (i=0; i < s2.length; ++i) { ch = s2.charAt(i); if (ch == "-" && tempString.length == 0) s2Sign = -1; else if ((ch >= "0" && ch <= "9") || ch == ".") tempString += ch; } s2 = tempString; decimalCount = 0; decimalPos = -1; for (i=0; i < s2.length; ++i) { if (s2.charAt(i) == '.') { ++decimalCount; if (decimalPos < 0) decimalPos = i; } } if (decimalCount == 1 && decimalPos >= 0) { len = s2.length; for (i=len - 1; i >= decimalPos; --i) { if (i == decimalPos || s2.charAt(i) == '0') len = i; else break; } if (len < s2.length) s2 = s2.substring(0, len); if (s2.length == 0) s2 = "0"; } numToDelete = 0; for (i=0; i < s2.length; ++i) { if (s2.charAt(i) == "0") ++numToDelete; else break; } if (numToDelete > 0) { if (numToDelete == s2.length) --numToDelete; if (numToDelete > 0) s2 = s2.substring(numToDelete); } if (s1Sign == s2Sign && s1 == s2) return(true); } return(false); } function MultiCompare(responseText, answerText) { var startIndex; var endIndex; var partialText; responseText = responseText.toUpperCase(); answerText = answerText.toUpperCase(); startIndex = 0; do { endIndex = answerText.indexOf("\r", startIndex); if (endIndex < 0) partialText = answerText.substring(startIndex); else partialText = answerText.substring(startIndex, endIndex); if (responseText == partialText) return(true); startIndex = endIndex + 1; } while (endIndex > 0); return(false); } function FixMTF(f) { var text; var letter; var theList; var listIndex; var number; var i; for (i=0; i < f.length; ++i) { if (f.elements[i].name.indexOf("MTF:") == 0) { number = parseInt(f.elements[i].name.substring(4), 10); theList = f["MTF-" + number + "-1"]; if (theList) { listIndex = theList.selectedIndex; letter = theList.options[listIndex].text; } else letter = ""; text = StripSpaces(f["MTF-" + number + "-2"].value); if (text == "") f.elements[i].value = letter; else f.elements[i].value = letter + "," + text; } } } function AllowReset() { return(window.confirm("Do you want to clear all of your answers?")); } // -->

Name:

CPS 104 Charts Practice Test

Multiple Choice

Identify the letter of the choice that best completes the statement or answers the question.

Possible uses for a chart include ____.

a.	Presenting the number of kite kits sold in a month in a format that is easy to understand.
b.	Presenting comments from kite kit buyers.
c.	Showing the dimensions of a kite kit.
d.	Printing an invoice form for a kite kit.

Before you create a chart, it is important that you complete all planning steps but the following:

a.	Thinking about what you want the chart to show.
b.	Deciding the color of the chart and background.
c.	Designing the worksheet so Excel creates the chart you want.
d.	Deciding what chart type is most appropriate.

In a chart, ____ are the horizontal and vertical lines connecting to the X-axis and Y-axis.

a.	Labels.	b.	Gridlines.	c.	Legends.	d.	Axes.

A(n) ____ explains what labels, colors, and patterns in the chart represent.

a.	Axis.	b.	Data point.	c.	Data marker.	d.	Legend.

The X-axis and Y-axis correspond respectively, to the ____.

a.	Horizontal and vertical lines in a chart.	c.	Tick markers in a row.
b.	Data series in a chart.	d.	Gridlines and chart background in a chart.

The box that explains what the labels, colors, and patterns of the chart represent is called the ____.

a.	Key box.	b.	Legend.	c.	Data marker.	d.	X-axis.

In the above figure, which chart type would you select to create a chart that shows changes in data or data frequency relative to a center point?

a.	Radar chart.	c.	Bar chart.
b.	Area chart.	d.	Combination chart.

In the above figure, which chart type would you choose to create a chart that compares the relationship of the parts to the whole?

a.	Area chart.	b.	Pie chart.	c.	Radar chart.	d.	XY (scatter).

Which chart type would you use to compare categories of data with each other?

a.	Area.	b.	Bar.	c.	Combination.	d.	Line.

10.

Which chart type is best for showing the relationship of all parts to the whole?

a.	Bar.	b.	Pie.	c.	Line.	d.	Area.

11.

Which chart type is best for showing trends by category over a period of time?

a.	Bar.	b.	Area.	c.	Line.	d.	XY (scatter).

12.

Charts are saved ____.

a.	In a separate Excel file.
b.	As part of the Excel file that contains the worksheet data.
c.	As a separate sheet in the Excel file that contains the worksheet data.
d.	None of the above.

13.

In the above figure, item 5 is a(n) ____.

a.	X-axis label.	b.	Y-axis label.	c.	Selection handle.	d.	Smart Tag.

14.

In the above figure, item 3 is the chart ____.

a.	Legend.	c.	Worksheet title.
b.	Title.	d.	None of the above.

15.

To delete a chart, select it and then press ____.

a.	[Tab].	b.	[Enter].	c.	[Delete].	d.	[Esc].

Completion

Complete each sentence or statement.

16.

A(n) ____________________ explains what labels, colors, and patterns in a chart represent.

17.

A scatter chart shows the relationship between ____________________ kinds of related data.

18.

A(n) ____________________ chart shows the relationship of parts to a whole.

19.

A(n) ____________________ chart compares categories of data with each other.

20.

In order to create a chart, you must first select worksheet cells that contain the ____________________ you want to chart.

21.

In the above figure, item 3 points to a(n) ____________________.

22.

A(n) ____________________ is information that prints at the top of a chart or worksheet.

23.

If you select the chart in a worksheet that contains a chart, only the ____________________ will print when you click the Print button on the Standard toolbar.

Hosted by www.Geocities.ws