Bcis Exam 2

Front 1

Name the components of a MIDI system

Back 1

MIDI port, MIDI protocol, and the Standard MIDI fire format

Front 2

A _____ is a perpheral device or chip that creates sound from digital instructions input by the user.

Back 2

synthesizer

Front 3

True or False: The RIAA is focusing primarily on companies in their battle against copyright infringement.

Back 3

False

Front 4

What is a fractal?

Back 4

an art form that uses mathematical formulas to create a geometric pattern that is repeated over and over, either at smaller or larger scales.

Front 5

What is splitting?

Back 5

involves segmenting a video into smaller scenes for easier editing.

Front 6

_______ is a special effect in which one video image is transformed into another image over the course of several frames of video.

Back 6

morphing

Front 7

True or False: It is legal to add still or video images to live broadcasts so that they look as if they are part of the original scene.

Back 7

True

Front 8

In 3-D animation, a(n)_____ model forms the basis for generating an artificial character or object

Back 8

wireframe

Front 9

The _____ of an ECU allows the various modules in the car to send data to and from the ECU.

Back 9

communication bus

Front 10

True or False: Night vision systems generate an image of the road in black and white.

Back 10

True

Front 11

Where are the sensors of a collison warning system placed?

Back 11

Sensors are placed on the bumper and below each door

Front 12

______ Is a system that maintains a safe driving interval between your car and other vehicles by changing the gears or by applying the brakes.

Back 12

adaptive cruise control (ACC)

Front 13

The _____ oversees all air traffic control in the U.S.

Back 13

Air Traffic Control System Command Center (ATSCC)

Front 14

Who completes the preflight routine, which includes transmitting a flight plan to the air traffic control tower?

Back 14

the pilot

Front 15

What is the purpose of a global distribution system? (GDS)

Back 15

maintain a database to provide travel providers and consumers information about available flights and seats and to manage inventory

Front 16

A(n) ____ helps train airline pilots by modeling the experiences of being inside the cockpit of a plane

Back 16

flight simulator

Front 17

Computerized tutorials can be programmed to perform a(n)____, which is a formal process of identifying discrepancies between your current understanding of a topic and an understanding defined as mastery of the topic.

Back 17

needs assessment

Front 18

A(n)____ is a project in which students use Internet resources to answer open-ended questions presented around a particular topic.

Back 18

WebQuest

Front 19

Name an outline encyclopedia and an online Web site that has information geared towards students

Back 19

Encyclopedia Britannica, CNN Student News

Front 20

_____ is a simplified programming language invented at MIT by Seymour Papert

Back 20

LOGO

Front 21

True or False: A Web-based message board does not require a newsreader

Back 21

True

Front 22

____ means that the people who are communicating are online at the same time

Back 22

Real Time

Front 23

A(n)____ is a computer-based management administration system that tracks students' progress and performance in the classroom.

Back 23

learning management system (LMS)

Front 24

Define the difference between synchronous and asynchronous distance learning

Back 24

synchronous setting: students and instructor attend class at a specific time and information is shared in real time.
asynchronous: students access course resources at whatever time is convenient and communicate through e-mail and mailing lists

Front 25

A ___ is a collection of text and numbers laid out in a rectangular grid.

Back 25

spreadsheet

Front 26

In spreadsheet terms, a(n)___ contains an Excel chart that provides a visual representation of spreadsheet data.

Back 26

chart sheet

Front 27

A_____ reminds you why you crated a workbook and what is contains

Back 27

documentation sheet

Front 28

To enter additional lines in a cell, press the _____

Back 28

Alt+Enter keys

Front 29

A ____ is a single point on a computer monitor or printout

Back 29

Pixel

Front 30

What is the default column width

Back 30

8.38 standard-size characters- about 8 or 9 characters

Front 31

True/False: If you increase the font size of characters, you can fit more text within a given cell

Back 31

False

Front 32

A(n)____ is a mathematical expression that calculates a value

Back 32

formula

Front 33

True/False: A worksheet can contain the following type of data: text, numeric values, dates, adn calculated values.

Back 33

True

Front 34

The____ calculates the total number of values

Back 34

COUNT

Front 35

True/False: Functions are used to simplify formulas

Back 35

True

Front 36

New Excel workbooks contains how many worksheets?

Back 36

Three

Front 37

True/False: Worksheets cannot be deleted

Back 37

False

Front 38

To edit a cell's contents, you need to work in _____

Back 38

editing mode

Front 39

True/False: You can reverse more than one action by clicking on the Undo button's list arrow

Back 39

True

Front 40

To toggle in and out of formula view, press the _____ keys

Back 40

Ctrl+keys. The ` grace accent symbol is usually located about the Tab key on your keyboard

Front 41

_____ a printout reduces the width and the height of the printout to fit the number of pages you specify by shrinking the text size as needed.

Back 41

Scaling

Front 42

The ____ alloows you to see the effects of formatting options on the workbook's appearance before you apple them

Back 42

Live Preview

Front 43

True/False: The Office theme is the default theme

Back 43

True

Front 44

True/False: Italic and bold are examples of a font style

Back 44

True

Front 45

True/False: A type style is a set of characters that employ the same typeface

Back 45

False

Front 46

True/False: Theme colors are the 12 colors that belong to the workbook's theme

Back 46

True

Front 47

True/False: You cannot change the background image of a worksheet

Back 47

False

Front 48

Dates and times in Excel appear as _____

Back 48

text

Front 49

Dates are actually measured from what date?

Back 49

January 1, 1900 at 12 a.m.

Front 50

True/False: Combining several cells into one cell is called aligning

Back 50

False

Front 51

True/False: Text is oriented within a cell horizontally from left to right

Back 51

True

Front 52

You can also open the Format Cells dialog box by ____ a cell.

Back 52

right-clicking

Front 53

To see more Border options, in the Font group on the Home tab, click the _____

Back 53

Borders button arrow

Front 54

The most efficient way for copying only formatting is to use the ______ feature.

Back 54

Format Painter

Front 55

True/False: The Format Painter will allow you to copy formatting only to adjacent cells

Back 55

False

Front 56

True/False: A style is a collection of formatting

Back 56

True

Front 57

True/False: Excel has built-in styles to format worksheet titles

Back 57

True

Front 58

True/False: Only fonts, not colors or cell styles, are organized in theme and non-theme categories

Back 58

False

Front 59

True/False: You can save a workbook's theme as a file that can used in other workbooks or Office files

Back 59

True

Front 60

True/False: To make a worksheet active, click on the sheet tab

Back 60

True

Front 61

True/False: After you apply a table style, you can choose which table elements you want included in the style

Back 61

True

Front 62

True/False: You can use cell styles and other formatting tools to individual cells and ranges to format Excel tables.

Back 62

True

Front 63

True/False: Conditional formatting in a worksheet is special formatting applied when certain cell values meet one or more conditions

Back 63

True

Front 64

True/False: A data bar is a vertical bar added to the background of a cell.

Back 64

False

Front 65

True/False: If there is too much data to fit into the worksheet window, apply the Zoom tool.

Back 65

False

Front 66

True/False: Hiding rows, columns, and worksheets is an excellent way to conceal extraneous or distracting information

Back 66

True

Front 67

Use the ____ symbol to make a cell reference absolute.

Back 67

dollar $

Front 68

True/False: A relative reference is a cell reference that changes when it is copied and pasted in a new location

Back 68

True

Front 69

True/False: Functions are organized in the Function Library group

Back 69

True

Front 70

True/False: To add a collection of numbers, use the COUNT function

Back 70

False

Front 71

To let Excel know you want to enter a formula, after clicking in a cell press the ____ key

Back 71

Equal sign =

Front 72

True/False: AutoFill copies content but not formats from a cell or range into an adjacent cell or range

Back 72

False

Front 73

True/False: The small black square in the lower-right corner of a selected cell or range is called the AutoFill button

Back 73

False

Front 74

If you dont want the cell reference to change when you copy the formula use the _____ reference

Back 74

Absolute

Front 75

B$4 is an example of a(n)_____ reference

Back 75

mixed

Front 76

What symbol appears at the beginning of a function?

Back 76

an equal sign =

Front 77

A(n) _____ is a symbol that indicated the relationship between two values

Back 77

comparison operator

Front 78

True/False: The TODAY function doesn't have any arguments

Back 78

True

Front 79

True/False: The DATE function creates a value that represents the current data based on the system data.

Back 79

False

Front 80

The _____ function will return the monthly payment required to pay off a loan

Back 80

PMT

Front 81

To determine how much an investment will be worth after a series of monthly payments at some future time, use the _____ function

Back 81

FV (future value)

Front 82

Each chart must have a(n) ____.

Back 82

data source

Front 83

Which chart compares relative values or different categories to the whole?

Back 83

Pie Chart

Front 84

The ____ specifies the worksheet cells that contain the data on which the chart will be based.

Back 84

chart options

Front 85

True/False: A pie chart compares relative values of different categories to the whole

Back 85

True

Front 86

True/False: An exploded pie chart moves on slice away from the pie as if someone were taking the piece out of the pie.

Back 86

True

Front 87

True/False: Leader lines can be added to labels placed outside the slices to connect them to their corresponding slices

Back 87

True

Front 88

True/False: Charts remain linked or connected to their data sources, even if they appear in different worksheets

Back 88

True

Front 89

True/False: If you change any values or labels in the data source, the chart must be manually updated to show the new content

Back 89

False

Front 90

The ____, or value, axis displays the values associated with the heights of each column

Back 90

vertical

Front 91

The ____, or category, axis displays the categories associated with each data value

Back 91

horizontal

Front 92

True/False: A bar chart compares values from different categories

Back 92

False

Front 93

True/False: A line chart is often used to show trends and changes over time

Back 93

True

Front 94

True/False: A quick way to copy formatting is to use the Format Painter button

Back 94

True

Front 95

True/False: The Select Data Source dialog box lists all of the data series displayed in the chart.

Back 95

True

Front 96

How do you know which type of chart to use with your data?

Back 96

Pie charts are generally used when the # of categories is small & the relative sizes of the different slices can be easily determined. Column or bar chart for several categories. Line charts for categories that follow a sequential order.

Front 97

True/False: You cannot add text to a shape.

Back 97

False

Front 98

To select more than one shape, hold down the _____ key, then click each of the remaining shapes

Back 98

Shift

Front 99

True/False: A chart sheet can contain embedded charts

Back 99

True

Front 100

True/False: A chart cannot be rotated in the chart sheet

Back 100

False

Front 101

True/False: When you edit cells in a worksheet group, the changes you make to one worksheet are automatically applied to the other worksheets in the group.

Back 101

True

Front 102

To ungroup worksheets, right-click _____.

Back 102

any sheet tab

Front 103

What is the first step in copying worksheets to another workbook?

Back 103

select the sheet tab you want to copy

Front 104

True/False: The fastest way to copy an entire worksheet to press and hold the Alt key as you drag and drop the sheet tab

Back 104

False

Front 105

To print the grouped worksheets, first do what?

Back 105

Select the first and last grouped worksheets

Front 106

To view the other grouped worksheets in the print preview click the ____.

Back 106

Next Page button

Front 107

A _____ is a connection between the files that allows data to be transferred from one file to the other.

Back 107

link

Front 108

When two files are linked, the _____ file is the workbook that contains the data

Back 108

source

Front 109

The _____ is displayed at the end of the table.

Back 109

Total row

Front 110

The _____ file (sometimes referred to as the dependent file) is the workbook that receives the data.

Back 110

destination

Front 111

True/False: A reference in a formula that referes to another workbook is called a workbook reference

Back 111

False

Front 112

True/False: When you break a link using the Break Links command in the Edit Links dialog box, all the external reference formaulas are converted to their most recent values

Back 112

True

Front 113

A ____ is a link in a file

Back 113

hyperlink

Front 114

True/False: To use a hyperlink, you click the anywhere inside the cell that contains the link

Back 114

False

Front 115

When you start Excel and see the blank workbook called Book1, you are actually using a workbook based on a template known as the____ template

Back 115

default

Front 116

True/False: You can create a workbook with all the formulas and formatting you need and then save it as a template on which you can base other workbooks

Back 116

True

Front 117

A ______ is a workbook template you create that is ready to run with the formulas for all calculations included as well as all formatting

Back 117

Custom template

Front 118

True/False: When you save a worksheet as a Web page, Excel converts the contents of the worksheet into XML

Back 118

False

Front 119

True/False: You can save an item in a worksheet as a Web page

Back 119

True

Front 120

When a text file's data is separated by commas, it is said to be _____

Back 120

delimited

Front 121

True/False: A text file contains number, text, formulas, and special fonts

Back 121

False

Front 122

A ____ is a defined method of retrieving data from an external file

Back 122

Connection

Front 123

To delete a connection to its data source, select the connection in the list in the Workbook Connections dialog box, and then click the ____ button.

Back 123

Remove

Front 124

True/False: You can define how Excel updates, or refreshes, the data.

Back 124

True

Front 125

How do you apply a connection to a new location?

Back 125

Click the Existing Connections button in the Get External Data group on the Data tab. Open the connection you want to apply, and specify the new location in the workbook

Front 126

Where do you find the Trust Center in Excel?

Back 126

Click the Office Button and then click the Excel Options button

Front 127

You define a trusted location through the _____.

Back 127

Trust Center

Front 128

True/False: When other users copy your Excel projects to their own computers, path names to external data sources might change and become unusable

Back 128

True

Front 129

A _____ is a file that stores a collection of related data

Back 129

database

Front 130

A ____ is a collection of data arranged in rows and columns

Back 130

table

Front 131

A ____ is a question you ask about the data in the database

Back 131

query

Front 132

True/False: In a database, a table and a query are actually the same thing

Back 132

False

Front 133

True/False: The first step in the Query Wizard is to create a data source

Back 133

True

Front 134

What is a filter?

Back 134

When you filter data, you specify which records you want to retrieve using specific criteria

Front 135

True/False:When Excel imports external data into a PivotTable, the initial table is empty.

Back 135

True

Front 136

True/False: You cannot connect a new Pivot Table to an external data source

Back 136

False

Front 137

When you _____ a query, Excel retrieves the most current data from the data source, using the query definition you have created

Back 137

refresh

Front 138

____ is a file format that allows for text formatting styles including boldface, italic, and color, but not advanced features such as hyperlinks or complicated table structures

Back 138

Rich Text Format (RTF)

Front 139

How do you edit a Web query?

Back 139

Web query files are simple text files, so you can view and edit their contents in Notepad. If you undestand the Web query language, you can create sophisticated programs to retrieve and process Web data.

Front 140

______ are abbreviations for the stock names used by the market

Back 140

Ticker symbols

Front 141

True/False: You cannot manually refresh a Web query

Back 141

False

Front 142

Data in an XML document is contained within _____.

Back 142

elements

Front 143

A(n) ____ marks the beginning of the data value

Back 143

opening tag

Front 144

A(n) _____ can be created that displays the layout of the elements in a schematic diagram

Back 144

data map