Computer Concepts & Software ~ Semester 2 Exam Review

21 Questions | By Guilford_buscomp | Updated: Mar 20, 2022 | Attempts: 462

Questions

Settings

Feedback

During the Quiz End of Quiz

Play as

Quiz Flashcard

Create your own Quiz

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
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: