Computer Applications
resume assistant
A feature in Word with which you can see suggestions from LinkedIn to help you update your resume.
quick analysis tool
A feature that displays in the lower right corner of a selected range with which you can analyze your data by using Excel tools such as charts, color-coding, and formulas is called:
calculated field
A field that stores the value of a mathematical operation is:
server
A multiuser computer system that provides services, such as internet access, email, or file and print services, to client systems.
an enterprise fund
A municipal government fund that reports income and expenditures related to municipal services for which a fee is charged in exchange for goods or services is:
solid state storage
A non-mechanical storage format that stores data using flash memory on a chip.
binary number system (base 2)
A number system that has only two digits-0 and 1.
data marker
A pie slice is an example of:
notebook
A portable personal computer. Also referred to as a laptop.
section
A portion of a document that can be formatted differently from the rest of the document is a:
SUM function
A predefined formula that adds all the numbers in a selected range.
function
A predefined formula that performs calculations by using specific values in a particular order or structure.
slide
A presentation page that can contain text, pictures, tables, charts, and other multimedia or graphic objects.
notes page
A printout that contains the slide image on the top half of the page and notes that you have created in the Notes pane on the lower half of the page.
file fragmentation
A process that occurs as files are broken into small pieces that are stored in nonadjacent or noncontiguous clusters on the disk.
A professional networking website that focuses on business and employment-oriented services—a good place to build your professional identity.
basic input/output system
A program stored on a chip on the motherboard that is used to start up the computer.
thesaurus
A proofing tool that provides a list of words with similar meanings is the:
parameter query
A query that prompts you for criteria when it is run is a:
summary sheet
A worksheet where totals from other worksheets are displayed and summarized is a:
ISP
A(n) _______ is a company that offers internet access.
add-on
A(n) _______ is a third-party program that extends the functionality of a web browser.
function
A(n) ________ is prewritten in Excel to look at one or more values, perform an operation, and then return a value.
autofit
An Excel feature that adjusts the width of a column to fit the cell content of the widest cell in the column is:
workbook
An Excel file that contains one or more worksheets.
AVERAGE function
An Excel function that adds a group of values and then divides the result by the number of values in the group.
MAX function
An Excel function that determines the largest value in a range.
MIN function
An Excel function that determines the smallest value in a range.
MEDIAN function
An Excel function that finds the middle value that has as many values above it in the group as are below it.
bitcoin
An anonymous, digital, encrypted currency.
colon
For a calculated field, the new field name must be followed by:
artistic effects
Formats applied to images that make pictures resemble sketches or paintings are:
text effects
Formats applied to text that include shadows, reflections, glows, bevels, and 3-D rotations.
word processing
Microsoft Word is an example of which type of computer application?
aggregate functions
Min, Max, Avg, and Sum are examples of:
slide transitions
Motion effects that occur in Slide Show view when you move from one slide to the next during a presentation.
placeholder text
Non-printing text that holds a place in a document where you can type.
constant value
Numbers, text, dates, or times of day that you type into a cell.
Synchronous online communication
Online communication that happens in real time.
brackets []
Parameters need to be enclosed in_______
layout options
Picture formatting options that control the manner in which text wraps around a picture or other object.
touchscreen
Pointing devices, such as the mouse and ________, work by moving a pointer on the screen.
series
Related data points represented by data markers are referred to as the data:
cascade options
Relationship options that enable you to update records in related tables when referential integrity is enforced are known as:
contiguous
Slides that are adjacent to each other in a presentation are considered to be:
comparison operator
Symbols that evaluate each value to determine if it is the same (=), greater than (>), less than (<), or in between a range of values as specified by the criteria
system unit
The case that encloses and protects the power supply, motherboard, processor (CPU), and memory of a computer.
data type
The characteristic that defines the kind of data you can store in a field is the:
sheet tabs
The labels along the lower border of the workbook window that identify each worksheet are the:
AND
The logical operator that requires all criteria to be met to return a result is:
office presentation service
To present your Word document to others who can watch in a web browser, use:
screen
Using drag-and-drop to move text is most useful when both the text and the destination are on the same:
second
Using techniques that ensure the accuracy and consistency of data as it is entered into a table is the ________ principle of good database design.
cache memory
Very fast memory that is used to store frequently accessed information close to the processor.
user account control (UAC)
What Windows feature that will notify you before changes are made to your computer?
system restore
What Windows tool enables you to return the system to a previous state?
trojan horse
What appears to be a legitimate program but is actually malicious?
NTFS
What file system is the default on Windows 10 computers?
instant messaging
What form of online communication happens in real time between two people?
bot
What is a computer that is controlled by a master, and used to launch various types of attacks?
computer fraud
What is a scheme perpetrated over the Internet or by email that tricks a victim into voluntarily and knowingly giving money or property to a person?
cookie
What is a small text file placed on your computer when you visit a website that is used identify you when you return?
ethernet adapter
What is a wired network adapter with a port that resembles a telephone jack?
unicode
What is the binary code that can represent most currently used language characters as well as mathematical and graphic symbols?
the name of the report author
What should be on the first line of the first page of an MLA-style research paper?
802.11
What standards define the way data is transmitted over a Wi-Fi network?
bug
What term means a flaw in software programming?
logic bomb
What type of malware attack occurs when certain conditions are met?
wide area network (WAN)
What type of network spans multiple locations and connects multiple local area networks (LANs) over dedicated lines using routers?
netbook
What type of portable computer is the smallest?
patch
What type of software update that addresses individual problems as they are discovered?
brackets []
When creating a calculated field, the new field name must be followed by a colon and each field name that will be used in the expression must be enclosed within in its own pair of ________.
outermost
When creating a table sort on two or more fields, the first level of sorting is referred to as the ________ sort field.
what questions should this database be able to answer?
When designing a new database, the first question users should ask themselves is ________.
dimmed
When the body of a document is active, the footer or header text is ________.
equal
When you create a table, the width of all of cells in the table is:
left-aligned
When you type text in a cell it is ________.
Bcc:
Which field prevents multiple recipients from seeing each other's email addresses?
virus
Which form of malware replicates itself and needs a host file on which to travel?
switch
Which hardware device connects the devices on a LAN?
bitlocker
Which is a Windows feature that encrypts an entire drive?
the report author
Which of the following are included in the first four lines of a research paper?
Default spacing after paragraphs of 12 points
Which of the following is NOT a default setting of Word?
If you delete a footnote, the remaining footnotes are automatically renumbered.
Which of the following is TRUE about footnotes?
no extra space above or below paragraphs
Which of the following is one of the MLA standards for formatting text?
works cited
Which of the following titles is used for the list of sources in an MLA-style research paper?
$
Which symbol represents that a cell is an absolute cell reference in a function or formula?
RAM
Which type of memory stores the operating systems, programs, and data the computer is currently using
LCD
Which type of monitor consists of two layers of glass that are glued together with a layer of liquid crystals between them?
dye-sublimation
Which type of printer produces the highest-quality photo prints?
task manager
Which utility displays the processes running on a Windows computer?
single-spaced paragraph with 10-point Calibri font and no paragraph indents
Word's default style for footnote text is ________.
one range of labels and one range of values
You must select ________ on a worksheet to create a pie chart.
GPS
______ is a system of 24 satellites put into orbit by the US Department of Defense
adapter cards
______ plug directly into expansion slots on the motherboard and allow you to connect additional peripheral devices to a computer.
biometric
______ scanners read human characteristics such as fingerprints and retinas.
ada lovelace
_______ is considered to be the first computer programmer.
sorting
________ is the process of arranging data in a specific order based on the value in a field.
a function
________ performs calculations by using specific values that you insert in a particular order or structure.
vacuum tubes
________ resemble incandescent lights, give off a lot of heat, and are notoriously unreliable.
distributed computing
_________ share(s) the processing of a task across multiple computer systems.
mobile devices
_________ such as smartphones and tablets are small computers we carry with us.
hard drives
__________ are the principal mass-storage devices in a computer system.
A manual of standards for the design and writing of documents
what is a style guide?
formula
=2*(X*Y/2)
function
=Average(M1:M42)
relational
A ________ database is one where multiple collections of data are linked to one another.
query
A ________ is a database object that retrieves specific data from one or more database objects.
database
A ________ is an organized collection of data.
parameter
A ________ query prompts a user for criteria before running the query.
smartphone
A _____________ is an example of convergence.
microprocessor
A _______is a complex, integrated circuit.
placeholder
A box on a slide that holds title and body text or other content.
toggle
A button that can be turned on by clicking it once, and then turned off by clicking it again.
absolute
A cell reference that refers to a cell by its fixed position in a worksheet is referred to as being:
social networks
Facebook and LinkedIn are examples of __________.
learning tools
Features in Word that add visual changes to assist with reading fluency and comprehension are referred to as:
text alignment
11. The term that refers to the horizontal placement of text within a placeholder.
line chart
A chart type that displays trends over time is a:
style set
A collection of character and paragraph formatting that is stored and named is a:
style
A collection of formatting options that can be applied to a picture, text, or object.
RGB
A color model in which the colors red, green, and blue are added together to form another color.
freeze panes
A command that enables you to select one or more rows or columns and lock them in place.
text from file
A command to insert text from another file into your document is:
all-in-one computer
A compact desktop computer with the system unit integrated into the monitor.
between...and
A comparison operator that searches for values within a range is
computer zombie
A computer that is part of a botnet, controlled by a master, and used to launch various types of attacks.
track
A concentric circle created on a disk during low-level disk formatting.
editor
A digital writing assistant in Word that flags misspellings, grammatical errors, and writing style issues.
cover letter
A document that you send with your resume to provide additional information about your skills and experience is:
mobile application (app)
A downloadable program that extends the functionality of a mobile device.
ransomware
A form of malware that prevents you from using your computer until you pay a fine or fee.
worm
A form of self-replicating malware that does not need a host to travel.
conditional format
A format that changes the appearance of a cell based on a condition.
really simple syndication (RSS)
A format used for distributing web feeds that change frequently.
IF function
A function that uses a logical test to check whether a condition is met, and then returns one value if true and another value if false.
logical functions
A group of functions that test for specific conditions, and which typically use conditional tests to determine whether specified conditions are true or false.
cluster
A group of sectors where files are stored on a disk.
one-to-many relationship
A relationship between two tables, where one record in the first table corresponds to many records in the second table.
captcha
A series of letters and numbers that are distorted in some way.
table
A series of rows and columns that contains related data and that is managed independently from other data is an Excel:
font
A set of characters with the same design and shape is a:
referential integrity
A set of rules that ensures that the data between related tables is valid.
airplane mode
A setting that disables or turns off all network adapters on a device.
data bar
A shaded bar that provides a visual cue about the value of a cell relative to other cells is a:
USB
A single _____ port can connect up to 127 devices and is hot swappable
option clip
A single media file, such as art, sound, animation, or a movie.
black slide
A slide that displays at the end of every slide show to indicate that the presentation is over.
personal computer (PC)
A small microprocessor-based computer designed to be used by one person at a time.
hotfix
A software update that addresses individual problems as they are discovered.
COUNTIF function
A statistical function that counts the number of cells within a range that meet the given condition and which has two arguments—the range of cells to check and the criteria.
rotation handle
A symbol with which you can rotate a graphic to any angle and that displays above the top center sizing handle.
drag-and-drop
A technique by which you can move, by dragging, selected text from one location in a document to another.
byte
A unit of digital information that consists of 8 bits; used to represent a single character in modern computer systems.
is null
A user can add ________ to the criteria for a field in the design grid to return results where there is nothing in that field.
point
A value that originates in a worksheet cell and that is represented in a chart by a data marker is a data:
presenter view
A view that shows the full-screen slide show on one monitor while enabling the presenter to view a preview of the next slide, notes, and a timer on another monitor is:
*
A wildcard character that serves as a placeholder for one or more unknown characters is the:
relationship
An association that you establish between two tables based on common fields.
formula
An equation that performs mathematical calculations on values in a worksheet.
scanner
An input device that increases the speed and accuracy of data entry and converts information into a digital format that can be saved, copied, and manipulated
broadband
An internet connection speed greater than 25 Mbps.
domain name
An organization's unique name on the internet.
list level
An outline level in a presentation represented by a bullet symbol and identified in a slide by the indentation and the size of the text.
bulleted list
An unordered list.
cell address
Another name for a cell reference.
value
Another name for a constant value.
spreadsheet
Another name for a worksheet.
URL
Another term for the address of a website.
logical test
Any value or expression that can be evaluated as being true or false.
cell content
Anything typed into a cell.
file tab
Backstage view in Word is accessed by clicking the ________.
field properties
Characteristics of a field that control how the field displays and how data is entered are:
nonprinting characters
Characters that display on the screen to show the location of paragraphs, tabs, and spaces, but that do not print, are called:
justified
Column text that is aligned to both the left and right margins is referred to as:
embedded
Computers in traffic lights, at supermarket checkouts, and in appliances are examples of ______ computers.
criteria
Conditions in a query that identify the specific data for which you are looking are known as:
number values
Constant values consisting of only numbers.
store-and-forward
Email is a ____________ form of online communication.
TLDs (top-level domains)
Examples of _________ include .com, .gov, and .edu.
statistical functions
Excel functions, such as AVERAGE, that are useful to analyze a group of measurements
A short black line displays just above the footnote area.
How can you distinguish the footnotes in a document from the body of the report?
view
If the rulers do not display on your screen, click the ________ tab, and select the Ruler check box in the Show group.
> = 500
If users want to return a subset where a field is greater than or equal to 500, they should enter the criteria as ________.
the pie slices will be automatically updated
If you edit data in a worksheet that is associated with a pie chart ________.
subdatasheet
In Datasheet view, clicking the plus sign (+) displays the related records in this format.
innermost and outermost
In Datasheet view, when sorting using multiple fields, the field that is used for the last and first level of sorting
numbers
In Excel, row headings are identified by ________.
10
In MLA style, the font size for footnote text is ________ pt font.
slide pane
In Normal view, the pane that displays a large image of the active slide is the
note pane
In Normal view, the pane that displays below the Slide pane:
record
In a table, a ________ contains all of the categories of data pertaining to one person, place, event, thing, or idea.
field
In a table, a ________ is used for each single piece of information for every record, such as a first or last name.
field list
In the query design window, in the table area, the list of field names in a table.
star
In which local area network (LAN) topology is every node attached to a central device such as a switch or wireless access point?
microblog
In which type of social media are posts limited to a small number of characters and users post updates frequently?
digital subscriber line (DSL)
Telephone lines that are designed to carry digital signals and therefore are much faster than ordinary telephone lines; a broadband internet service.
header
Text that prints at the top of a sheet of slide handouts or notes pages is a:
database view
The Access view that displays data in columns and rows like an Excel worksheet is:
flash fill
The Excel command that recognizes a pattern in your data and then automatically fills in the values when you enter examples of the desired output is:
primary
The ________ key refers to the unique field that identifies each record.
total
The ________ row in the design grid can be used to calculate aggregate functions.
domain name system (DNS)
The ___________ allows you to type a URL in your browser instead of an IP address.
explode
The action of pulling out a pie slice from a pie chart for emphasis is called:
payload
The action or attack by a computer virus or malware.
category axis
The area along the bottom of a chart that identifies the categories of data is the:
layout
The arrangement of elements, such as title and subtitle text, lists, pictures, tables, charts, shapes, and movies on a PowerPoint slide is:
HTML
The authoring language that defines the structure of a webpage.
central processing unit
The brain of a computer housed inside the system unit on the motherboard.
no paragraph style
The built-in paragraph style—available from the Paragraph Spacing command—that inserts no extra space before or after a paragraph and uses line spacing of 1.
view buttons
The buttons in the lower right corner of the PowerPoint window that control the look of the presentation window are the:
internet of things (IoT)
The connection of the physical world to the Internet.
reading view
The dashed lines that display on your slide when you are moving an object are:
smart guides
The dashed lines that display on your slide when you are moving an object are:
underlying value
The data that displays in the Formula Bar is referred to as the:
general format
The default format that Excel applies to numbers is the:
primary key
The field that uniquely identifies a record in a table is known as the:
dateline
The first line in a business letter that contains the current date, and that is positioned just below the letterhead if a letterhead is used.
machine cycle
The four-part process used by the CPU to process each instruction: fetch, decode, execute, store. Also called the instruction cycle.
chart
The graphic representation of data in a worksheet.
peripheral device
The hardware components that serve the input, output, and storage functions of a computer are called
internet backbone
The high-speed connection point between networks.
world wide web
The hypertext system of information on the internet.
cell
The intersection of a column and a row.
motherboard
The main circuit board of a computer that houses the processor (CPU); contains drive controllers and interfaces, expansion slots, data buses, ports and connectors, BIOS, and memory.
one-to-many
The most common type of relationship in Access is ________.
inside address
The name and address of the person receiving a letter and positioned below the date line.
writers identification
The name and title of the author of a letter, placed near the bottom of the letter under the complimentary closing.
resolution
The number of horizontal pixels by vertical pixels on a display screen or image, for examplescanner
ARPANET
The original Internet was called ________.
letterhead
The personal or company information that displays at the top of a letter.
hardware
The physical components of a computer.
normal view
The primary editing view in PowerPoint.
foreign key
The primary key field is connected to this field in the related table to create a relationship.
run
The process in which Access looks for records in a table based on the fields and criteria in the query design, finds those records, and then displays the records in a datasheet.
formatting
The process of changing the appearance of the text, layout, and design of a slide.
filtering
The process of displaying only a portion of the data based on matching a specific value to show only the data that meets the criteria that you specify is called:
editing
The process of modifying a presentation by adding and deleting slides or by changing the contents of individual slides is referred to as:
fill handle
The small black square in the lower right corner of a selected cell.
cell margin
The space inside a table cell between the text and the cell borders—top, bottom, left, and right—is the:
ergonomics
The study of the relationship between workers and their workspaces.
anchor
The symbol that indicates to which paragraph an image is attached is a(n):
operators
The symbols with which you can specify the type of calculation you want to perform in an Excel formula are:
normal template
The template that serves as a basis for all Word documents is the:
eyedropper
The tool that captures the exact color from an object on your screen.
data
The unprocessed, or raw form, of information.
slide sorter view
The view in which all of the slides in your presentation display in miniature is:
join line
The visual cue in the Relationships window that indicates tables are related by connecting common fields.
detail sheets
The worksheets that contain the details of the information summarized on a summary sheet are called:
comparison operators
They symbols = , >, < and are known as:
sparklines
Tiny charts embedded in a cell that give a visual trend summary alongside your data are:
relationships
To connect two or more tables that have common fields, a user will need to establish and define the table ________.
first
To ensure that redundant data is NOT stored in a table is the ________ principle of good database design.
field size
To improve accuracy during user input, a designer can limit the number of characters a user can enter by adjusting the ________ under Field Properties.
