creating charts, quickly calculating results, performing a what-if-analysis
Excel can be used to accomplish such activities as:
organize data, analyze data, represent values visually
Spreadsheets are commonly used in business to:
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 ___.
the column is too narrow to display the numerical contents of the cell
If #### is displayed in a cell ____.
Functions such as MIN, MAX, and AVERAGE are preceded by an ___ sign and the argument includes a range.
A group of related fields such as all the demographic information for one customer is called a ___.
A collection of records for a single subject, such as all of the customer records, is called a ___.
The term ___ database comes from the fact that two or more tables are linked by a common field.
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:
changing the data already stored in a record to reflect changes
"Updating" a record is defined as ___.
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 ___.
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:
If 4500 were entered in a field formatted for commas with three decimal places, Acces would display the number as ___.
35 mm slides, transparency masters, on-screen presentations, outline pages
PowerPoint can help you create all of the following:
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:
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:
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:
PowerPoint comes with 44 prepared ___ templates that have borders, colors, text attributes, and other elements arranged in a variety of formats.
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 ___.
PowerPoint has over 1000 professionally designed images you can place in your presentation called ___.
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 ___.