Module 6 Flashcards
In a relational database, the database object that contains the actual data is the ___
table
spreadsheet software
used to create computerized spreadsheets
constant values
numerical entries in a spreadsheet
absolute cell references
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
graphics software
used to create or modify graphics, edit digital audio or video, play multimedia files, and burn CDs and DVDs
T/F: Graphics are animated sequences of images.
false
Label
A text-based entry in a worksheet cell that identifies data on the worksheet.
function
named, preprogrammed formula in a spreadsheet
cloud software
delivered on demand, via the web. Aka software as service (SaaS), web-based software, and cloudware.
graphics
digital representations of images, such as digital photos, clipart, scanned drawings, and original images created using a software program
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
b. field
table
collection of related records
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. shareware
T/F: Changing the font size in a document is an example of a formatting operation.
true
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
c. character formatting
word processing
uses a computer and word processing software to create, edit, save, and print written documents.
freeware
copyrighted software given away by the author to use free of charge.
database software
aka database management system (DBMS) allows the creation and manipulation of an electronic database
software suite
a collection of software programs bundled together and sold as a single software package. Eg. Microsoft office.
A group of related software programs sold together as one
unit is called a(n) __________.
software suite
Database
A collection of related data that is stored in a manner enabling information to be retrieved as needed.
word wrap
automatically returns the insertion point to the next line when the end of the screen line is reached.
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.
false
editing
changing the contents of a document, such as inserting or deleting words.
electronic slide
one page presentation graphic that can include text, images, video, and more
public domain software
Software that is not copyrighted and may be used without restriction.
keyboard shortcuts
key combinations that are faster ways of issuing commands.
T/F: The formula =A2+B2 located in cell C2 would multiply the two cells to the left of cell C2.
false
Record
A collection of related fields in a database; also called a row.
workbook
A collection of worksheets saved in a single spreadsheet file.
commercial software
developed and sold for profit, often with a single-user license
True or False: A spreadsheet document created in spreadsheet program is often called a worksheet.
true
presentation graphic
image designed to visually enhance a presentation
The intersection of a row and column into which spreadsheet data may be typed is called a(n) ________.
cell
relative cell references
cell addresses are adjusted as the formula is copied to reflect the new location of the formula
spreadsheet
contains a group of numbers and other data organized into rows and columns
open source software
programs with source code made available to the general public.
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.
false
worksheet
a single spreadsheet divided into rows and columns
Field
A single category of data to be stored in a database, such as a person’s name or phone number; also called a column.
report
created when a more formal output is desired
Match each application with its type of application program, and write the corresponding number in the blank to the left of each application.
- listening to a music CD
- creating a child’s birthday invitation
- creating a home movie DVD
- creating a website
- DVD authoring software
- media player
- web site builder
- personal publishing software
- Listening to a music CD.
- Media player
- Creating a child’s birthday invitation.
- Personal publishing software
- Creating a home movie DVD.
- DVD authoring software
- Creating a Web site.
- Web site builder
shareware
copyrighted software distributed on the honor system. Consumers should pay for it or uninstall after the trial.
public domain software
not copyrighted, ownership donated to public domain.
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.
open source
electronic slide show
group of electronic slides that are displayed one after another on a computer monitor or other display device
insertion point
indicates the current location in a document where the changes will be made.
Cell
The location at the intersection of a row and column on a worksheet into which data can be typed.
software license
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.
query
question or request for specific information from the database
installed software
must be installed on computer before it can run. Can be purchased in physical form or downloaded. Can be free or fee-based.
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 _____
insertion point or cursor
True or False: Software purchased via the Internet is always
provided as a download rather than as a package.
false
T/F: Microsoft Office is one example of a software suite.
true
DVD ________ refers to recording data (such as a collection of songs or a finished video) on a recordable or rewritable DVD.
burning
Shareware
Copyrighted software that is distributed on the honor system; consumers should either pay for it or uninstall it after the trial period.
formatting
changes the appearance of the document. I.e. font size, color, line spacing, margins, shading, borders.
multimedia
technically refers to any application that contains more than one type of media. Typically refers to audio or video content.
cell
intersection of row and column
Formula
An entry in a worksheet cell that performs computations on worksheet data and displays the results.
Software that is delivered via the Web is called _____
cloud software, Web-based software, Software as a Service (SaaS), or cloudware
microsoft office ribbon
arrived with office 2007, line of tabs with commands organized into groups located on tabs. Contextual tabs appear as needed and contain special commands.