Module 6 Flashcards

1
Q

In a relational database, the database object that contains the actual data is the ___

A

table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

spreadsheet software

A

used to create computerized spreadsheets

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

constant values

A

numerical entries in a spreadsheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

absolute cell references

A

formulas are copied exactly as they are written; for when you want to use a specific cell address in all copies of the formula; use $ to make cell reference absolute- $B$6

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

graphics software

A

used to create or modify graphics, edit digital audio or video, play multimedia files, and burn CDs and DVDs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

T/F: Graphics are animated sequences of images.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Label

A

A text-based entry in a worksheet cell that identifies data on the worksheet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

function

A

named, preprogrammed formula in a spreadsheet

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

cloud software

A

delivered on demand, via the web. Aka software as service (SaaS), web-based software, and cloudware.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

graphics

A

digital representations of images, such as digital photos, clipart, scanned drawings, and original images created using a software program

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

A single category of data to be included in a database (viewed as a column in a table) is called a __________.

a. record
b. field
c. table

A

b. field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

table

A

collection of related records

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Software programs that are distributed on the honor system
and can be legally and ethically shared with others to try out
the software are referred to as _________.
a. shareware programs
b. commercial software
c. public domain software

A

a. shareware

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

T/F: Changing the font size in a document is an example of a formatting operation.

A

true

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Changing the font face or size of text in a document is an example of which word processing feature?

a. page orientation
b. paragraph formatting
c. character formatting

A

c. character formatting

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

word processing

A

uses a computer and word processing software to create, edit, save, and print written documents.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

freeware

A

copyrighted software given away by the author to use free of charge.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

database software

A

aka database management system (DBMS) allows the creation and manipulation of an electronic database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

software suite

A

a collection of software programs bundled together and sold as a single software package. Eg. Microsoft office.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

A group of related software programs sold together as one

unit is called a(n) __________.

A

software suite

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Database

A

A collection of related data that is stored in a manner enabling information to be retrieved as needed.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

word wrap

A

automatically returns the insertion point to the next line when the end of the screen line is reached.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

T/F: In a word processing document, the Enter key is always pressed at the end of each screen line to move down to the next line.

A

false

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

editing

A

changing the contents of a document, such as inserting or deleting words.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Q

electronic slide

A

one page presentation graphic that can include text, images, video, and more

26
Q

public domain software

A

Software that is not copyrighted and may be used without restriction.

27
Q

keyboard shortcuts

A

key combinations that are faster ways of issuing commands.

28
Q

T/F: The formula =A2+B2 located in cell C2 would multiply the two cells to the left of cell C2.

A

false

29
Q

Record

A

A collection of related fields in a database; also called a row.

30
Q

workbook

A

A collection of worksheets saved in a single spreadsheet file.

31
Q

commercial software

A

developed and sold for profit, often with a single-user license

32
Q

True or False: A spreadsheet document created in spreadsheet program is often called a worksheet.

A

true

33
Q

presentation graphic

A

image designed to visually enhance a presentation

34
Q

The intersection of a row and column into which spreadsheet data may be typed is called a(n) ________.

A

cell

35
Q

relative cell references

A

cell addresses are adjusted as the formula is copied to reflect the new location of the formula

36
Q

spreadsheet

A

contains a group of numbers and other data organized into rows and columns

37
Q

open source software

A

programs with source code made available to the general public.

38
Q

True or False: Each slide in a slide presentation can contain only one type of element, such as text, an image, or a video clip.

A

false

39
Q

worksheet

A

a single spreadsheet divided into rows and columns

40
Q

Field

A

A single category of data to be stored in a database, such as a person’s name or phone number; also called a column.

41
Q

report

A

created when a more formal output is desired

42
Q

Match each application with its type of application program, and write the corresponding number in the blank to the left of each application.

  1. listening to a music CD
  2. creating a child’s birthday invitation
  3. creating a home movie DVD
  4. creating a website
  5. DVD authoring software
  6. media player
  7. web site builder
  8. personal publishing software
A
  1. Listening to a music CD.
  2. Media player
  3. Creating a child’s birthday invitation.
  4. Personal publishing software
  5. Creating a home movie DVD.
  6. DVD authoring software
  7. Creating a Web site.
  8. Web site builder
43
Q

shareware

A

copyrighted software distributed on the honor system. Consumers should pay for it or uninstall after the trial.

44
Q

public domain software

A

not copyrighted, ownership donated to public domain.

45
Q

With a(n) ____ program, the source code for the program is made available to the public and so it can be legally modified by others.

A

open source

46
Q

electronic slide show

A

group of electronic slides that are displayed one after another on a computer monitor or other display device

47
Q

insertion point

A

indicates the current location in a document where the changes will be made.

48
Q

Cell

A

The location at the intersection of a row and column on a worksheet into which data can be typed.

49
Q

software license

A

An agreement, either included in a software package or displayed on the screen when the software is installed or launched, that specifies the conditions under which the program can be used.also called end user license agreement (EULA), often terms of use instead for mobile apps.

50
Q

query

A

question or request for specific information from the database

51
Q

installed software

A

must be installed on computer before it can run. Can be purchased in physical form or downloaded. Can be free or fee-based.

52
Q

The blinking vertical line displayed on the screen that indicates the current location in a document, such as where the next change will be made to the document in a word processing program, is called the _____

A

insertion point or cursor

53
Q

True or False: Software purchased via the Internet is always
provided as a download rather than as a package.

A

false

54
Q

T/F: Microsoft Office is one example of a software suite.

A

true

55
Q

DVD ________ refers to recording data (such as a collection of songs or a finished video) on a recordable or rewritable DVD.

A

burning

56
Q

Shareware

A

Copyrighted software that is distributed on the honor system; consumers should either pay for it or uninstall it after the trial period.

57
Q

formatting

A

changes the appearance of the document. I.e. font size, color, line spacing, margins, shading, borders.

58
Q

multimedia

A

technically refers to any application that contains more than one type of media. Typically refers to audio or video content.

59
Q

cell

A

intersection of row and column

60
Q

Formula

A

An entry in a worksheet cell that performs computations on worksheet data and displays the results.

61
Q

Software that is delivered via the Web is called _____

A

cloud software, Web-based software, Software as a Service (SaaS), or cloudware

62
Q

microsoft office ribbon

A

arrived with office 2007, line of tabs with commands organized into groups located on tabs. Contextual tabs appear as needed and contain special commands.