Computer Concepts & Software ~ Semester 2 Exam Review

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Guilford_buscomp
G
Guilford_buscomp
Community Contributor
Quizzes Created: 1 | Total Attempts: 476
Questions: 21 | Attempts: 477

SettingsSettingsSettings
Computer Concepts & Software ~ Semester 2 Exam Review - Quiz

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

    Correct Answer
    B. A Database template
    Explanation
    In Access 2007, one way to create a database is by using a database template. A database template provides a pre-designed structure and layout for creating a database. It includes predefined tables, forms, reports, and other objects that can be customized to suit specific needs. By utilizing a database template, users can save time and effort in designing and setting up a database from scratch, as the template already provides a foundation to build upon.

    Rate this question:

  • 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

    Correct Answer
    A. PRIMARY KEY
    Explanation
    The type of "field" that every database must have is the primary key. A primary key ensures that each record in the database is unique from all others. It serves as a unique identifier for each record and is used to establish relationships between different tables in the database.

    Rate this question:

  • 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

    Correct Answer
    A. DEFAULT VALUE
    Explanation
    The correct answer is "DEFAULT VALUE". In this context, "DEFAULT VALUE" refers to the pre-set length or size of a new text field, which is 255 characters in this case. The default value determines the maximum number of characters that can be entered into the text field.

    Rate this question:

  • 4. 

    WHICH PART ABOVE IS AN EXAMPLE OF A DATABASE'S RECORD?

    • A.

      PART A

    • B.

      PART B

    • C.

      PART C

    • D.

      PART C

    Correct Answer
    A. PART A
    Explanation
    In a database, a record refers to a collection of related data fields that are grouped together. In this question, the given options are labeled as PART A, PART B, PART C, and PART C. Since PART A is mentioned only once and the other options are repeated, it can be inferred that PART A is an example of a database's record.

    Rate this question:

  • 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

    Correct Answer
    C. PART C
    Explanation
    In a database, a field title refers to the name given to a specific category or attribute of data. It helps to identify and organize the information stored in the database. In this case, "PART C" is an example of a field title as it represents a specific category or attribute within the database.

    Rate this question:

  • 6. 

    WHICH PART OF THE DATABASE IS A "FIELD"?

    • A.

      PART A

    • B.

      PART B

    • C.

      PART C

    • D.

      PART D

    Correct Answer
    D. PART D
    Explanation
    A "field" in a database refers to a specific category of information within a record. It is used to organize and store data in a structured manner. In this case, "PART D" is identified as the correct answer because it represents the part of the database that contains the fields.

    Rate this question:

  • 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

    Correct Answer
    B. LOOKUP WIZARD
    Explanation
    The Lookup Wizard field type should be used when you want the user of the database to choose one entry from a list of four items. The Lookup Wizard allows you to create a dropdown list or a combo box that displays the available options for the user to choose from. This ensures that the user can only select one item from the list, providing a more controlled and accurate input for the database.

    Rate this question:

  • 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

    Correct Answer
    D. ALL OF THE ABOVE
    Explanation
    An input mask is a good way to format all of the above types of numbers (zip codes, telephone numbers, and social security numbers). An input mask is a predetermined pattern that is applied to an input field, allowing the user to enter data in a specific format. In the case of zip codes, telephone numbers, and social security numbers, input masks can be used to ensure that the numbers are entered correctly and consistently, following the required format for each type of number.

    Rate this question:

  • 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

    Correct Answer
    C. A field
    Explanation
    A field is a single unit of data stored as part of a database record. It represents a specific attribute or characteristic of the record and holds the actual data values. Fields are used to organize and categorize data within a database, allowing for efficient storage, retrieval, and manipulation of information.

    Rate this question:

  • 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

    Correct Answer
    A. ONE-TO-ONE RELATIONSHIPS
    Explanation
    This answer is correct because a one-to-one relationship occurs when there is exactly one record in the first table that corresponds to exactly one record in the related table. In this type of relationship, each record in one table is associated with only one record in the other table, and vice versa. It is a unique and direct relationship between the two tables, ensuring that each record has a single, specific match in the other table.

    Rate this question:

  • 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

    Correct Answer
    C. QUERIES
    Explanation
    Queries are a predefined format used to present questions to a database. They allow users to retrieve specific information from the database by specifying certain criteria or conditions. Queries help in extracting relevant data from the database and are an essential tool in data analysis and reporting.

    Rate this question:

  • 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

    Correct Answer
    D. Report
    Explanation
    A report is a document that presents information retrieved from a table or query in a preformatted, attractive manner. It is commonly used to summarize and organize data in a clear and concise format, making it easier for the reader to understand and analyze the information. Reports often include headers, footers, titles, and other formatting elements to enhance the presentation of the data.

    Rate this question:

  • 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

    Correct Answer
    C. $A$4
    Explanation
    An absolute cell reference in Microsoft Excel is denoted by a dollar sign before both the column letter and row number. In this case, $A$4 is the only option that follows this format, making it the correct answer.

    Rate this question:

  • 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

    Correct Answer
    A. ACTIVE CELL
    Explanation
    The cell with the dark border around it in Microsoft Excel is considered to be the active cell. The active cell is the cell that is currently selected and ready for data entry or manipulation. It is the cell that is affected by any actions or commands performed in Excel, such as entering data, applying formulas, or formatting.

    Rate this question:

  • 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]

    Correct Answer
    C. =AVERAGE(A1:A11)
    Explanation
    The correct function to calculate the average of cells A1 through A15 is =AVERAGE(A1:A11). This function takes the range of cells A1 to A11 and calculates the average of the values in those cells.

    Rate this question:

  • 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

    Correct Answer
    D. A colon
    Explanation
    A colon is used to define a range of adjacent cells in a formula in Microsoft Excel. For example, if we want to sum the values in cells A1 to A5, we would use the formula "=SUM(A1:A5)". The colon between A1 and A5 indicates that we want to include all the cells between A1 and A5 in the range.

    Rate this question:

  • 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

    Correct Answer
    B. MAX
    Explanation
    The MAX function in Microsoft Excel is used to determine the largest number in a list of numbers. It calculates and returns the maximum value from the given range of cells or numbers. In this case, since we want to find the largest number among 100 numbers, the MAX function is the appropriate choice.

    Rate this question:

  • 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

    Correct Answer
    C. THE FILL HANDLE
    Explanation
    The black symbol in the lower right corner of the active cell is called the fill handle. It is used by clicking and dragging to copy cell contents or create a series.

    Rate this question:

  • 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

    Correct Answer
    B. THE FOOTER
    Explanation
    In any Microsoft program, the text that is placed within the bottom margin of a document is called the footer. The footer is typically used to display information such as page numbers, author name, date, or other relevant details that need to appear consistently at the bottom of each page in the document. It helps in providing additional context or reference to the content of the document.

    Rate this question:

  • 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

    Correct Answer
    B. Yes
    Explanation
    If the "IF" statement shown here was entered and filled down, the value "yes" would appear in cell D9.

    Rate this question:

  • 21. 

    In 100 words or less, describe how Microsoft Access might help you in your own life as an individual or a student:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 20, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 26, 2009
    Quiz Created by
    Guilford_buscomp
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.