Computer Concepts & Software ~ Semester 2 Exam Review

21 Questions

Settings
Please wait...
Computer Concepts & Software ~ Semester 2 Exam Review

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.


Questions and Answers
  • 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?
    • 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?
    • A. 

      PART A

    • B. 

      PART B

    • C. 

      PART C

    • D. 

      PART D

  • 6. 
    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" 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: