Bus309 Final

Front 1

Templates begin on the _______

Back 1

Slide master

Front 2

A absolute cell reference is denoted by a:

Back 2

Dollar sign $$$

Front 3

The inputs used by an Excel function are called:

Back 3

Arguments

Front 4

A _______ is a form created from one table but it has a Form view and a Datasheet view in the same window.

Back 4

Split form

Front 5

______ is the error message you get when you attempt to use a cell that has been deleted as a function argument

Back 5

#REF!

Front 6

Three primary charting objectives are:

Back 6

data exploration

argumentation

hypothesis testing

Front 7

To show changes over time you would use a:

Back 7

Line chart

Front 8

To place an object such as a circle or square into a chart, you click the ________ in the _______ group on the __________ tab

Back 8

Shapes

Illustrations

Insert

Front 9

The text suggests for each hour of presentation, you allow _______ of planning time

Back 9

four hours

Front 10

Data is stored in Excel in ______ and ______

Back 10

Rows

Columns

Front 11

In a presentation a ______ would be used to show comparison of the parts to the whole

Back 11

pie chart

Front 12

PowerPoint's default view is the ______ view

Back 12

Normal

Front 13

During a presentation, pressing ______ will advance to the next slide.

Back 13

spacebar

Front 14

______ are small lines at the end of the letters

Back 14

serifs

Front 15

the recommended minimum font size for text in the body of a slide is ______

Back 15

18 points

Front 16

To select multiple shapes press and hold ______ while clicking each shape

Back 16

Shift

Front 17

______ is text that has been enriched by color, outlines, shadows, or special effects

Back 17

Word Art

Front 18

______ are defined as the visual and audio elements that occur as the slides change

Back 18

transitions

Front 19

While working on a slide show, consider your ______ as you add audio to your presentation

Back 19

audience

Front 20

______ are short notes explaining your thoughts

Back 20

comments

Front 21

While practicing a presentation the people you enlist to watch can make you aware of ______ and ______ ______

Back 21

verbal and non-verbal distractions

Front 22

Pictures, tables, charts, and sound clips are examples of ______ that can be selected and manipulated independently

Back 22

objects

Front 23

the related data values used in creating a chart are called ______

Back 23

data series

Front 24

a ______ is a field that uniquely identifies the record

Back 24

primary key field

Front 25

the file into which you insert an object is called the ______

Back 25

destination file

Front 26

to link a chart, you select the ______ option in the Paste Special dialog box

Back 26

Paste Link

Front 27

An object is automatically updated when the destination file is closed and then opened, unless you turn off ______ in the Links option

Back 27

automatic updates

Front 28

Both ______ and ______ can be used to collect, store, and sort data

Back 28

Excel

Access

Front 29

Column headings in Excel become ______ when imported into Access

Back 29

field names

Front 30

In a well-designed database, a ______ is selected for every table

Back 30

primary key

Front 31

an ______ is a hierarchical representation of paragraphs that are recognized by Word by nonprinting, end-of-paragraph marks

Back 31

outline

Front 32

the ______ allows you to show the lower levels of an outline after they've collapsed

Back 32

expand button

Front 33

PowerPoint can only make slides from a Word document if the document is ______

Back 33

closed

Front 34

If a security warning appears when you open a database, and you trust the contents, you should click the ______ button

Back 34

Enable Content

Front 35

You are reading a report that shows Company A generated $2000 last week This would be ______

Back 35

information

Front 36

______ are facts about people, events, things, or ideas

Back 36

data

Front 37

When you open a database, Access displays the ______ on the left side

Back 37

Navigation Pane

Front 38

Access is different from Excel because Access allows ______

Back 38

multiple tables with relationships between the tables

Front 39

an ______ is an alternative to using a space in a named range

Back 39

underscore

Front 40

______ define the kind of data that can be entered into a field, like numbers, text, and dates

Back 40

data types

Front 41

when creating presentations, remember the KISS concept:

Back 41

Keep It Short and Simple

Front 42

______ give more information on how the data is stored, entered, and processed

Back 42

field properties

Front 43

Data stored as an ______ file cannot be imported into a table in Access

Back 43

Adobe PDF

Front 44

______ is a feature that can change the column width of the data to match the widest data entered in that field

Back 44

Auto Fit

Front 45

______ prior to the presentation gives you a feel for how you might be able to move and engage the audience during the speech

Back 45

Walking around the room

Front 46

In a query, you can select any records that have no value in a field using the ______ criteria.

Back 46

Is Null

Front 47

When you create a form from two tables that have a one-to-many relationship, the first table selected becomes the ______ and the second table you select becomes the ______

Back 47

main form

subform

Front 48

______ begin on the slide master

Back 48

Templates

Front 49

A split form is a form created from one table, but it has ______ a ______ in the same window

Back 49

Form view

Datasheet view

Front 50

______ are examples of objects that can be selected and manipulated

Back 50

Pictures, tables, charts, sound clips

Front 51

______ in Excel becomes field names when imported into Access

Back 51

Column headings