Computer 1 Exam Review

Data is represented as a series of ____, ____'s.

0s and 1s

When searching for a value that is less than 50, use the _____ symbol

<

What is not a comparison operators

<<

To apply an outline to the selected paragraph, use the ___ button in the Paragraph group on the HOME tab

Border

The _____ consists of transistors and electronic circuits on a silicon chip mounted on the motherboard

CPU

The ____ is mounted on the motherboard and is responsible for executing instructions to process data

Command bank

A _____ is a collection of related information

Database

A data file contains instructions for a computer on how to perform a specific task

False

An external peripheral device must have a cable that connects it to the computer

False

By using the & sign before a column letter and row number, you are designating an absolute reference

False

LAN stands for Lowell's Area Network

False

ROM is known as volatile memory

False

Sparklines differ from data bars in that the sparklines are always placed in the cells containing the value they represent

False

Speed Fill enters text based on patterns it finds in the data

False

The five essential components of data communications are a sender, a receiver, a channel, a protocol, and a medium

False

The part of the operating system you use when you work with a computer is called the SkyDrive

False

The sheets in a workbook are identified in the sheet tabs at the top of the workbook window

False

To display the current date, which is updated each time the workbook is reopened, use the TODAY function

False

You have to use every field from a table in a query

False

You use the Ctrl + Esc keyboard shortcut to switch any running application

False

_____ is background color that you can apply to one or more paragraphs and can be used in conjunction with a border for a more defined effect

Shading

_____ is/are the intangible components of a computer system

Software

When using the query design, you can add _____ in order to create statistics for groups of records

Subdatasheet

In Access, actual data is only part of the database. An access database also contains

Tables

A conditional format can make negative numbers red, with a light background and positive numbers black

True

A constant is a value in a formula that doesn't change

True

A crosstab query calculates statistics for data that is grouped by two different types of criteria

True

An adjacent range is a collection of separate ranges NOT next to each other

True

AutoFit changes the column width or row height to display the longest or tallest entry within the column or row

True

Cache memory is not a permanent storage medium

True

Every chart contains elements that can be formatted, added to the chart, or removed from the chart

True

Excel charts are either placed in their own chart sheets or embedded in a worksheet

True

Flash memory is similar to ROM except that it can be written to more than once.

True

Lookup tables can be constructed for exact match or approximate match lookups

True

RAM is memory that temporarily holds programs and data while a computer is on

True

The IF function is a logical function that returns one value if a condition is true, and returns a different value if that condition is false

True

The PMT function calculates the payment required in each period to pay back the loan

True

The formula bar displays the function or formula of the active cell

True

The intersection of a column and a row is a cell

True

Totals, averages, or other statistics can be added to reports

True

If you do not wish to have multiple duplicates appear in your results area, when creating a query select the property of ____ and change to yes

Unique Values

A report in Access is generated from a table or form and is easily created using the ____

Wizard

To toggle (switch from one to another) between applications you can use the following shortcut keys

[Alt] key pressed down and press the [Tab] key or arrows to switch between open applications

_____ makes it easier to enter repetitive text with patterns in cells

autocomplete

The properties of a primary key include

being unique

A computer interprets every signal as either "on" or "off" using numbers known as

binary digits

_____ means that data, applications, and even resources are stored on servers accessed over the Internet rather than on users' computers

cloud computing

A/an _____ is an electronic device that accepts information and instructions from a user, manipulates the information according to the instructions, displays the information in some way, and store the information for retrieval later

computer

A _____ contains the actual values that are plotted on the chart

data series

Every formula or function in Excel should begin with the * sign

false

In Access, columns are called

fields

To switch to ____ mode, you double-click the cell

in-cell editing

The four functions of a computer in order are

input, process, output, and storage

A computer can be compared to a human body with four basic functions

input, process, output, store

The ____ category of Excel functions returns (true-false) values

logical

If you press the shift+enter keys at the end of a line, this inserts a ___ line break

manual

You can import an existing spreadsheet to use as your data in an Access database by selecting the _____ table.

new

In the ____ group on the HOME tab, you use the Line and Paragraph Spacing button to adjust paragraph and line spacing

paragraph

The rules that establish an orderly transfer of data between sender and receiver are called

protocols

The Query window displays the ____ when you are in Design View

query design grid

In Access, rows are called

records

A(n) _______ connects one computer to other computers, enabling you to share data and resources with others

router

The ________ shows hidden characters like spaces, paragraph markers, or tab marks

show/hide button

Software can be divided into two major categories: ____ and ______

systems and application

Access offers ____ fields as one of its data types

text

The page layout tab displays options for adjusting....

the margins of your document

If you click the ______ button on an application, the application will reverse your last action

undo

In common usage, the term "PC" refers to computers that ______

use microsoft windows