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