Name:     ID: 
 
    Email: 

Computer Literacy: Section III: Test #3

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

 1. 
Another name for the active cell is the cell reference.
 

 2. 
A manual spreadsheet is capable of automatically recalculating totals when changes are made to figures in the spreadsheet.
 

 3. 
The shape of the se-apart portion of an exploded pie chart is a wedge.
 

 4. 
In a spreadsheet, column widths and row heights can be altered.
 

 5. 
The greatest labor-saving aspect of an electronic spreadsheet is its ability to recalculate dependent values when the value it depends on is changed.
 

 6. 
Printers produce hard copy.
 

 7. 
Data is scanned into the computer using a mouse.
 

 8. 
Voice recognition software is very good at understanding the meaning of spoken words.
 

 9. 
A laser printer uses nonimpact technology to produce characters.
 

 10. 
A digital camera uses an embedded chip to focus the picture but records the picture on regular film.
 

 11. 
The usual reason for choosing a programming language is simply that it is the one the programmer likes the best.
 

 12. 
Wintel is an example of a platform.
 

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

 13. 
The active cell is the
a.
current cell
c.
formula
b.
range
d.
cell address
 

 14. 
A preprogrammed formula is called a
a.
function
c.
range
b.
graph
d.
cell
 

 15. 
The intersection of a row and column creates a(n)
a.
active address
c.
cursor
b.
formula
d.
cell
 

 16. 
Text information in a cell is called a
a.
label
c.
formula
b.
value
d.
cell address
 

 17. 
Art that is supplied with a graphics program is called
a.
a cell
c.
clip art
b.
analytical
d.
a range
 

 18. 
SUM is an example of a
a.
displayed value
c.
label
b.
range
d.
function
 

 19. 
F2:G6 is an example of a
a.
function
c.
value
b.
range
d.
cell address
 

 20. 
Which of tese is a correct cell address?
a.
DD
c.
2C
b.
B6
d.
FO
 

 21. 
A set of adjacent cells that form a rectangle is called a
a.
data point
c.
range
b.
function
d.
cell reference
 

 22. 
The distance betweent he pixels on a screen is called
a.
OCR
c.
dot pitch
b.
LCD
d.
refresh rate
 

 23. 
Using computers to design and manufacture products is called
a.
inscribing
c.
detailing
b.
CAD / CAM
d.
imaging
 

 24. 
Some POS terminals are similar to
a.
calculators
c.
UPCs
b.
Touch-Tone telephones
d.
cash registers
 

 25. 
Which of the following monitors shows single-color characters on a contrasting background?
a.
monochrome
c.
addressable
b.
blank
d.
liquid crystal display
 

 26. 
Voice input devices convert voice input to
a.
digital codes
c.
OCR-A
b.
bar codes
d.
optical marks
 

 27. 
Which of the following displays has a screen that is lighter and slimmer than a CRT?
a.
OCR
c.
flat-panel
b.
graphics card
d.
terminal
 

 28. 
Computer animation is a form of
a.
LCD
c.
video graphics
b.
CAD / CAM
d.
color printer output
 

 29. 
In preparing a program, one should first
a.
plan the solution
c.
code the program
b.
document the program
d.
defne the problem
 

 30. 
During the development of a program, drawing a flowchart is a means to
a.
plan the solution
c.
code the program
b.
define the problem
d.
analyze the problem
 

 31. 
An English-like language that one can use as a program design tool is
a.
BASIC
c.
pseudocode
b.
COBOL
d.
Pascal
 

 32. 
In preparing a program, debugging and translating are examples of
a.
coding
c.
planning
b.
testing
d.
documentation
 

 33. 
The first high-level language to be introduced was
a.
COBOL
c.
FORTRAN
b.
Pascal
d.
BASIC
 

 34. 
The highest-level languages are called
a.
4GL
c.
high-level languages
b.
assembly languages
d.
natural languages
 

 35. 
Popular object-oriented languages
a.
C, COBOL
c.
C++, Java
b.
C++, FORTRAN
d.
COBOL, BASIC
 

 36. 
The lowest level of programming language is
a.
natural language
c.
assembly language
b.
BASIC
d.
machine language
 

Completion
Complete each sentence or statement.
 

 37. 
An actural number that is entered into a cell is a(n) ____________________.
 

 

 38. 
Another name for an electronic spreadsheet is ____________________.
 

 

 39. 
How many values can a pie chart represent for each slice? ____________________.
 

 

 40. 
LCD stands for _____________________.
 

 

 41. 
The UPC is a(n) ____________________ used to identify grocery items.
 

 

 42. 
A screen that accepts input from a pointing finger is called a(n) ____________________.
 

 

 43. 
The type of language that is used to access databases is called a(n) ____________________ language.
 

 

 44. 
The rules of a programming language are called its ____________________.
 

 

 45. 
How many levels of programming languages are there?
 

 

Matching
 
 
Matching
a.
=INT(AVERAGE(I4:H4))
e.
=SUM(list)
b.
=AVERAGE(list)
f.
=NPV(rate,list)
c.
=NA
g.
=INT(value)
d.
=ROUND(value, decimal place)
 

 46. 
An integer which has been truncated.
 

 47. 
Rounds a value to a specific decimal place.
 

 48. 
The average value for a list of cells.
 

 49. 
Total calculate value of a list of cells.
 

 50. 
Truncates the average value of a specified list of cells.
 

 51. 
Ignor the contents of this cell and remove it from the equation.
 

 52. 
Calculates the payoff of a simple loan.
 

Short Answer
 

 53. 
Define Spread Sheet.
 

 54. 
All data that gets entered into a spread sheet can be one of two formats.  What are they and what are their differences.
 

 55. 
Printing a spread sheet is not always as simple as choosing the print command.  What consideration(s) must be taken before printing a spread sheet?
 

 56. 
How can you tell if data is a text or numeric format, just by looking at the spread sheet?
 

 57. 
In addition to Fonts, Sizes, Styles and Alignment, what other types of formatting can be done on spread sheet data?
 

 58. 
What are the six arithmetic symbols used fo rcreating mathematical expressions?
 

 59. 
In a spread sheet, what is the intersection of a row and column called?
 

 60. 
What is another way to write the formula:  =((A1+B1+C1+D1+E1+F1)/6)
 

 61. 
Describe how to ask a spread sheet a “what if” question.
 

 62. 
What are the six logical operators?
 

 63. 
What does the following equation do:  =ROUND(=NPV(.033,A4:H4),2)
 



 
Submit          Reset Help