Computer concepts
Microsoft _ is the component of Microsoft Office best suited for creating documents such as letters and reports.
Word
The file extension .docx is associated with which Microsoft Office program?
Word
Generally, a mail merge operation uses these two documents.
a main document and a data source
The Report Wizard button is located on the __ tab
Create
The keyboard shortcut for cutting the selection and placing it on the Clipboard is
Ctrl + X
To move a section of text from one part of your document to another, you first selective text then click the _.
Cut Button
__ is what you put into a computer; __ is what you get out of it
Data; Information
Use the __ button to return a bullet to its previous level.
Decrease List Level
When you create a presentation, you have the option to start with one of PowerPoint's __ templates
Design
In a numbered or bulleted list, each time you press _, a new number or bullet will be inserted before that item on the list
Enter
Microsoft __ is the component of the Microsoft Office suite best suited for working with numbers and formulas.
Excel
When editing a cell address, pressing ____ causes Excel to insert dollar symbols in front of the row and column number immediately to the left of the insertion point.
F4
The __ feature makes is easy to replicate formats from one test selection to another.
Format Painter
A(n) __ lets you use their technology (servers and software) to connect to the Internet for a fee
Internet service provider (ISP)
What makes a digital device "peripheral"
It is not built into the computer
__ orientation prints a worksheet on the page sideways.
Landscape
The __ Pane contains tools for working tables, queries, forms, and reports
Navigation
__ orientation prints a worksheet on a vertically oriented page.
Portait
A microprocessor temporarily stores data and programs while you are using them in __
RAM
The __ is a holding area for the files that you have deleted from your PC's hard disk
Recycle Bin
Which object must you have to do anything in Access?
Table
__ is the term that describes the tendency of technical devices to take on each other's functions
Technological convergence
A(n) __ reference does not change, and will always refer to the same cell, even after the formula is copied or moved.
absolute
Formatting options can be applied to
all the above
00110000 and 01000010 are examples of __ codes
binary
During the __ process, the PC preforms diagnostic tests to make sure that the keyboard, storage devices, RAM, and microprocessor are functioning correctly
boot
Binary digits (bits) are assembled into 8- bit collections called
bytes
What does Excel's Freeze Panes do?
causes the specified rows and columns to remain fixed while scrolling
The "box" created by the intersection of a row and a Column in a word table is called a
cell
A range is written with the first cell reference, a(n) ___, and then the last cell reference
colon
In a worksheet, __ are typically labeled with letters
columns
A(n) __ determines what kind of data can be entered into a field.
data type
Large collections of data are called __.
databases
A (n) tab stop aligns numbers with the decimal at the tab location
decimal
You press the __ to delete the character to the right of the insertion point
delete key
Data sorted in __ order will be arranged in reverse alphabetical order.
descending
A _ is a pre-formatted document that can be used as the foundation for creating a new document.
document template
When the first letter of the first word of a paragraph is enlarged and set into the paragraph, it is called a(n)
drop cap
A(n) __ contains a single unit of information.
field
A(n) __ is a collection of data that has a name and is stored on a hardware device
file
What is the green square at the bottom right corner of an active cell
fill handle
The use of __ allows you to group files for east retrieval
folders
A __ is text that appears at the bottom of every page
footer
A(n) __ specifies how to add, subtract, multiply, divide, or otherwise calculate the values in a worksheet cell
formula
Software products that are shared at no cost are called
freeware
A ___ is a predefined formula you can use in addition to writing your own formulas.
function
A wavy blue line indicates a
grammar mistake
The physical components of a computer are referred to as __
hardware
A computer mouse and keyboard are examples of __ devices
input
A __ is any text entered into a cell of a worksheet
label
__ are typically used in a table of contents to associate a page number with the appropriate chapter or heading
leaders
By default, labels are aligned on(in) the __ of a cell
left edge
A rectangle of dashes appearing around a cell is called a ___.
marquee
A __ is used to convert the digital signals from your computer into analog signals that can travel over cable or telephone lines
modem
The __ is the core piece of software on your computer
operating system
A __ chart illustrates the proportion of parts to a whole.
pie
Microsoft __ is the component of the Microsoft Office suite best suited for creating visual backdrop for speeches and oral presentation.
powerpoint
A(n) __ key is a field that uniquely identifies each record.
primary
A __ is a rectangular-shape block of cells in an Excel worksheet
range
A cell reference that changes when a formula is copied or moved is called a __ reference.
relative
A database __ is typically q printed document containing data selected from a database.
report
By default, values and formulas are aligned on(in) the __ of a cell.
right edge
In worksheet, __ are typically labeled with numbers
rows
The first step in creating an Excel chart is to
select the range of cells containing the data to be charted
Mainframe computers are typically used as
servers
The small squares that appear on an object's borders are called __
sizing handles
The __ is a template you can modify to create a consistent look for your presentation
slide master
The four operations that comprise the information processing cycle are input, process, output and ___
storage
Setting a __ provides an easy way to align text in columns
tab
A ___ is a grid consisting of rows and colums
table
which of the following are text attributes?
text color, bold, font
When text flows around a picture, it is known as
text wrapping
A(n) __ is a collection of professionally selected slide color schemes, fonts, graphic accents, and background colors
theme
A(n) __ is an effect that specifies how a slide replaces that previous slide during a presentation.
transition
A(n) __ is a number that you intend to use in a calculation and that is entered into a cell of a worksheet
value
Possible spelling errors are indicated with a(n) __
wavy red line
The largest network in the world, connecting millions of people is the __
wide area network
Each __ is represented by a tab at the bottom of the Excel window
worksheet
If a column is too narrow, numbers might be displayed as __.
####
Type a ___ before a number to enter a negative value
-
What is the extension for Access?
.accdb
PowerPoint presentation are saved with a(n) __ extension
.pptx
In a Word 2019 document, the detail margins are ___
1 inch
By default, the line spacing in Word 2019 is set at
1.08
Which of the following is a formula containing an absolute reference?
=B4-$C$1
_ is the design or typeface of each character.
A font
__ is the component of the Microsoft Office suite best for working with large collections of data
Access
When using the report Wizard, click the __ button to Dort data from A to Z
Ascending
Use the ___ button to quickly create a function to calculate the total of a column or row of cells.
AutoSum
Cell __ is located in the second column of the third row
B3
Typically, the device letter for a hard disk drive is __
C
The "brain" of the computer is known as __
CPU
What is the default font used by Word?
Calibri
When you create a new presentation, a(n) __ slide is generated for you.
Title
The Form __ helps you design an on-screen form in which you can enter and manipulate data for each record of a database
Wizard
Which of the following types of malware open a back door to your computer for malicious hackers
Trojan horse