Computer Concepts & Software ~ Semester 2 Exam Review
Settings
-
+
Take this quiz and check your knowledge for Microsoft Excel and Access. Many of these concepts will be covered on your final exam.
Take this Computer Concepts & Software ~ Semester 2 Exam Review or create online exam.
- 1.One way that you can create a database in Access 2007 is to make use of:
- A.
An Excel spreadsheet.
- B.
A Database template
- C.
A Simple query
- D.
A Word document
- 2.The type of "field" that every database must have is the field that ensures that each record is unique from all others. This field is called ths:
- A.
PRIMARY KEY
- B.
TITLE FIELD
- C.
FIELD SIZE
- D.
FIELD KEY
- 3.A new text field has a size of 255 characters. This is called the:
- A.
DEFAULT VALUE
- B.
SIZE-I-NESS
- C.
FIELD DEFAULT
- D.
PROPERTY SHEET
- 4.
![WHICH PART ABOVE IS AN EXAMPLE OF A DATABASE'S RECORD?]( "WHICH PART ABOVE IS AN EXAMPLE OF A DATABASE'S RECORD?")
WHICH PART ABOVE IS AN EXAMPLE OF A DATABASE'S RECORD?- A.
PART A
- B.
PART B
- C.
PART C
- D.
PART C
- 5.
![WHICH PART OF THE DATABASE, IS AN EXAMPLE OF A FIELD TITLE?]( "WHICH PART OF THE DATABASE, IS AN EXAMPLE OF A FIELD TITLE?")
WHICH PART OF THE DATABASE, IS AN EXAMPLE OF A FIELD TITLE?- A.
PART A
- B.
PART B
- C.
PART C
- D.
PART D
- 6.
![WHICH PART OF THE DATABASE IS A]( "WHICH PART OF THE DATABASE IS A")
WHICH PART OF THE DATABASE IS A "FIELD"?- A.
PART A
- B.
PART B
- C.
PART C
- D.
PART D
- 7.WHEN YOU WANT THE USER OF THE DATABASE TO CHOOSE ONE ENTRY FROM A LIST OF FOUR ITEMS (for example) YOU SHOULD MAKE USE OF WHAT "FIELD TYPE" CHOICES?
- A.
OLE OBJECT
- B.
LOOKUP WIZARD
- C.
ATTACHMENT
- D.
NUMBER
- 8.AN INPUT MASK IS A GOOD WAY TO FORMAT WHICH OF THE FOLLOWING TYPES OF NUMBERS?
- A.
ZIP CODES
- B.
TELEPHONE NUMBERS
- C.
SOCIAL SECURITY NUMBERS
- D.
ALL OF THE ABOVE
- 9.What do we call a single unit of data stored as part of a database record.
- A.
A record
- B.
A primary key
- C.
A field
- D.
A monkey
- 10.This occurs when there is exactly one record in the first table that corresponds to exactly one record in the related table.
- A.
ONE-TO-ONE RELATIONSHIPS
- B.
ONE-TO-MANY RELATIONSHIPS
- C.
ONE-TO-NONE RELATIONSHIPS
- D.
TWO-TO-TWO RELATIONSHIPS
- 11.These consist of questions presented to the database in a predefined format. What are they??
- A.
RECORDS
- B.
FIELDS
- C.
QUERIES
- D.
PRIMARY KEYS
- 12.This presents information retrieved from a table or query in a preformatted, attractive manner. What is it??
- A.
Query
- B.
Record
- C.
Field Name
- D.
Report
- 13.In Microsoft Excel, which of the following is an example of an ABSOLUTE CELL REFERENCE?
- A.
C3
- B.
AA44
- C.
$A$4
- D.
25
- 14.IN MICROSOFT EXCEL THE CELL WITH THE DARK BORDER AROUND IT IS CONSIDERED TO BE THE:
- A.
ACTIVE CELL
- B.
CHOSEN CELL
- C.
ABSOLUTE CELL REFERENCE
- D.
CELL IFFANE
- 15.WHICH IS THE CORRECT FUNCTION TO CALCULATE THE AVERAGE OF CELLS A1 THROUGH A15?
- A.
=AVG(A1:A11)
- B.
=AVG[CELLS A1 - A11]
- C.
=AVERAGE(A1:A11)
- D.
=(A1+A2+A3+A4+A5+A6+A7+A8+A9+A10+A11+A12]
- 16.In Microsoft Excel, what symbol, inserted between two cell references in a formula, defines a range of adjacent cells?
- A.
A semi-colon
- B.
A period
- C.
A comma
- D.
A colon
- 17.In Microsoft Excel, what function would determine the largest number in a list of 100 numbers?
- A.
MIN
- B.
MAX
- C.
COUNT
- D.
SUM
- 18.What is the name of the black symbol in the lower right corner of the active cell?? (This symbol is used by Clicking-and-Dragging to copy cell contents or create a series.)
- A.
The ACTIVE CELL HANDLE
- B.
THE OBJECT HANDLE
- C.
THE FILL HANDLE
- D.
THE PUMP HANDLE
- 19.IN ANY MICROSOFT PROGRAM, WHAT DO YOU CALL THE TEXT THAT IS PLACED WITHIN THE BOTTOM MARGIN OF A DOCUMENT?
- A.
THE HEADER
- B.
THE FOOTER
- C.
ENDNOTES
- D.
THE TITLE SLIDE
- 20.
![IF THE]( "IF THE")
IF THE "IF" STATEMENT SHOWN HERE, WAS "ENTERED" AND "FILLED DOWN", WHAT WOULD APPEAR IN CELL D9??- A.
101
- B.
Yes
- C.
No
- D.
275
- 21.In 100 words or less, describe how Microsoft Access might help you in your own life as an individual or a student:
Back to top