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.
- 1.In 100 words or less, describe how Microsoft Access might help you in your own life as an individual or a student:
- 2.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
- 3.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
- 4.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
- 5.
WHICH PART ABOVE IS AN EXAMPLE OF A DATABASE'S RECORD?- A.
PART A
- B.
PART B
- C.
PART C
- D.
PART C
- 6.
WHICH PART OF THE DATABASE, IS AN EXAMPLE OF A FIELD TITLE?
- A.
PART A
- B.
PART B
- C.
PART C
- D.
PART D
- 7.
WHICH PART OF THE DATABASE IS A "FIELD"?
- A.
PART A
- B.
PART B
- C.
PART C
- D.
PART D
- 8.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
- 9.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
- 10.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
- 11.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
- 12.These consist of questions presented to the database in a predefined format. What are they??
- A.
RECORDS
- B.
FIELDS
- C.
QUERIES
- D.
PRIMARY KEYS
- 13.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
- 14.In Microsoft Excel, which of the following is an example of an ABSOLUTE CELL REFERENCE?
- A.
C3
- B.
AA44
- C.
$A$4
- D.
25
- 15.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
- 16.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]
- 17.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
- 18.In Microsoft Excel, what function would determine the largest number in a list of 100 numbers?
- A.
MIN
- B.
MAX
- C.
COUNT
- D.
SUM
- 19.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
- 20.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
- 21.
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
Questions: 10 | Attempts: 13791 | Last updated: Mar 22, 2022
-
Sample QuestionMicrosoft Word is an example of utility software.
Questions: 10 | Attempts: 202111 | Last updated: Apr 18, 2022
-
Sample QuestionWhen you see no icons on the desktop, how can you open programs such as Microsoft Word?
Questions: 25 | Attempts: 142883 | Last updated: Apr 24, 2022
-
Sample QuestionHow to open a program such as Microsoft Word without any icons on the desktop?
- 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