How can we help?

You can also find more resources in our Help Center.

55 terms

Computer Review for 2nd Semester Final

STUDY
PLAY
Access
___________________ 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
records
A database is a collection of _______
record
A __________ is a complete set of data
fields
Each record is made up of one or more ________
permanent
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 ____________
query
A _________ is a question you ask the database.
report
A _________ is commonly used to summarize data and to calculate totals.
compacting
_______________ a database rearranges how the database is stored on the disk and optimizes the performance of the database.
numbers
The purpose of the spreadsheet is to solve problems that involve _____________
spreadsheet
A ___________________ is a grid of rows and columns in which you enter text, numbers, and the results of calculations.
worksheet
In Excel, a computerized spreadsheet is called a ____________.
columns
____________ of the worksheet appear vertically, and are identified by letters at the top of the worksheet window.
rows
________ appear horizontally and are identified by numbers on the left side of the worksheet window.
cell
A ____ is the intersection of a row and column.
formula
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.
workbook
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):
print preview
Before you use the resources to print a worksheet, you should use ________ __________ to see how the printed pages will look.
AutoFit
___________ determines the best width for a column or the best height for a row based on its contents.
truncated
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.
range
A group of selected cells is called a _________.
live preview
As you format cells, ______ ___________ shows the results of the different formatting options you can choose.
fill
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.
border
You can add emphasis to a cell by placing a _________ around its edges.
black cross
When you place the pointer over the fill handle, it changes to a _________ __________.
fill handle
The ______ __________ appears in the lower-right corner of the active cell or range.
number signs
Numbers that do not fit in the cell are shown as a series of __________ ________.
toggle
A command that you use by turning a feature on or off is known as a _________ command.
undo
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.
operands
Worksheet formulas consist of two components: ___________ and operators.
Absolute
__________ cell references do not change when copied or moved to a new cell.
relative
A ________ cell reference adjusts to its new location when copied or moved.
mixed
Cell references that contain both relative and absolute references are called _________ cell references.
database
A __________ is a collection of objects. The objects work together to store, retrieve, display, and summarize data and also to automate tasks.
fields
In a database, each record is made up of one or more __________.
record selector
A _________ ___________ appears to the left of the first field for each record in the database.
query
A _________ is a database object that lets you ask the database about the data is contains.
filter
A _______ temporarily displays records in a datasheet based on the condition that you specify.
thumbnails
The Slides tab and the Outline tab contain _______________ or small images of the selected slide that you are working on.
Animation
_______________ is text, objects, graphics, or pictures that have motion in a PowerPoint presentation.
Transition
_______________ refers to the way each new slide appears on the screen during a PowerPoint presentation.
slide pane
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.
logo
A _________ is a symbol that is designed to help customers remember a business and its products.
MS Publisher
___________________ is a desktop publishing program that lets you create newsletters, greeting cards, business cards, calendars, and much more.
Objects
__________ are any items that can be modified in Publisher using the provided tools and features.
content library
The ________ __________ is a task pane used for storing text and graphics for future use.
Word
.docx
.xlxs
What is the file extension for Excel?
.pptx
What is the file extension for PowerPoint?
Access
.accdb
.pub
What is the file extension for Publisher?