CCE 170 - Exam #1 KEY

Fall Semester 2021

Multiple Choice

Note: Using the Excel Help Utility is NOT allowed on this page of the exam.

(1 pt each)

2. (excel) Which of the following Excel tools would you use to ensure that the user only enters positive numbers in a particular cell?

	a.	Goal Seek
	b.	Value Restriction
	c.	Conditional Formatting
	d.	Data Validation
	e.	IF statement
	f.	None of the above

3. (excel) Suppose I want to enter a logical expression for the condition used in an IF statement in an Excel spreadsheet and I am referencing two cells named X and Y. Which of the following represents the logical expression X is greater than or equal to Y?

	a.	X <> Y
	b.	X > Y or X = Y
	c.	Not X < Y
	d.	X >= Y
	e.	X ~ Y
	f.	None of the above

4. (excel) Which of the following is an Excel Add-In?

	a.	The Solver tool
	b.	The Goal Seek tool
	c.	The VLOOKUP function
	d.	The Drawing Toolbar
	e.	The Equation Editor

5. (compsci) How many bits are used for each hexidecimal digit?

	a.	3
	b.	4
	c.	8
	d.	None of the above

6. (excel) Assuming I have a table containing strain vs. time from a laboratory tension test, which of the following plot types would be the most appropriate way to graph the table?

	a.	Bar
	b.	Surface
	c.	Pie
	d.	XY (Scatter)

7. (compsci) How many unique values can be stored in a one byte variable?

	a.	256
	b.	128
	c.	64
	d.	32

8. (compsci) How many bits are in 30 GB of memory?

	a.	2.57698E+11
	b.	251658240
	c.	245760
	d.	32212254720
	e.	2.4E+11

9. (excel) If I am entering a formula in cell G21, which of the following cell references can be interpreted as "the cell in the same column as the current cell, but always on row 24"?

	a.	G24
	b.	G$24
	c.	$G24
	d.	$G$24