Test 2 Flashcards
All of the following are true of DVD-ROM drives except
they are also known as erasable discs
The column letter and row number combination used to identify a specific cell is known as the cell contents.
False
The process of saving information to a secondary storage device is referred to as embedding.
False
The hard disk’s disk surface is scratched and some or all of the data is destroyed when there is a
Head crash
These programs guard your computer against malicious programs that may invade your computer system.
Antivirus program
________ refers to a computer’s ability to configure and use a device without human interaction.
Plug and Play
T/F: In Excel, F61 is an absolute reference, and $F$61 is a relative reference.
False
Dragging the fill handle activates the AutoFill feature if:
Excel recognizes the entry as one that can be incremented.
Which of the following statements is incorrect?
Printer speed is measured in the number of words printed per minute
A(n) _________ boot occurs when a computer is restarted without turning off the power.
Warm
By default, numbers are aligned on the left, and text is aligned on the right.
False; The numbers are aligned on the right and text is on the left.
Software that allows your computer to interact with the user, applications, and hardware is called
System Software
If a cell’s width is too narrow to properly displays the numeric contents of the cell, Excel displays the series of ________ symbols.
#
A(n) ________ describes the symbols used within the chart to identify different data series.
Legend
A Universal Product code is read by what type of scanner?
Bar Code
T/F: A function is a prewritten formula that performs a calculation.
True
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.
False
In Excel, the SUM function requires that the argument (the range) be included within parenthesis before the function name.
False
The ________ performs two types of operatons: arithmetic and logical.
ALU
Conditioning Formatting changes the appearance of a range of cells based on a set of conditions you specify.
True
A keyboard key, like Caps Lock, that turns a feature on or off is called a _____ key.
Toggle
A range is a series of two or more adjacent cells in a column or rectangle group of cells.
True
This type of memory improves processing by acting as a temporary high-speed holding area between the memory and the CPU.
Cache Memory
T/F: An MICR device senses the presence or absence of a mark, such as a pencil mark
False
When Excel follows the order of operations, the formula 2 + 3 * 8, equals _____.
26
