Computer Review for 2nd Semester Final

55 terms by elizaorr98 

Create a new folder

Advertisement Upgrade to remove ads

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?

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set