BCA Final

Terms	Definitions
spreadsheet	Excel 2000 can best be described as ___ software.
numeric calculations	An electronic spreadsheet uses a computer to perform ___.
creating charts, quickly calculating results, performing a what-if-analysis	Excel can be used to accomplish such activities as:
recalculating	Excel has the capability of automatically ___ results.
existing	New Excel worksheets can be created from ___ ones.
worksheet	The document you produce when you use Excel is a ___.
what-if-analysis	A decision-making feature of Excel is a ___.
creating charts, sharing information, what-if-analysis	Examples of Excel's versatility are:
organize data, analyze data, represent values visually	Spreadsheets are commonly used in business to:
numbers, text, or formulas	A cell can contain ___, ___, and ___.
workbook	Excel groups worksheets together and calls them a ___.
the coordinates of the intersecting columns and rows	The cell address is identified by ___.
label	When a cell contains both text and numbers, Excel recognizes the entry as a ___.
to identify data in rows, to identify the data in columns, to make the worksheet more understandable	Labels are used in a worksheet to:
informating using a question and answer format and tips indicated by a light bulb you can click	The Office Assistant provides ___ and ___.
rows and columns of data	A spreadsheet is ___.
range	A group of adjacent cells from a row or column is a ___.
mathematical statements used to calculate values	Formulas are ___.
45	The formula =56+35 will produce the result ___.
the column is too narrow to display the numerical contents of the cell	If #### is displayed in a cell ____.
functions	To produce commonly performed calculations, Excel contains built-in ___.
rows or columns	In an Excel spreadsheet, it is possible to insert or delete ___ or ___.
MIN	You use the ___ function to calculate the minimum or smallest value in a selected range.
MAX	You use the ___ function to calculate the maximum or largest value in a selected range.
equal (=)	Functions such as MIN, MAX, and AVERAGE are preceded by an ___ sign and the argument includes a range.
database	Access 2000 can best be described as ___ software.
field	The smallest piece of information in a database is called a ___ or category of information.
record	A group of related fields such as all the demographic information for one customer is called a ___.
table	A collection of records for a single subject, such as all of the customer records, is called a ___.
objects	Tables, queries, and modules are examples of Access ___.
relational	The term ___ database comes from the fact that two or more tables are linked by a common field.
table	The Access object that contains all of the raw data within the database is the ___.
form	The Access object which provides an easy-to-use data entry screen is the ___.
database	A ___ is a collection of information associated with a topic such as sales.
purpose, meaningful title	The first step to planning a database is to determine the ___ and give it a ___.
a library card catalog, a list of students attending SLCHS, a list of addresses	Examples of databases could include:
currently selected	An active field is the ___ field.
drag it to the new location	The best way to reposition a field within a form is to ___.
Design	___ View allows you to add, delete, or modify the fields in a table.
changing the data already stored in a record to reflect changes	"Updating" a record is defined as ___.
Entry bar	As data is entered into a field from the keyboard, it is displayed on the ___.
report	A ___ is a selected group of information extracted from a database, usually printed.
formula	A calculation field stores a ___.
match the query criteria are displayed	After a query is applied to a database only those records that ___.
the order of the records is changed based on the values specified	When a database is sorted the order of the records is ___.
$50.00	If the number 50 were entered in a field formatted with currency and two decimal places, Access would display the number as ___.
to determine how fields should appear when printed, to exclude unnecessary information, to make the report easier to read	Reasons for carefully planning a report before creating it include:
intersection of the column and the row	On a report screen, a cell is the ___.
4,500.000	If 4500 were entered in a field formatted for commas with three decimal places, Acces would display the number as ___.
[Enter]	In Navigation mode, press [Tab] or ___ to move to the next field within the same record.
presentation	PowerPoint 2000 can best be described as ___ software.
35 mm slides, transparency masters, on-screen presentations, outline pages	PowerPoint can help you create all of the following:
slide view, notes page view, outline view	PowerPoint views include:
Microsoft Excel, Microsoft Access, Microsoft Word, Corel Word Perfect	With PowerPoint, you can import information from spreadsheet, database, and word-processing files prepared in programs such as:
the purpose of the presentation; the type of output that best conveys your message; a look for your presentation that will help communicate your message; the message you want to communicate, then give the presentation a meaningful title; additional materials will be usefull in the presentation	In planning a presentation, it is important to determine:
AutoContent Wizard	The quickest way to create a presentation is by using the ___.
creates a title slide with sample text for the presentation category you choose	The AutoContent Wizard ___.
opens a new slide dialog box allowing you to choose a predesigned slide layout	The Blank Presentation option in the PowerPoint startup dialog box ___.
keep message focused, do not put everything you are going to say on your presentation slides; choose attractive colors that make the slide easy to read; choose font styles that are easy to read and emphasize important text	When you evaluate your presentation, you should make sure it follows the following criteria:
the purpose of the presentation, what you want to produce when the presentation is finished, what type of output you will need to best convey your message	Guidelines for planning a presentation include determining:
spellchecker	The ___ will not identify "there" as being misspelled if the correct word for the context is "their".
notes for the speaker, handouts for the audience	Supplementary materials for your presentation could include:
design	PowerPoint comes with 44 prepared ___ templates that have borders, colors, text attributes, and other elements arranged in a variety of formats.
sound and animation	Animation effects let you add ___ and ___ to a PowerPoint presentation.
Viewer	To show a PowerPoint slide show, your computer needs to have either PowerPoint or the PowerPoint ___.
picture, a graph, and a clip art image	The most common visuals to enhance a presentation are a ___, a ___, and a ___.
gallery	Clip art is stored in a file index system called a ___.
clip art	PowerPoint has over 1000 professionally designed images you can place in your presentation called ___.
chart	A graph object is made up of a database and a ___.
area, bar, pie	Types of PowerPoint Graph charts include ___, ___, ___.
a background design, a color scheme, text placeholders	PowerPoint's design templates contain:
one at a time	Slide Show view flls your computer screen with the slides of your presentation displaying them ___.
discuss the material on each slide	Setting the right slide timing is important because it determines the amount of time you have to ___.
determine the location and audience	Before creating a presentation, you should ___.
free up computer memory for other uses, close the PowerPoint program and return to the windows desktop	When you exit PowerPoint you:

First Time Here?

Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.

Set Champions

Space Race Champion

80 points by emmiekate

BCA Final

Share this set

About this set

Created by:

Discuss

BCA Final

Study:

Games:

Tools:

75 terms

Terms

Definitions

First Time Here?

Set Champions

Space Race Champion