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
Correct Answer
B. A Database templateExplanation
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 KEYExplanation
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 VALUEExplanation
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 AExplanation
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 CExplanation
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 DExplanation
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 WIZARDExplanation
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 ABOVEExplanation
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 fieldExplanation
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 RELATIONSHIPSExplanation
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. QUERIESExplanation
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. ReportExplanation
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$4Explanation
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 CELLExplanation
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 colonExplanation
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. MAXExplanation
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 HANDLEExplanation
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 FOOTERExplanation
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. YesExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
May 26, 2009Quiz Created by
Guilford_buscomp
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
Back to top