___________________ is a program known as a database management system (DBMS)
faster, flexible, accurate
Some of the benefits of a computerized DBMS are (3):
store; retrieve; analyze; print
A DBMS allows you to: a) _____________ information b) _____________ information c) _____________ information d) _____________ information
A database is a collection of _______
A __________ is a complete set of data
Each record is made up of one or more ________
To delete a record from a table, select the record and then press the Delete key. After you've deleted a record, you cannot use the Undo button or press the Esc key to restore it. Deleting a record is ____________
A _________ is a question you ask the database.
A _________ is commonly used to summarize data and to calculate totals.
_______________ a database rearranges how the database is stored on the disk and optimizes the performance of the database.
The purpose of the spreadsheet is to solve problems that involve _____________
A ___________________ is a grid of rows and columns in which you enter text, numbers, and the results of calculations.
In Excel, a computerized spreadsheet is called a ____________.
____________ of the worksheet appear vertically, and are identified by letters at the top of the worksheet window.
________ appear horizontally and are identified by numbers on the left side of the worksheet window.
A ____ is the intersection of a row and column.
A _____________ is an equation that calculates a new value from values currently in a worksheet, such as adding the numbers in cell A1 and A2.
The file used to store worksheets is called a _________
a) calculating a budget b) calculating grades c) payments for a loan
Spreadsheets have many uses. A few examples are (3):
name box; active cell; column letter; row number
Excel has some of the same basic parts as the other Office programs, but also has some additional buttons and parts. Name 4 of the additional buttons and parts of Excel.
numbers; text; formulas
Worksheet cells can contain (3):
Before you use the resources to print a worksheet, you should use ________ __________ to see how the printed pages will look.
___________ determines the best width for a column or the best height for a row based on its contents.
Text that is too long to fit within a cell is displayed in the next cell, if it is empty. If the next cell already contains data, any text that does not fit in the cell is ____________, or hidden from view.
A group of selected cells is called a _________.
As you format cells, ______ ___________ shows the results of the different formatting options you can choose.
The default ______ color of cells is white, but you can change this background color to help accentuate certain cells, such as descriptive labels or totals.
You can add emphasis to a cell by placing a _________ around its edges.
When you place the pointer over the fill handle, it changes to a _________ __________.
The ______ __________ appears in the lower-right corner of the active cell or range.
Numbers that do not fit in the cell are shown as a series of __________ ________.
A command that you use by turning a feature on or off is known as a _________ command.
When working on a document, you will sometimes delete text accidentally or change your mind about editing or formatting changes that you made. The ________ command is useful in these situations because it reverses recent actions.
Worksheet formulas consist of two components: ___________ and operators.
__________ cell references do not change when copied or moved to a new cell.
A ________ cell reference adjusts to its new location when copied or moved.
Cell references that contain both relative and absolute references are called _________ cell references.
A __________ is a collection of objects. The objects work together to store, retrieve, display, and summarize data and also to automate tasks.
In a database, each record is made up of one or more __________.
A _________ ___________ appears to the left of the first field for each record in the database.
A _________ is a database object that lets you ask the database about the data is contains.
A _______ temporarily displays records in a datasheet based on the condition that you specify.
The Slides tab and the Outline tab contain _______________ or small images of the selected slide that you are working on.
_______________ is text, objects, graphics, or pictures that have motion in a PowerPoint presentation.
_______________ refers to the way each new slide appears on the screen during a PowerPoint presentation.
The ________ _________ is the workbench for PowerPoint presentations. It displays one slide at a time and is useful for adding and editing text, inserting and formatting illustrations or objects, or generally modifying a slide's appearance.
A _________ is a symbol that is designed to help customers remember a business and its products.
___________________ is a desktop publishing program that lets you create newsletters, greeting cards, business cards, calendars, and much more.
__________ are any items that can be modified in Publisher using the provided tools and features.
The ________ __________ is a task pane used for storing text and graphics for future use.