Which of the following can be customized for quicker access to your most commonly used commands?

When you modify the ribbon, which of the following is created?

Which predesigned field already has a significant amount of formatting, text, and other features?

Which of the following commands is used to insert a cell into a worksheet?

You want to format a cell so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which of the following alignment options should be used?

Which of the following can you not copy using Format Painter?

You don’t like the cell style you just applied. Which of the following is the least effective way to remove or replace the style?

Which of the following is not useful for changing the font size?

When you delete cells in a worksheet, you remove one or more cells, forcing other cells to move down or to the right.

When you point to defined styles in the Cell Styles gallery, you can see the formatting that will be used when you apply each style.

Style attributes include fonts and font sizes, number formats, and borders and shading.

To access an Excel template, you can click the File tab and then click New.

You cannot split a single worksheet cell that has not been merged.

After you select a color and apply it to a cell’s background, the Fill Color button takes on that color.

The order of of operations determines which parts of a formula are calculated before other parts of the formula.

The Formula = 6 2 / 3 produces the same result as = 6 (2 / 3).

The AVERAGE Function returns the mean value in a range of selected cells.

The COUNT Function returns the total number of cells in the selected range that contain both text and numbers.

The MAX function returns the total of all cells in the selected range.

If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width.

The MIN function returns the smallest value in a range of cells.

You can access Backstage view by pressing Ctrl+B.

You must use the AutoSum button to enter a SUM function—you cannot type it manually in a cell.

In Excel, you can add your most commonly used commands to the Quick Access Toolbar.

You can create a completely new ribbon tab as well as groups on that ribbon.

To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=).

Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification.

You can create a new range by selecting the cells and typing a name in the Name Box next to the formula bar.

It consolidates records previously stored in separate files into a common pool and serves a variety of users and data processing applications.

Which of the following is not an arithmetic operator?

Per the order of operations, which of the following is calculated first?

Which of the following calculates the total from the adjacent cell through the first non-numeric cell by default, using the SUM function in its formula?

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used?

You want to calculate the number of nonblank cells in your worksheet. Which function should be used?

Which of the following is an acceptable name for a named range?

The COUNT and MIN functions are examples of which category of functions?

Which of the following statements accurately describes the default selection for AutoSum?

Which of the following is an example of an absolute cell reference?

Which of the following is an example of a mixed cell reference?

The program that manages and controls the data and the interfaces between the data and the application programs that use the data stored in the database.

The database, the DBMS, and the application programs that access the database through the DBMS.

The person responsible for coordinating, controlling, and managing the database.

The physical location of the data. It can be a hard drive, optical disk, or flash drive.

Very large databases containing detailed and summarized data for a number of years that are used for analysis rather than transaction processing.

It provides a controlled environment to assist and prevent the user from accessing and updating the data in the Database.

It translates user-logical views into instructions on which data should be retrieved from the database.

It translates DBMS requests into instructions to physically retrieve data from various storage devices.

It allows users to access, query, or update the Database

It is the data of the data.

The types of data management problems caused by data redundancy are the following except

User's inability to obtain additional information as his or her needs change.

User's information set is constrained by the data that he or she possesses and controls.

Analyzing large amounts of data for strategic decision-making.

Using queries to investigate hypothesized relationships among data.

Using sophisticated statistical analysis to “discover” unhypothesized relationships in the data.

Document that shows the items stored in a file, including the order and length of the data fields and the type of data stored.

How people conceptually organize, view, and understand the relationships among data items.

The way data are physically arranged and stored in the computer system.

A description of the data elements in a database, the relationships among them, and the logical model used to organize and describe the data.

The organization-wide view of the entire database that lists all data elements and the relationships between them.

An individual user’s view of portions of a database; also called a subschema.

A subset of the schema; the way the user defines the data and the data relationships.

A low-level view of the entire database describing how the data are actually stored and accessed.

Details about data storage, such as record layouts, definitions, addresses, indexes.

Information about the structure of the database, including a description of each data element.

DBMS language that builds the data dictionary, creates the database, describes logical views, and specifies record or field security constraints.

DBMS language that changes database content, including data element creations, updates, insertions, and deletions.

High-level, English-like, DBMS language that contains powerful, easy-to-use commands that enable users to retrieve, sort, order, and display data.

DBMS language that simplifies report creation.

An abstract representation of database contents.

A two-dimensional table representation of data; each row represents a unique entity (record) and each column is a field where record attributes are stored.

A row in a table that contains data about a specific item in a database table.

Database attribute, or combination of attributes, that uniquely identifies each row in a table.

An attribute in a table that is also a primary key in another table; used to link the two tables.

A database built using the relational data model.

A non-null primary key ensures that every row in a table represents something and that it can be identified.

Foreign keys that link rows in one table to rows in another table must have values that correspond to the value of a primary key in another table.

Following relational database creation rules to design a relational database that is free from delete, insert, and update anomalies.

Using knowledge of business processes and information needs to create a diagram that shows what to include in a fully normalized database (in 3NF).

The constraint that all primary keys must have nonnull data values is referred to as which of the following?

The constraint that all foreign keys must have either null values or the value of a primary key in another table is referred to as which of the following?

The following are examples of Database Management System except?

Which of the following attributes in the Cash Receipts table (representing payments received from customers) would most likely be a foreign key?

Which of the following is where you can save, select a template, change document properties, and close or exit Excel?

To change printer, layout, or margin settings, you click the File tab and use which of the following options?

The relational data model portrays data as being stored in __________.

How a user conceptually organizes and understands data is referred to as the __________.

What is each row in a relational database table called?

Which of the following is an individual user’s view of the database?

Which of the following would managers most likely use to retrieve information about sales during the month of October?

Which of the following is a software program that runs a database system?

Which of the following attributes would most likely be a primary key?

The following are the basic requirements of a relational database except?

Improper database organization where a non-primary key item is stored multiple times; updating the item in one location and not the others causes data inconsistencies.

Improper database organization that results in the inability to add records to a database.

Improper organization of a database that results in the loss of all information about an entity when a row is deleted.

Which of the following are the advantage of database systems?