Final Review BCIS 1305

25 tasks, 75 multiple choice – Comprehensive

ECC, Windows, Word, Excel, Access, Power Point, Integration – uses for each application

ECC/Windows

Definition of a computer

Operating system

Moving, copying

Html

Help & support

Firewall

Check mark, ellipsis, Triangular arrow, grayed out

Detail view, thumbnail view, tiles view

Peripheral devices

Bit, byte, kilobyte, megabyte, gigabyte, terabyte

Root directory

USB, SCSI, MIDI

Recycle bin

Word

Alignment,

AutoComplete

AutoCorrect

Bullets

Clipboard

Endnotes, footnotes

Nonprinting characters

Page break, section break

Paragraph, word

Selection Bar

Tables

Excel

AutoFill

AutoSum

Calculations – order of arithmetic operations

Chart types & their uses – bar, column, line, pie

Charts: embedded, sheet

Conditional formatting

Data alignment in cells(numbers, labels)

Formula view

Function: SUM, PMT, IF, MIN, MAX

Merge and center

Portrait, landscape

What if analysis

Access

AND, OR

Data redundancy

Data types: text, number, OLE, AutoNumber

Datasheet view, Design View

DBMS

Entity integrity

Form

ID field

One-to many relationship

Pencil, star, infinity

Primary key

Problems with bad data

QBE

Query

Referential integrity

Report

Sorts, multi field sorts

Power Point

6 X 6 Rule

Handouts

Outline

Placeholder

Slide master

Slide sorter view

Speaker notes

Theme