Test 1

Question 1

All of the following are true of DVD-ROM drives except

Answer 1

They are also known as erasable optical discs

Question 2

The column letter and row number combination used to identify a specific cell is known as the cell contents.

Answer 2

False

Question 3

The process of saving information to a secondary storage device is referred to as embedding.

Answer 3

False

Question 4

The hard disk’s disk surface is scratched and some or all of the data is destroyed when there is a

Answer 4

Head crash

Question 5

These programs guard your computer against malicious programs that may invade your computer system.

Answer 5

Antivirus Program

Question 6

________ refers to a computer’s ability to configure and use a device without human interaction.

Answer 6

Plug and Play

Question 7

In Excel, F61 is an absolute reference, and $F$61 is a relative reference.

Answer 7

False

Question 8

Dragging the fill handle activates the AutoFill feature if:

Answer 8

Excel recognizes the entry as one that can be incremented.

Question 9

A(n) _________ boot occurs when a computer is restarted without turning off the power.

Answer 9

Warm

Question 10

By default, numbers are aligned on the left, and text is aligned on the right.

Answer 10

False

Question 11

Software that allows your computer to interact with the user, applications, and hardware is called

Answer 11

Application software

Question 12

If a cell’s width is too narrow to properly displays the numeric contents of the cell, Excel displays the series of ________ symbols.

Answer 12

#

Question 13

A(n) ________ describes the symbols used within the chart to identify different data series

Answer 13

Legend

Question 14

A Universal Product code is read by what type of scanner?

Answer 14

Bar code

Question 15

A function is a prewritten formula that performs a calculation.

Answer 15

true

Question 16

When a formula containing relative references is copied, the cell references in the copied formula refer to the same cells that are referenced in the original formula.

Answer 16

False

Question 17

In Excel, the SUM function requires that the argument (the range) be included within parenthesis before the function name.

Answer 17

False

Question 18

The ________ performs two types of operatons: arithmetic and logical.

Answer 18

ALU

Question 19

Conditioning Formatting changes the appearance of a range of cells based on a set of conditions you specify.

Answer 19

tRUE

Question 20

A keyboard key, like Caps Lock, that turns a feature on or off is called a _____ key.

Answer 20

tOGGLE

Question 21

A range is a series of two or more adjacent cells in a column or rectangle group of cells.

Answer 21

True

Question 22

This type of memory improves processing by acting as a temporary high-speed holding area between the memory and the CPU.

Answer 22

Cache memory

Question 23

An MICR device senses the presence or absence of a mark, such as a pencil mark

Answer 23

False

Question 24

When Excel follows the order of operations, the formula 2 + 3 * 8, equals _____.

Answer 24

26