Module 6

Question 1

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

Answer 1

table

Question 2

spreadsheet software

Answer 2

used to create computerized spreadsheets

Question 3

constant values

Answer 3

numerical entries in a spreadsheet

Question 4

absolute cell references

Answer 4

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

Question 5

graphics software

Answer 5

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

Question 6

T/F: Graphics are animated sequences of images.

Answer 6

false

Question 7

Label

Answer 7

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

Question 8

function

Answer 8

named, preprogrammed formula in a spreadsheet

Question 9

cloud software

Answer 9

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

Question 10

graphics

Answer 10

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

Question 11

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

Answer 11

b. field

Question 12

table

Answer 12

collection of related records

Question 13

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

Answer 13

a. shareware

Question 14

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

Answer 14

true

Question 15

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

Answer 15

c. character formatting

Question 16

word processing

Answer 16

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

Question 17

freeware

Answer 17

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

Question 18

database software

Answer 18

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

Question 19

software suite

Answer 19

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

Question 20

A group of related software programs sold together as one

unit is called a(n) __________.

Answer 20

software suite

Question 21

Database

Answer 21

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

Question 22

word wrap

Answer 22

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

Question 23

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.

Answer 23

false

Question 24

editing

Answer 24

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

Question 25

electronic slide

Answer 25

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

Question 26

public domain software

Answer 26

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

Question 27

keyboard shortcuts

Answer 27

key combinations that are faster ways of issuing commands.

Question 28

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

Answer 28

false

Question 29

Record

Answer 29

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

Question 30

workbook

Answer 30

A collection of worksheets saved in a single spreadsheet file.

Question 31

commercial software

Answer 31

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

Question 32

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

Answer 32

true

Question 33

presentation graphic

Answer 33

image designed to visually enhance a presentation

Question 34

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

Answer 34

cell

Question 35

relative cell references

Answer 35

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

Question 36

spreadsheet

Answer 36

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

Question 37

open source software

Answer 37

programs with source code made available to the general public.

Question 38

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.

Answer 38

false

Question 39

worksheet

Answer 39

a single spreadsheet divided into rows and columns

Question 40

Field

Answer 40

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

Question 41

report

Answer 41

created when a more formal output is desired

Question 42

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 1. DVD authoring software 2. media player 3. web site builder 4. personal publishing software

Answer 42

1. Listening to a music CD. 2. Media player 2. Creating a child’s birthday invitation. 4. Personal publishing software 3. Creating a home movie DVD. 1. DVD authoring software 4. Creating a Web site. 3. Web site builder

Question 43

shareware

Answer 43

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

Question 44

public domain software

Answer 44

not copyrighted, ownership donated to public domain.

Question 45

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.

Answer 45

open source

Question 46

electronic slide show

Answer 46

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

Question 47

insertion point

Answer 47

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

Question 48

Cell

Answer 48

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

Question 49

software license

Answer 49

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.

Question 50

query

Answer 50

question or request for specific information from the database

Question 51

installed software

Answer 51

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

Question 52

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 _____

Answer 52

insertion point or cursor

Question 53

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

Answer 53

false

Question 54

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

Answer 54

true

Question 55

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

Answer 55

burning

Question 56

Shareware

Answer 56

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

Question 57

formatting

Answer 57

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

Question 58

multimedia

Answer 58

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

Question 59

cell

Answer 59

intersection of row and column

Question 60

Formula

Answer 60

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

Question 61

Software that is delivered via the Web is called _____

Answer 61

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

Question 62

microsoft office ribbon

Answer 62

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