CPS 104 Spreadsheets and 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 Spreadsheets and Charts Practice Test

Multiple Choice

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

Spreadsheets would not be used to accomplish which one of the following activities?

a.	Create charts.	c.	Perform data analysis.
b.	Quickly recalculate results.	d.	Word processing.

Which of the following is true about spreadsheets?

a.	It automatically calculates results.	c.	Both A and B.
b.	It can display your data as a chart.	d.	None of the above.

An spreadsheet worksheet is divided into ____.

a.	Rows and columns.	c.	Charts.
b.	Tables.	d.	Clip art image placeholders.

The spreadsheet worksheet window is divided into rows and columns that intersect to form ____.

a.	Cells.	b.	Formulas.	c.	Workbooks.	d.	Worksheets.

The cell address is identified by ____.

a.	Its sheet tab.
b.	Its location on the status bar.
c.	The coordinates of the intersecting column and row.
d.	Its location on the cell pointer.

Which of the following is not an example of an spreadsheet cell address?

a.	A45.	b.	C6.	c.	23B.	d.	F15.

To move to a particular cell in the worksheet, ____.

a.	Click the desired cell.	c.	Type the cell address.
b.	Press [Esc].	d.	None of the above.

Which of the following methods can be used to navigate a worksheet?

a.	Click the desired cell address.	c.	Press the arrow keys.
b.	Press [Tab].	d.	All of the above.

In the above figure, cell E-10 displays ____.

a.	A formula.	c.	The results of a formula.
b.	A value.	d.	A label.

10.

In a worksheet, each row's height is automatically adjusted to be at least as large as ____.

a.	The largest font in the row.	c.	16 pixels.
b.	24 pixels.	d.	The worksheet.

11.

To perform a calculation the worksheet, you can enter a ____ in a cell.

a.	Formula.	b.	Sum.	c.	Result.	d.	Question.

12.

A spreadsheet recognizes the entry =B4/B2*C4 as a ____.

a.	Label.	b.	Value.	c.	Formula.	d.	Function.

13.

The correct formula to multiply cell D5 by cell B2 is ____.

a.	B2*D5	b.	=D5*B2	c.	D5*B2	d.	(D5*B2)

14.

All Excel spreadsheet formulas begin with ____.

a.	*	b.	+	c.	/	d.	=

15.

In the calculation =1200/23-600+75*45, which mathematical operation is performed first?

a.	Subtraction.	b.	Multiplication.	c.	Division.	d.	Addition.

16.

In the calculation =8+.98/3500*(9+16), which operation is performed first?

a.	Division.	c.	The calculation in parentheses.
b.	Multiplication.	d.	Subtraction.

Completion

Complete each sentence or statement.

17.

The ____________________ bar shows the contents of a cell in the worksheet, and allows you to edit it.

18.

When entering a formula, you can use a cell ____________________ rather retyping the value that you see in another cell, and Excel will use it automatically when the formula is calculated.

19.

Type the character ____________________ to indicate multiplication in a formula.

20.

To deselect selected cells, click anywhere in the ____________________ window.

21.

A block of cells is referred to as a ____________________.

22.

When entering a formula, if you want a cell reference to always refer to a specific cell, no matter where you copy the formula, you should use an ____________________ cell reference.

Hosted by www.Geocities.ws