Worksheets8th Technology Final Exam Study Guide
Total questions: 134
Worksheet time: 1hrs 20mins
What is the purpose of a word processor?
To create and edit images
To type, edit, save, and print text
To perform calculations and financial analysis
To organize information in a database
Which software is used for numbers and financial information?
Word processor
Spreadsheet
Database
Graphics software
What is the main function of a database?
To send and receive electronic mail
To create slide shows
To design products using CAD
To organize various types of information
What can you do with e-mail?
Create visual images
Perform calculations
Send electronic mail with attachments
Scan images or barcodes
Which software is used to create slide shows?
Presentation software
Scanner
Fax machine
GPS
Reorder the problem-solving process
Understand the task or need.
Consider solutions and list ideas
Make your selection from the list
Take action.
Evaluate
Match the following
Radio Frequency Identification or an automatic identification device that lets you store and retrieve information
RFID
a technique used to verify a person's fingerprints
Automated Fingerprint Identification
a computer with a touch-sensitive screen that can be up to four feet by six feet
touch-screen computer
a pen that captures handwritten notes and downloads them to the computer so that the text can be displayed on the monitor
digital ink pen
a pocket-sized card that can store data and process information
smart card
An E______ P______Display is a display or sign with the ability to update the information electronically
(a)
Match the following
the component in the body of the computer that stores all of your files and folders
hard drive
the central processing unit or part inside the body of the computer that enables the computer to function, sometimes referred to as the brain of the computer
CPU
interconnected computer networks throughout the world that everyone can use
Internet
a small mobile computer
laptop
Match the following
a computer program or a set of instructions for the hardware to perform
software
the main board in the body of the computer that contains chips and other components
motherboard
a group of computers that are interconnected in order to share information or documents
computer network
physical parts of the computer or technical equipment
hardware
An example of hardware is a(n) _____.
word processor
database
computer monitor
Components inside a computer such as CPU and motherboard are all examples of _____.
hardware
software
Match the following
software used to enhance photographs
image-editing software
software used make calculations
spreadsheet
software that organizes a collection of information
database
software used to type, edit, save, and print text
word processor
software used to create a slideshow
presentation software
Lydia used software to calculate the budget for each department. To create this budget, she used a _____.
spreadsheet
word processor
database
compact disk
Match the following
complete many types of tasks on a computer away from the office
laptop
design a building
CAD
create a company logo
graphics software
type a report
word processor
get directions to a customer's office
GPS
The software used to help run the computer hardware is the _____.
application software
programming language
system software
programming software
What is the purpose of a word processor?
To create and edit images
To type, edit, save, and print text
To perform calculations and financial analysis
To organize information in a database
Which software is used for numbers and financial information?
Word processor
Spreadsheet
Database
Graphics software
What is the main function of a database?
To send and receive electronic mail
To create slide shows
To design products using CAD
To organize various types of information
What can you do with e-mail?
Create visual images
Perform calculations
Send electronic mail with attachments
Scan images or barcodes
Which software is used to create slide shows?
Presentation software
Scanner
Fax machine
GPS
Reorder the problem-solving process
Understand the task or need.
Consider solutions and list ideas
Make your selection from the list
Take action.
Evaluate
Match the following
Radio Frequency Identification or an automatic identification device that lets you store and retrieve information
RFID
a technique used to verify a person's fingerprints
Automated Fingerprint Identification
a computer with a touch-sensitive screen that can be up to four feet by six feet
touch-screen computer
a pen that captures handwritten notes and downloads them to the computer so that the text can be displayed on the monitor
digital ink pen
a pocket-sized card that can store data and process information
smart card
An E______ P______Display is a display or sign with the ability to update the information electronically
(a)
Match the following
the component in the body of the computer that stores all of your files and folders
hard drive
the central processing unit or part inside the body of the computer that enables the computer to function, sometimes referred to as the brain of the computer
CPU
interconnected computer networks throughout the world that everyone can use
Internet
a small mobile computer
laptop
Match the following
a computer program or a set of instructions for the hardware to perform
software
the main board in the body of the computer that contains chips and other components
motherboard
a group of computers that are interconnected in order to share information or documents
computer network
physical parts of the computer or technical equipment
hardware
An example of hardware is a(n) _____.
word processor
database
computer monitor
Components inside a computer such as CPU and motherboard are all examples of _____.
hardware
software
Match the following
software used to enhance photographs
image-editing software
software used make calculations
spreadsheet
software that organizes a collection of information
database
software used to type, edit, save, and print text
word processor
software used to create a slideshow
presentation software
Lydia used software to calculate the budget for each department. To create this budget, she used a _____.
spreadsheet
word processor
database
compact disk
Match the following
complete many types of tasks on a computer away from the office
laptop
design a building
CAD
create a company logo
graphics software
type a report
word processor
get directions to a customer's office
GPS
The software used to help run the computer hardware is the _____.
application software
programming language
system software
programming software
removes text to the left of the cursor
backspace key
delete key
document
icon
word processing
removes text to the right of the cursor
backspace key
delete key
document
icon
word processing
electronic files
backspace key
delete key
document
icon
word processing
graphic representation that provides a command to the computer
backspace key
delete key
document
icon
word processing
creating, editing, formatting, and saving a document
backspace key
delete key
document
icon
word processing
term meaning:
show grouping of word processing tasks that can be performed
contextual tabs
Quick Access toolbar
ribbon
ruler
scroll bars
term meaning:
shortcut location for commonly used elements
contextual tabs
Quick Access toolbar
ribbon
ruler
scroll bars
term meaning:
organized commands used to modify documents
Zoom bar
Title bar
ribbon
ruler
scroll bars
term meaning:
used to align and measure content in a Word screen
Zoom bar
Title bar
ribbon
ruler
scroll bars
term meaning:
vertical and horizontal bars that are used to navigate through a document
Zoom bar
Title bar
ribbon
ruler
scroll bars
term meaning:
displays the name of the document in use
Zoom bar
Title bar
ribbon
ruler
scroll bars
term meaning:
allows users to enlarge or shrink a visual of a Word document
Zoom bar
Title bar
ribbon
ruler
scroll bars
options available in the Word application unless the user changes or modifies the
settings
default
save
save as
to store a document so it can be accessed at another time
default
save
save as
a method available to save a document as a new file name or file type
default
save
save as
a temporary storage location for information that is cut or copied in a document
Clipbaord
Copy
Cut
Paste
Style
to reproduce selected text
Clipbaord
Copy
Cut
Paste
Style
to remove selected text from a location
Clipbaord
Copy
Cut
Paste
Style
to place text from the clipboard in a specified location
Clipbaord
Copy
Cut
Paste
Style
a predefined format used for text that can include multiple font-formatting features
Clipbaord
Copy
Cut
Paste
Style
a font style that is darker and heavier than other fonts
bold
font
italic
subscript
superscript
a style of written text within a document
bold
font
italic
subscript
superscript
a font style that is slanted to the right
bold
font
italic
subscript
superscript
text that is slightly below the line of text
bold
font
italic
subscript
superscript
text that is slightly above the line of text
bold
font
italic
subscript
superscript
to remove unwanted parts from an image
crop
find
sort
replace
used to search for text or other content
crop
find
sort
replace
to alphabetize selected text or put numbers in numerical order
crop
find
sort
replace
changes text in a document with entered text
crop
find
sort
replace
in order of smallest to largest (1 to10) or alphabetical (A to Z) order
ascending order
banded rows
descending order
track changes
when odd and even rows are formatted differently in order to make tables easier to read
ascending order
banded rows
descending order
track changes
in order of largest to smallest (10 to 1) or reverse alphabetical (Z to A) order
ascending order
banded rows
descending order
track changes
marks all modifications made to the document so they can be reviewed at another time
ascending order
banded rows
descending order
track changes
a box that is in the intersection of a row and a column
cell
columns
footer
header
header row
a group of cells that are stacked vertically
cell
columns
footer
header
header row
text that reoccurs at the bottom of every page
cell
columns
footer
header
header row
text that reoccurs at the top of every page
cell
columns
footer
header
header row
the first row of a table that can be formatted differently than other rows in a table
cell
columns
footer
header
header row
a feature that automatically changes text or format based on options a user defines
AutoCorrect
SmartArt
table
WordArt
graphics used to visually communicate information, often used for graphical lists or process diagrams
AutoCorrect
SmartArt
table
WordArt
a combination of rows and columns that are used to arrange data
AutoCorrect
SmartArt
table
WordArt
decorative text that can be inserted into a document
AutoCorrect
SmartArt
table
WordArt
to remove unwanted parts from an image
crop
find
sort
replace
used to search for text or other content
crop
find
sort
replace
to alphabetize selected text or put numbers in numerical order
crop
find
sort
replace
changes text in a document with entered text
crop
find
sort
replace
in order of smallest to largest (1 to10) or alphabetical (A to Z) order
ascending order
banded rows
descending order
track changes
when odd and even rows are formatted differently in order to make tables easier to read
ascending order
banded rows
descending order
track changes
in order of largest to smallest (10 to 1) or reverse alphabetical (Z to A) order
ascending order
banded rows
descending order
track changes
marks all modifications made to the document so they can be reviewed at another time
ascending order
banded rows
descending order
track changes
a box that is in the intersection of a row and a column
cell
columns
footer
header
header row
a group of cells that are stacked vertically
cell
columns
footer
header
header row
text that reoccurs at the bottom of every page
cell
columns
footer
header
header row
text that reoccurs at the top of every page
cell
columns
footer
header
header row
the first row of a table that can be formatted differently than other rows in a table
cell
columns
footer
header
header row
a feature that automatically changes text or format based on options a user defines
AutoCorrect
SmartArt
table
WordArt
graphics used to visually communicate information, often used for graphical lists or process diagrams
AutoCorrect
SmartArt
table
WordArt
a combination of rows and columns that are used to arrange data
AutoCorrect
SmartArt
table
WordArt
decorative text that can be inserted into a document
AutoCorrect
SmartArt
table
WordArt
used to scroll through worksheets
worksheet navigation tools
Undo
Scroll box
Scroll bars
navigation keyboard shortcuts
command used to undo the last command performed
worksheet navigation tools
Undo
Scroll box
Scroll bars
navigation keyboard shortcuts
a rectangle in an Excel spreadsheet, where a column and row intersect
cell
cell address
cell reference
columns
go up and down (vertical)
workbooks
rows
formula bar
columns
worksheets
displays what’s truly in a cell
workbooks
rows
formula bar
columns
worksheets
go across (horizontal)
workbooks
rows
formula bar
columns
worksheets
What is the "Document Panel" above a document used for?
Spell check
Document formatting
To add and change the document properties
What does "Scale to Fit" do in spreadsheet printing?
Adjusts font size
Scales worksheets to print smaller or larger than the actual font size
Print area expansion
What are "Print Titles" in worksheet settings?
Bold column and row labels
A setting that repeats rows and/or columns on each page of a worksheet
Print area customization
What does "Print Preview" show in spreadsheet software?
Live editing mode
Active sheets
Displays the worksheet as it will look when printed
What is the "Print Area" in a worksheet?
Entire workbook
A selected portion of the worksheet that will be printed
Page break region
What does "Page Setup" include in spreadsheet software?
Cell formatting
Options for page settings such as margins, page orientation, and paper size
Print area settings
What is "Page Orientation" in page formatting?
Font style selection
Direction the text prints on the page
Page break option
What does "Page Break" determine in spreadsheet software?
Print area boundaries
Where a new page will start
Gridline visibility
What is the "Margins" in spreadsheet printing?
Data boundaries in a worksheet
White space left around the edges of the paper when a worksheet is printed
Formatting for header and footer
What do "Headings" refer to in a worksheet?
Bold text in cells
The column letters and row numbers in the worksheet
Page setup options
What are "Headers" in spreadsheet printing?
Page orientation settings
Text and/or graphics that print at the top of each page
Column and row labels
What is a "Footer" in the context of spreadsheet printing?
Top section of the worksheet
Text and/or graphics that print at the bottom of each page
Page formatting tool
the most commonly used workbook view, which displays the cells continuously with no gaps
normal view
workbook views
zoom level
zoom slider
What does 'Collaborate' mean?
To work jointly with others or together, especially in an intellectual endeavor.
To limit or control the scope of something.
Involving active participation.
A visual representation of information.
Which term describes a 'pre-designed format or layout'?
Restrict
Interactive
Template
Infographic
What does 'Efficiently' imply?
Capturing and maintaining attention.
Skilled in a particular activity.
Achieving maximum productivity with minimal wasted effort.
Easily understood or perceived.
Which word is defined as 'involving active participation or communication'?
Interactive
Consistent
Transparent
Creative
What does 'Proficient' best describe?
Capable of being modified or changed.
Skilled, competent, or adept in a particular activity.
Unchanging in behavior over time.
Occurring concurrently with something else.
Which word means: Capable of being modified, adjusted, or changed, typically using editing tools or software.
Which word means: Unchanging in behavior, effect, or quality over time; exhibiting uniformity or coherence.
What is an infographic?
An infographic is a visual representation of information or data designed to convey complex concepts or data quickly and clearly.
which words means: Capturing and maintaining the attention or interest of others; compelling or interesting.
Which word means: Characterized by originality, imagination, and inventiveness in thought, expression, or artistic endeavor.
What does it mean to Collaborate?
What is a template?
What does 'Typography' refer to?
The art and technique of arranging type to make written language legible and visually appealing
The arrangement of text and objects in a design
The adjustment of spacing between letters
A specific style within a typeface family
What does 'Alignment' in design refer to?
A set of fonts that share common design features
The arrangement or positioning of text and elements relative to each other
The adjustment of letter spacing
The technique of arranging type
In Typography, what is Hierarchy
Often involves using different sizes, weights, or styles of fonts to create visual contrast and guide the reader's attention
What is a set of one or more fonts, each composed of glyphs that share common design features
Typeface
What is the arrangement or positioning of text, objects, or elements relative to each other or to a specified reference point
What is the definition of a Font?
A specific style, weight, or variant within a typeface family.
A type of paper used for writing
A style of music notation
A type of computer virus
