Test 2

Question 1

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

Answer 1

they are also known as erasable 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

T/F: 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

Which of the following statements is incorrect?

Answer 9

Printer speed is measured in the number of words printed per minute

Question 10

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

Answer 10

Warm

Question 11

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

Answer 11

False; The numbers are aligned on the right and text is on the left.

Question 12

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

Answer 12

System Software

Question 13

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

Answer 13

#

Question 14

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

Answer 14

Legend

Question 15

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

Answer 15

Bar Code

Question 16

T/F: A function is a prewritten formula that performs a calculation.

Answer 16

True

Question 17

T/F: 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 17

False

Question 18

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

Answer 18

False

Question 19

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

Answer 19

ALU

Question 20

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

Answer 20

True

Question 21

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

Answer 21

Toggle

Question 22

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

Answer 22

True

Question 23

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

Answer 23

Cache Memory

Question 24

T/F: An MICR device senses the presence or absence of a mark, such as a pencil mark

Answer 24

False

Question 25

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

Answer 25

26